forum.coppermine-gallery.net

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