Forums

Concrete5 + MySQL + Unix based hosting problems?

Permalink
I have been working on a website for my friend using a WAMP stack and copied everything to the Unix based hosting and I get the following error:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'pureadve_c5.Config' doesn't exist] in EXECUTE("select * from Config where uID = 0 order by cfKey asc") ' in /home/pureadve/public_html/newwebsite/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/pureadve/public_html/newwebsite/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'pureadve...', 'select * from C...', false, Object(ADODB_mysql)) #1 /home/pureadve/public_html/newwebsite/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('select * from C...', false) #2 /home/pureadve/public_html/newwebsite/concrete/core/models/config.php(182): ADOConnection->Execute('select * from C...') #3 /home/pureadve/public_html/newwebsite/concrete/core/models/config.php(173): Concrete5_Model_ConfigStore->load() #4 /home/pureadve/public_html/newwebsite/concrete/core/models/config.php(48): Concrete5_Model_ConfigStore->__construct() #5 /home/p in /home/pureadve/public_html/newwebsite/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78


From what I have been reading, its because the database tables are all lowercase and MySQL within Unix doesn't like it?

Anyone know what the fix is?

Thanks
PC