Errors upgrading database Errors upgrading database
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Errors upgrading database

Started by CGPhotos, September 27, 2006, 07:19:08 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

CGPhotos

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

Nibbler

Did you manually change the table prefix in include/config.inc.php?

CGPhotos

no, since I have no idea what you said   ;D  Do I need to?

Nibbler

No. What were you upgrading from and why did you use cpg149_ as the prefix?

CGPhotos

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?

Sami

check your table prefix under DB and change the config setting to meet that
‍I don't answer to PM with support question
Please post your issue to related board