troblem moving from local host
Permalink
I have read through all the post relating to moving from local to live server (I think). and I'm not sure what I'm doing wrong. I think it might be that I'm not export/ importing my database correctly.
Any help appricated.
The error I recieve:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'thelunch_lunch.Config' doesn't exist] in EXECUTE("select cfValue from Config where cfKey = 'PERMISSIONS_MODEL'") ' in /home/thelunch/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/thelunch/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'thelunch...', 'select cfValue ...', false, Object(ADODB_mysql)) #1 /home/thelunch/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(998): ADOConnection->_Execute('select cfValue ...') #2 /home/thelunch/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1610): ADOConnection->Execute('select cfValue ...', Array) #3 /home/thelunch/public_html/concrete/libraries/database.php(73): ADOConnection->GetRow('select cfValue ...', Array) #4 [internal function]: Database->__call(Array, Array) #5 /home/thelunch/public_html/concrete/models/config.php(52): Database->GetRow('GetRow', Ar in /home/thelunch/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Any help appricated.
The error I recieve:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'thelunch_lunch.Config' doesn't exist] in EXECUTE("select cfValue from Config where cfKey = 'PERMISSIONS_MODEL'") ' in /home/thelunch/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/thelunch/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'thelunch...', 'select cfValue ...', false, Object(ADODB_mysql)) #1 /home/thelunch/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(998): ADOConnection->_Execute('select cfValue ...') #2 /home/thelunch/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1610): ADOConnection->Execute('select cfValue ...', Array) #3 /home/thelunch/public_html/concrete/libraries/database.php(73): ADOConnection->GetRow('select cfValue ...', Array) #4 [internal function]: Database->__call(Array, Array) #5 /home/thelunch/public_html/concrete/models/config.php(52): Database->GetRow('GetRow', Ar in /home/thelunch/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
very handy tip, thanks!
The problem you encountered has something to do with Windows and Filesystem case-sensitivity, which is not given on the windows platform but in linux/unix.
Developing on Windows then Exporting to Linux/Unix is not really recommended, due to issues like that.
You can read more about MySQL case-sensitivity here:http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity....
Developing on Windows then Exporting to Linux/Unix is not really recommended, due to issues like that.
You can read more about MySQL case-sensitivity here:http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity....
If you have installed onto your local dev sever using Wamp, then try the following. It corrects the naming of the tables in the database.
Left-click the wamp gauge, then select Apache → Apache Modules → Rewrite Module. The gauge will flick to yellow, and then return to white.
Left-click the gauge, then select MySQL → my.ini. At the very bottom of the file, and add the following to a new line (without the quotes): “lower_case_table_names = 2”. Save the file, close Notepad and left-click the gauge, and selected ‘Restart all services’