forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 plugins => Topic started by: Jumbobeef on April 15, 2013, 05:56:25 pm

Title: Problem with Final Extract plugin for cpg 1.5.x
Post by: Jumbobeef on April 15, 2013, 05:56:25 pm
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:

Quote
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.
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Phill Luckhurst on April 15, 2013, 07:19:42 pm
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?
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Αndré on April 16, 2013, 09:27:09 am
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).
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Phill Luckhurst on April 16, 2013, 10:51:10 am
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.
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Αndré on April 16, 2013, 10:56:41 am
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.
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Phill Luckhurst on April 16, 2013, 11:54:05 am
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.
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Αndré on April 16, 2013, 12:09:35 pm
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]
TYPE=MyISAMfrom schema.sql? Thank you.
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Phill Luckhurst on April 17, 2013, 09:16:38 am
Andre,

After hitting the install button I get

Quote
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.

Quote
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.
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Αndré on April 17, 2013, 09:21:05 am
So
remove
Code: [Select]
TYPE=MyISAMfrom schema.sql
should fix the error after hitting the install button. Can somebody please confirm that?
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Phill Luckhurst on April 17, 2013, 10:50:35 am
Yep, that works as suspected.

Should we simply replace it with - ENGINE=MyISAM or in this case do we not need ISAM at all?
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Αndré on April 17, 2013, 10:55:51 am
As we don't set the database engine for Coppermine, we should also use the database server's default for plugins IMHO.
Title: Re: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Phill Luckhurst on April 17, 2013, 11:05:54 am
As we don't set the database engine for Coppermine, we should also use the database server's default for plugins IMHO.

Agreed.
Title: Re: Problem with Final Extract plugin for cpg 1.5.x
Post by: Αndré on April 18, 2013, 03:51:12 pm
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.