Forums

upload site from local to live get Fatal error: Uncaught exception 'ADODB_Exception'

Permalink
hi
after upload site from local to live site i get this error
i am using last version of concrete5 5.6.1.2

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'sanapix3_ws.Config' doesn't exist] in EXECUTE("select * from Config where uID = 0 order by cfKey asc") ' in /home/sanapix3/public_html/ws/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/sanapix3/public_html/ws/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'sanapix3...', 'select * from C...', false, Object(ADODB_mysql)) #1 /home/sanapix3/public_html/ws/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('select * from C...', false) #2 /home/sanapix3/public_html/ws/concrete/core/models/config.php(182): ADOConnection->Execute('select * from C...') #3 /home/sanapix3/public_html/ws/concrete/core/models/config.php(173): Concrete5_Model_ConfigStore->load() #4 /home/sanapix3/public_html/ws/concrete/core/models/config.php(48): Concrete5_Model_ConfigStore->__construct() #5 /home/sanapix3/public_html/ws/concrete/core/models/conf in /home/sanapix3/public_html/ws/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
 
adajad replied on at Permalink Reply
adajad
check your site.php and confirm you are using the correct db settings for your new host.
wassem replied on at Permalink Reply
yes i checked
here is the code
<?php 
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'demo_demo');
define('DB_PASSWORD', 'demo2013');
define('DB_DATABASE', 'demo_ws');
define('PASSWORD_SALT', 'cqocrxV4zlSKvMcbxovKt1OtkY0NnUDbjRNselXcbHPBa9q4tLQXZ5BwMBCaQxtA');
define ('LOCAL', 'he_IL');


i tried new clean site online and it is working fine
the problem is with the one i upload from localhost using xammp
JohntheFish replied on at Permalink Reply
JohntheFish
You may have uploaded from a windows system that mangles the table names to lower case (and windows doesn't care by default), to a linux system that does care and expects c5 tables to be in CamelCase.

Have a look in the marketplace at the free case sensitivity migration addon.

http://www.concrete5.org/marketplace/addons/database-case-sensitivi...

(or have a look at my Backup Voodoo that integrates with that and a lot more)