Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: Bill Roberts on February 28, 2009, 02:47:10 AM

Title: Redundant database tables after upgrade
Post by: Bill Roberts on February 28, 2009, 02:47:10 AM
I just upgraded to 1.4.20 and it works!

Now I have what appears to be a duplicate set of tables in the database, one prefixed cpg14x and one prefixed cpg132.

Are they redundant and can I safely drop the cpg132 tables?
Title: Re: Redundant database tables after upgrade
Post by: Nibbler on February 28, 2009, 04:10:23 PM
That means you didn't upgrade correctly. Check include/config.inc.php and see what prefix Coppermine is actually using.
Title: Re: Redundant database tables after upgrade
Post by: Bill Roberts on March 01, 2009, 08:35:55 AM
// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                'cpg132_';

Can I edit the file to correct it?

Or is it more complicated?
Title: Re: Redundant database tables after upgrade
Post by: Nibbler on March 01, 2009, 05:20:46 PM
Don't change the file. That means you can drop the cpg14x tables. Check them first though to make sure they don't have anything you want.
Title: Re: Redundant database tables after upgrade
Post by: Bill Roberts on March 01, 2009, 06:33:06 PM
thanks
Text only | Text with Images