Problem with Final Extract plugin for cpg 1.5.x

[Jumbobeef]

Problem with Final Extract plugin for cpg 1.5.x

http://forum.coppermine-gallery.net/index.php/topic,62665.0.html

(can't post on that tread for some reason....?)

I uploaded the unzipped file via FTP but when I try to install, I get:

Could not determine the version requirements for this plugin. This is usually an indicator that the plugin was not designed for your version of Coppermine and might therefore crash your gallery. Continue anyway (not recommended)? (Final Extract for cpg1.5.x)

My version is: 1.5.20

Thanks.

[phill104]

IIRC, the final extract plugin had a number of problems and hence the thread is locked. I just tried to install it and failed with a number of issues so it does appear that some work would be involved to get it to work as it should. Maybe one of the other devs can remember why we locked that particular plugin?

[Αndré]

Where do you both downloaded the plugin and what's the exact version number? The version number in the SVN repository doesn't match the version attached to the plugin announcement thread and our download section (there's also some confusion in that thread regarding the different versions 1.x and 2.x).

[phill104]

I downloaded from the thread. It seems there are a few problems with that version. Not got time to go through them all now but if we can get a working version together I will spend some time tidying up the thread.

[Αndré]

I'll have a closer look at the both available versions soon. I recently pointed some people to that plugin, curiously enough nobody reported any issue.

[phill104]

First run it failed with unable to connect to its db table as for some reason it didn't create. Tried again and it failed because it had already created the fex item in the config table (not sure why we have no check) but manually deleting it worked but ended up back with the initial failure. Manually creating the db table works.

[Αndré]

I just downloaded version 1.2 from the plugin announcement thread and installation worked without any issue in my tested.

First run it failed with unable to connect to its db table as for some reason it didn't create

Can you please post the exact error message? Can you please also check what happens when you remove

Code Select Expand

TYPE=MyISAM
from schema.sql? Thank you.

[phill104]

Andre,

After hitting the install button I get

While executing query '
















CREATE TABLE IF NOT EXISTS `cpg15x_final_extract_config` (
  `Group_Id` varchar(40) NOT NULL default '',
  `home` varchar(255) NOT NULL default '',
  `login` varchar(255) NOT NULL default '',
  `my_gallery` varchar(255) NOT NULL default '',
  `upload_pic` varchar(255) NOT NULL default '',
  `album_list` varchar(255) NOT NULL default '',
  `lastup` varchar(255) NOT NULL default '',
  `lastcom` varchar(255) NOT NULL default '',
  `topn` varchar(255) NOT NULL default '',
  `toprated` varchar(255) NOT NULL default '',
  `favpics` varchar(255) NOT NULL default '',
  `search` varchar(255) NOT NULL default '',
  `my_profile` varchar(255) NOT NULL default '',

  PRIMARY KEY  (`Group_Id`)
)TYPE=MyISAM' in plugins\final_extract\codebase.php on line 64

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 17

So the installation fails. If you then try and install again which is something I am sure people will try it then crashes the gallery completely with.

While executing query 'SELECT home,login,my_gallery,upload_pic,album_list,lastup,lastcom,topn,toprated,favpics,search,my_profile FROM cpg15x_final_extract_config WHERE Group_Id=3' in plugins\final_extract\include\init2.inc.php on line 20
mySQL error: Table 'coppermine.cpg15x_final_extract_config' doesn't exist

So manual removal is the only way.

[Αndré]

So

remove

Code Select Expand

TYPE=MyISAM
from schema.sql

should fix the error after hitting the install button. Can somebody please confirm that?

[phill104]

Yep, that works as suspected.

Should we simply replace it with - ENGINE=MyISAM or in this case do we not need ISAM at all?

[Αndré]

As we don't set the database engine for Coppermine, we should also use the database server's default for plugins IMHO.

[phill104]

As we don't set the database engine for Coppermine, we should also use the database server's default for plugins IMHO.

Agreed.

[Αndré]

I just attached version 1.3 to the initial post of the plugin announcement thread. It should fix the installation issue as discussed. There are still a lot of differences to the version in our SVN repository.