can't connect the ADODB on hostpapa with phpmyadmin
Permalink
I publish my web by FTP on hostpapa, and the database is not coming with my php's, so I convert the folder of my mysql database by mysqldump to .sql file and uploaded by phpMyadmin on the cPanel;
That response of the home page is like this:
which I changed my database name to drmic719_7, and is not working.
Is this the problem with the third party database ADODB?
I am using webmatrix, the other database could upload normally.
Thanks!
That response of the home page is like this:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'drmic719_7.Config' doesn't exist] in EXECUTE("select cfValue from Config where cfKey = 'ENABLE_CACHE'") ' in/home/drmic719/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/drmic719/public_html/concrete/libraries/3rdparty/adodb/adodb.i nc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'drmic719...', 'select cfValue ...', false, Object(ADODB_mysql)) #1 /home/drmic719/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('select cfValue ...') #2 /home/drmic719/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1605): ADOConnection->Execute('select cfValue ...', Array) #3 [internal function]: ADOConnection->GetRow('select cfValue ...', Array) #4 /home/drmic719/public_html/concrete/libraries/database.php(73): call_user_func_array(Array, Array) #5 /home/drmic719/public_html/concrete/models/config.php(67): Database->__call('GetRow', Array) in /home/drmic719/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
which I changed my database name to drmic719_7, and is not working.
Is this the problem with the third party database ADODB?
I am using webmatrix, the other database could upload normally.
Thanks!
I would first check using phpmyadmin if there is a table called 'Config' in the database 'drmc719_7'. I would guess that either your mysqldump did export completely or your phpmyadmin did not import everthing. Just a guess.
I found out the answer, which each table name in the DB is capital letters sensitive.
