Coppermine 1.5.20 and Final extract

[sebvillers]

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.

[Αndré]

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.

[sebvillers]

Hello,
thank you for your answer : I had never used the debug mode...
Here is the error message :

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

[Αndré]

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.

[sebvillers]

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 :

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 :

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

Regards

[Αndré]

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

[Cath22]

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.

[Αndré]

Try if it works when you remove

Code Select Expand

ENGINE=MyISAM