Forums

ADODB error - How to fix this?

Permalink
Hi, i hope you have a nice day :)

I have problem with my website. I already flush the cache from cpanel, repair DB, change CHMOD, but the error still there :

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1033: Table './cushcom_hx/Config' was created with a different version of MySQL and cannot be read] in EXECUTE("select cfValue from Config where cfKey = 'ENABLE_CACHE'") ' in /home/cushcom/public_html/hexacreative/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/cushcom/public_html/hexacreative/concrete/libraries/3rdparty/adodb/adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1033, 'Table './cushco...', 'select cfValue ...', false, Object(ADODB_mysql)) #1 /home/cushcom/public_html/hexacreative/concrete/libraries/3rdparty/adodb/adodb.inc.php(998): ADOConnection->_Execute('select cfValue ...') #2 /home/cushcom/public_html/hexacreative/concrete/libraries/3rdparty/adodb/adodb.inc.php(1610): ADOConnection->Execute('select cfValue ...', Array) #3 [internal function]: ADOConnection->GetRow('select cfValue ...', Array) #4 /home/cushcom/public_html/hexacreative/concrete/libraries/database.php(73): call_user_func_arr in /home/cushcom/public_html/hexacreative/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

how to fix that? thanks :(
hexacreative
 
orisinal replied on at Permalink Reply
orisinal
Did you or your host upgrade or downgrade MySQL? Did you move your site from server to another or something? Probably the databases are not imported properly to new system. If that's the case, make a dump from old database and dump it to new system, instead of copying MySQL db files.

I think this is not really C5 problem, but this answer is just my guess :)
hexacreative replied on at Permalink Reply
hexacreative
thanks for your reply :)

i think that too.
but, how to do that? i'm very newbie for database --"

thanks :)
orisinal replied on at Permalink Reply
orisinal
So do you know what caused this error? Did you do something special and then it broke up? I'm not going into any details if this is problem of your host and their technical support, or this is just your playground site.

Do you have any backup (dump, like mydb_backup.sql) of your database?
hexacreative replied on at Permalink Reply
hexacreative
owh.
thanks for your reply..

thanks! my problem solved! :)
ltatum replied on at Permalink Reply
how did you fix it...i'm getting the same error message.

Thanks
hexacreative replied on at Permalink Reply
hexacreative
this is how i solved this problem. On this case i use the latest version of Concrete5 (v5.4.0.5 :

1. Go to your cPanel/FTP Concrete5 website
2. Go to /public_html/files/
3. Select /cache folder
4. Delete that folder (/cache)
5. Create new folder with name cache
6. Refresh your cPanel/FTP
7. Finish

This work for my website.