Changed servers, can't move C5? Please help!
Permalink
Hey guys, I recently switched servers over the past couple days from a free host to a paid webhost. My new webhost has cPanel, whereas my old free hosting just had some really cheesy cpanel ripoff.
Anyways, did a FULL site backup, as well as a FULL mysql database backup from my old server, and I restored both the full site backup as well as the database to my new server from cpanel.
I was sure to change the /config/site.php file and update it with the new database name, user and password, as well as using "localhost" for the database server...I also made sure to allow ALL privileges for my DB user to the DB.
But when I try to visit my site, this is the error I get:
NOTE: My ORIGINAL database name (from the free host server) was called "a9712442c5"...after I backed it up and restored it to my new server, it renamed it as "paulrit_a9712442c5" as you can see at the beginning of the error.
Can someone please help me with this or tell me what I need to do to fix it?
PS - I've already searched the forums, and I've found a few topics on similar issues but nothing I've found has solved my problem...now I'm starting to get antsy and am wondering if it was worth upgrading to the paid service afterall now that my site won't work :( Please help me!
Anyways, did a FULL site backup, as well as a FULL mysql database backup from my old server, and I restored both the full site backup as well as the database to my new server from cpanel.
I was sure to change the /config/site.php file and update it with the new database name, user and password, as well as using "localhost" for the database server...I also made sure to allow ALL privileges for my DB user to the DB.
But when I try to visit my site, this is the error I get:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'paulrit_a9712442c5.Config' doesn't exist] in EXECUTE("select cfValue from Config where cfKey = 'PERMISSIONS_MODEL'") ' in /home/paulrit/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/paulrit/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(918): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'paulrit_...', 'select cfValue ...', false, Object(ADODB_mysql)) #1 /home/paulrit/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(874): ADOConnection->_Execute('select cfValue ...') #2 /home/paulrit/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1472): ADOConnection->Execute('select cfValue ...', Array) #3 [internal function]: ADOConnection->GetRow('select cfValue ...', Array) #4 /home/paulrit/public_html/concrete/libraries/database.php(62): call_user_func_array(Array, Array) #5 [internal function]: Database->__call('GetRow', Array) #6 /home/paulrit/public_html/co in /home/paulrit/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
NOTE: My ORIGINAL database name (from the free host server) was called "a9712442c5"...after I backed it up and restored it to my new server, it renamed it as "paulrit_a9712442c5" as you can see at the beginning of the error.
Can someone please help me with this or tell me what I need to do to fix it?
PS - I've already searched the forums, and I've found a few topics on similar issues but nothing I've found has solved my problem...now I'm starting to get antsy and am wondering if it was worth upgrading to the paid service afterall now that my site won't work :( Please help me!
Have you seen this thread?
http://www.concrete5.org/community/forums/installation/installation...
You might check the case of the tables in your DB to see if they are mixed case. If you old host was case insensitive maybe they came across all lower case in the SQL export.
If this is the case, I don't know if there is an easy way to fix it or not. You might have to drop your new database, manually fix the case of all the tables in your SQL export file and then reimport. Maybe someone else knows a better way to do this.