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: Coppermine 1.5.20 and Final extract  (Read 6788 times)

0 Members and 1 Guest are viewing this topic.

sebvillers

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
Coppermine 1.5.20 and Final extract
« on: June 10, 2012, 08:59:57 am »

Hello,
Having installed 1.5.20, I wanted to add 'final_extract_v1.2' plugin : a white screen appears and the message 'Critical Error' displays - > then Coppermine becomes inaccessible.
In order to get Coppermine working again, it is necessary to delete the 'final_extract folder in 'plugins'.
What is to be done to get 'final_extract' working with Coppermine 1.5.20 ?
Thank you for your help.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: Coppermine 1.5.20 and Final extract
« Reply #1 on: June 14, 2012, 02:40:07 pm »

Enable debug mode and then install the plugin again to get an extended error message. Without that message it's impossible to say why it doesn't work for you.
Logged

sebvillers

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
Re: Coppermine 1.5.20 and Final extract
« Reply #2 on: June 17, 2012, 04:53:03 pm »

Hello,
thank you for your answer : I had never used the debug mode...
Here is the error message :
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=1' in plugins/final_extract/include/init2.inc.php on line 20
mySQL error: Table 'vienne363.cpg15x_final_extract_config' doesn't exist

But I do not know how to solve this problem...
Regards
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: Coppermine 1.5.20 and Final extract
« Reply #3 on: June 18, 2012, 03:05:51 pm »

It seems that the required tables haven't been created during plugin installation. To execute the installer a second time, you need to uninstall the plugin. As it seems that this is currently not possible in your gallery, you need to remove the corresponding line in the plugins table in your gallery's database with a tool like phpMyAdmin.
Logged

sebvillers

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
Re: Coppermine 1.5.20 and Final extract
« Reply #4 on: June 19, 2012, 12:38:11 pm »

Indeed, the table is not created during the installation of this plugin.
I had to do it with PhpMyAdmin so that Final Extract works, using these lines :

Quote
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`)
)ENGINE=MyISAM DEFAULT CHARSET=latin1;

Now, the debug mode shows only one error :

Quote
/plugins/final_extract/include/init2.inc.php
    Warning line 24: mysql_free_result(): supplied argument is not a valid MySQL result resource

Regards
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: Coppermine 1.5.20 and Final extract
« Reply #5 on: June 19, 2012, 01:57:37 pm »

Don't forget to manually add the data from basic.sql, too.
Logged

Cath22

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 77
    • Fotofantastic
Re: Coppermine 1.5.20 and Final extract
« Reply #6 on: June 28, 2012, 11:20:25 pm »

I recently saw this happening aswell AND it also happens with MiniCMS. I have one testsite and one production site. It works fine on the test, but gave the Critical error on the production site. While I have completely the same setup on both, the only difference so far I found is that they are on different servers, with different MySQL,

the testserver is running with MySQL version 5.0.91, the productionserver is running with MySQL version 5.5.14.

Its like some lines in the SQL statements are not accepted anymore on the newer MySQL????

I managed to solve the problem by importing by hand the necessary lines into the database.
Logged
qui custodiet ipsos custodes

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15760
Re: Coppermine 1.5.20 and Final extract
« Reply #7 on: June 29, 2012, 08:40:58 am »

Try if it works when you remove
Code: [Select]
ENGINE=MyISAM
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.