move webserver -> update MySQL dbHostName move webserver -> update MySQL dbHostName
 

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

move webserver -> update MySQL dbHostName

Started by Freeco, January 20, 2007, 02:49:18 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Freeco

In december my host moved my site from a slower server to his main webserver. I simply had to update the hostname in my ASP files, phpBB and my MySQL client.

I guess since the move I have some problems with CPG... When someone wants to create/order an album, following error appears:
QuoteCritical error
There was an error while processing a database query.
While executing query "INSERT INTO cpg148_albums (category, title, uploads, pos) VALUES ('10009', 'test album', 'NO',  '1')" on 0
mySQL error: Field 'description' doesn't have a default value
First I thought the folder rights weren't moved correctly. I notified my host, as I can't change folder rights myself, and he corrected them. It didn't solve the problem though. The same error appears when trying again.
When I tried executing the query "INSERT INTO cpg148_albums (category, title, uploads, pos) VALUES ('10009', 'test album', 'NO',  '1')" from a MySQL client there's no problem at all...  ???
Am I correct to think that I also have to update the hostname in CPG? I found file config.php that has "$dbhost = 'old hostname'", which I changed to the new name and uploaded it. No change though... :-\

What am I missing here? Is there some other file I have to update? Or would an update from 1.4.8 to 1.4.10 do the trick?

Nibbler

It's because MySQL is setup differently on your new server (strict mode is enabled). I think this was corrected in 1.4.10, but not 100% sure. Updating is mandatory anyway.

Freeco

solved after updating the hostname in config.inc.php and upgrading to 1.4.10
tnx!