Receive error: Table 'mysite_site.Config' doesn't exist after migration
I recently migrated my local environment (which is OS X Mountain Lion) to my remote environment (Linux). However after I uploaded all files and database as is I receive the following message:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1146: Table 'mysite_site.Config' doesn't exist] in EXECUTE("select * from Config where uID = 0 order by cfKey asc") ' in /home/mysite/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/mysite/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw('mysqlt', 'EXECUTE', 1146, 'Table 'mysite...', 'select * from C...', false, Object(ADODB_mysqlt)) #1 /home/mysite/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1049): ADOConnection->_Execute('select * from C...', false) #2 /home/mysite/public_html/concrete/core/models/config.php(182): ADOConnection->Execute('select * from C...') #3 /home/mysite/public_html/concrete/core/models/config.php(173): Concrete5_Model_ConfigStore->load() #4 /home/mysite/public_html/concrete/core/models/config.php(48): Concrete5_Model_ConfigStore->__construct() #5 /home/mysite/public_html/concrete/core/models/config.php(68): Conc in /home/mysite/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Now I read that this could raise if migrating from Windows to a Unix environment since the database names are case-sensitive and therefore all table names need to be lowercased but I'm using a Mac. I checked all my table names and everything is lowercased, both in the local and remote environment.