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

Permalink May 15, 2013 at 5:24 AM

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 May 15, 2013 at 5:52 am Permalink Reply

check your site.php and confirm you are using the correct db settings for your new host.

wassem replied on May 15, 2013 at 6:45 am 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 May 15, 2013 at 8:07 am Permalink Reply

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)

Post Reply

Delete Post

You are allowed to delete your post for 5 minutes after it's posted.

Delete

Mark Post as Spam

Are you sure you would like to mark this post as spam?

Mark as Spam

Destroy Spammer

This script will report this post as spam and add a permanent IP ban for this user, type "DESTROY" below to continue.

DESTROY SPAMMER

Sign In?

You must have a user account and be signed to perform this action.

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.

Forums

Installation Help