Can't Move Site

Permalink October 23, 2012 at 6:13 PM

I developed this site locally and now I am trying to move to a live server and I get this error: Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'hooligan_6110.Config' doesn't exist] in EXECUTE("select * from Config where uID = 0 order by cfKey asc") ' in /home/hooligan/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/hooligan/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'hooligan...', 'select * from C...', false, Object(ADODB_mysql)) #1 /home/hooligan/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('select * from C...', false) #2 /home/hooligan/public_html/concrete/core/models/config.php(190): ADOConnection->Execute('select * from C...') #3 /home/hooligan/public_html/concrete/core/models/config.php(173): Concrete5_Model_ConfigStore->load() #4 /home/hooligan/public_html/concrete/core/models/config.php(48): Concrete5_Model_ConfigStore->__construct() #5 /home/hooligan/public_html/concrete/core/models/config.php(68): Concret in /home/hooligan/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

Anyone have any ideas? I followed all instructions. Could the problem be that I am going to public_html from xampp. The files on the live server are in the root and locally they are in xampp/htdocs/hooligans/concrete.

jasteele12 replied on Oct 23, 2012 at 7:27 pm Permalink Reply

Search for moving concrete5 from Windows to unix.

Windows is not case sensitive, so most likely your table is called CONFIG and not Config

You are probably better off starting over again on the unix server and just adding your content again (unless it is quite large).

John

sully210 replied on Oct 23, 2012 at 7:36 pm Permalink Reply

Thanks man. I will start from scratch....Ugh! Ignore my other post and thanks for your help.

sully210 replied on Oct 23, 2012 at 7:38 pm Permalink Reply

By the way, my server is a linux server (centos). Does that matter. I am a real novice, sorry.

Mainio replied on Oct 24, 2012 at 8:39 am Permalink Best Answer Reply

Your local development environment was probably Windows.

Here's how to fix that:
http://www.concrete5.org/documentation/how-tos/developers/mysql-dat...

sully210 replied on Oct 24, 2012 at 8:49 am Permalink Reply

Thank you so much Mainio. I literally just finished rebuilding the entire site with a fresh install. I have moved sites before and never had this problem. I will keep this link for future reference, and once again, thank you:-) Have a great day!