Moving my site from local to a distant host (ovh)
Permalink
Hello,
I've created my website on local and everything is working fine. I've moved it to a new host (ovh)and it doesn't work. I followed the instructions listed in a similar post:
1.Get a copy of the database.
2.Get the correct files.
3.Put your files in the new environment.
4.Create a new, empty database in the new environment and import the exported database from the first step.
5.Modify your configuration file for the new site.
After doing all these, i have the following error message:
----------------------------
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'eziri.Config' doesn't exist] in EXECUTE("select * from Config where uID = 0 order by cfKey asc") ' in /homez.548/eziri/www/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /homez.548/eziri/www/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'eziri.Co...', 'select * from C...', false, Object(ADODB_mysql)) #1 /homez.548/eziri/www/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('select * from C...', false) #2 /homez.548/eziri/www/concrete/libraries/database.php(75): ADOConnection->Execute('select * from C...') #3 /homez.548/eziri/www/concrete/models/config.php(151): Database->__call('Execute', Array) #4 /homez.548/eziri/www/concrete/models/config.php(151): Database->Execute('select * from C...') #5 /homez.548/eziri/www/concrete/models/config.php(138): ConfigStore->load() #6 /homez.548/eziri/www/concrete/models/config.php(48): in /homez.548/eziri/www/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
----------------------------------
I've been strugling more than a week to find a solution and have not found it. Can anybody help me please!
Thanks for your support,
Ziri
I've created my website on local and everything is working fine. I've moved it to a new host (ovh)and it doesn't work. I followed the instructions listed in a similar post:
1.Get a copy of the database.
2.Get the correct files.
3.Put your files in the new environment.
4.Create a new, empty database in the new environment and import the exported database from the first step.
5.Modify your configuration file for the new site.
After doing all these, i have the following error message:
----------------------------
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'eziri.Config' doesn't exist] in EXECUTE("select * from Config where uID = 0 order by cfKey asc") ' in /homez.548/eziri/www/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /homez.548/eziri/www/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'eziri.Co...', 'select * from C...', false, Object(ADODB_mysql)) #1 /homez.548/eziri/www/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('select * from C...', false) #2 /homez.548/eziri/www/concrete/libraries/database.php(75): ADOConnection->Execute('select * from C...') #3 /homez.548/eziri/www/concrete/models/config.php(151): Database->__call('Execute', Array) #4 /homez.548/eziri/www/concrete/models/config.php(151): Database->Execute('select * from C...') #5 /homez.548/eziri/www/concrete/models/config.php(138): ConfigStore->load() #6 /homez.548/eziri/www/concrete/models/config.php(48): in /homez.548/eziri/www/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
----------------------------------
I've been strugling more than a week to find a solution and have not found it. Can anybody help me please!
Thanks for your support,
Ziri
John has given you the answer. It is hell - my first site did the same thing, need to fix the lower and upper cases on your database tables. Read the documentation, install the add-on and you will be home and hosed in no time!
Hello,
Just say thanks to you all. I've followed your instruction by installing the db_case_sensitivity add-ons, run the migration, downloaded migration backup to the host and everything is properly working.
Thanks
Ziri
Just say thanks to you all. I've followed your instruction by installing the db_case_sensitivity add-ons, run the migration, downloaded migration backup to the host and everything is properly working.
Thanks
Ziri
There are several forum threads on database case sensitivity, some howtos, and addons that can correct the table names when you upload and import the database backup from your windows development to the linux server.
http://www.concrete5.org/documentation/how-tos/developers/mysql-dat...
http://www.concrete5.org/marketplace/addons/database-case-sensitivi...