coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: CGPhotos on September 27, 2006, 07:19:08 PM

Title: Errors upgrading database
Post by: CGPhotos on September 27, 2006, 07:19:08 PM
When I completed the upgrade.php this was at the end

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wxnjjdkd/public_html/cpg149/update.php on line 47

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wxnjjdkd/public_html/cpg149/update.php on line 50



when I clicked on "Check versions" this is what i got:

FATAL ERRER
While executing query "SELECT * FROM cpg149_config" on 0

mySQL error: Table 'wxnjjdkd_copp1.cpg149_config' doesn't exist
Title: Re: Errors upgrading database
Post by: Nibbler on September 27, 2006, 08:46:40 PM
Did you manually change the table prefix in include/config.inc.php?
Title: Re: Errors upgrading database
Post by: CGPhotos on September 27, 2006, 08:49:12 PM
no, since I have no idea what you said   ;D  Do I need to?
Title: Re: Errors upgrading database
Post by: Nibbler on September 27, 2006, 08:51:26 PM
No. What were you upgrading from and why did you use cpg149_ as the prefix?
Title: Re: Errors upgrading database
Post by: CGPhotos on September 27, 2006, 09:45:01 PM
Sorry if this reply comes through twice, I had a server error last time.

I am actually only upgrading the database.  I have a 1.3.3 version on one domain/server and installed 1.4.9 on a different domain/server and updated the theme and now I need to move the pics and users over to the new one.  I deleted the 149 in in the database and imported the 133 then ran the upgrade.php and this is when I ended up with these problems.  I was hoping I was on the right track  ;D. 

I have the  cgp149 prefix as that is what it unzippes as and I didnt change it.....do I need to?
Title: Re: Errors upgrading database
Post by: Sami on September 28, 2006, 08:15:45 AM
check your table prefix under DB and change the config setting to meet that