Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Problem with Final Extract plugin for cpg 1.5.x  (Read 8247 times)

0 Members and 1 Guest are viewing this topic.

Jumbobeef

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Problem with Final Extract plugin for cpg 1.5.x
« 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.
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4822
    • Windsurf.me
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #1 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?
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #2 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).
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4822
    • Windsurf.me
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #3 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.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #4 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.
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4822
    • Windsurf.me
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #5 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.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #6 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.
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4822
    • Windsurf.me
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #7 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.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #8 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?
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4822
    • Windsurf.me
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #9 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?
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #10 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.
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4822
    • Windsurf.me
Re: Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #11 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.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: Problem with Final Extract plugin for cpg 1.5.x
« Reply #12 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.