Fatal Error: Uncaught exception 'ADODB_Exception'
Permalink
My site has been up and working for several weeks now;
Today I came to login and got a fatal error ....I seem to a file permission problem?
I've not changed anything but via cPanel have checked that file permissions "appear" ok.
Any ideas what this means?
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [-32000: Cache write error] in CacheExecute
Today I came to login and got a fatal error ....I seem to a file permission problem?
I've not changed anything but via cPanel have checked that file permissions "appear" ok.
Any ideas what this means?
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [-32000: Cache write error] in CacheExecute
yes, the file cannot be written.. Usually a permission problem but you could also have run out of space?
you could also disable the db cache by adding this line
define("DB_USE_CACHE',false");
to your config file..
define("DB_USE_CACHE',false");
to your config file..
Remo,
does this have any other implications?
NB: I have unlimited space, so I dont think its a space problem?
does this have any other implications?
NB: I have unlimited space, so I dont think its a space problem?
no, it just disables the internal adodb cache... might slow down your site a tiny tiny little bit but you won't feel any difference.
Remo
thanks for the help - i tried creating a folder on my root - seems there is a problem with the host....and they're not responding (sigh)
I've found another host, restored backups, created a new user for the db etc, changed the config/site.php file to reflect the changes but I still get a "unable to connect to db" error....I've searched the forum for other clues but couldnt find anything. I may well be missing something obvious?
Any thoughts?
Many thanks
thanks for the help - i tried creating a folder on my root - seems there is a problem with the host....and they're not responding (sigh)
I've found another host, restored backups, created a new user for the db etc, changed the config/site.php file to reflect the changes but I still get a "unable to connect to db" error....I've searched the forum for other clues but couldnt find anything. I may well be missing something obvious?
Any thoughts?
Many thanks
Nope, I never had a problem where this error message wasn't caused by a mysql user / connection problem...
It was either that localhost wasn't accepted as the hostname or the the user, password or database name was misspelled.
Try to connect using a simple mysql_connect and check for error messages. If you get one you can be sure it's not c5, if there isn't one you might have to check the log files (php does not always print errors in the browser) but if there's nothing in the log, it's probably c5.. Altough I can't imagine what could be wrong with c5..
But you did clear the cache, didn't you?
Or remove the cache files (in the directory files)
It was either that localhost wasn't accepted as the hostname or the the user, password or database name was misspelled.
Try to connect using a simple mysql_connect and check for error messages. If you get one you can be sure it's not c5, if there isn't one you might have to check the log files (php does not always print errors in the browser) but if there's nothing in the log, it's probably c5.. Altough I can't imagine what could be wrong with c5..
But you did clear the cache, didn't you?
Or remove the cache files (in the directory files)
Remo,
yeah i wiped the cache, disabled it, disabled pretty urls, all the stuff in the forums etc.
I have checked that localhost appears in phpAdmin alongwith the correct dbname and that I have the correct db user....however, i had to create a new user but there is nowhere to change the permissions as described in the install process (e.g. amend, write etc)
I am reading Google results for this now, but its all command line driven...and I havent a clue!
Is there an easy way to do this?
Thanks (again!)
yeah i wiped the cache, disabled it, disabled pretty urls, all the stuff in the forums etc.
I have checked that localhost appears in phpAdmin alongwith the correct dbname and that I have the correct db user....however, i had to create a new user but there is nowhere to change the permissions as described in the install process (e.g. amend, write etc)
I am reading Google results for this now, but its all command line driven...and I havent a clue!
Is there an easy way to do this?
Thanks (again!)
OK great support from my new host got the permission thing sorted - user permissions - but I couldnt figure out where to do this in cPanel....hmmm
Anyway, i now have a new problem, all my content is missing....this represents weeks of work, any ideas?
Anyway, i now have a new problem, all my content is missing....this represents weeks of work, any ideas?
what do you mean by content?
Is the site structure still there? Only blocks gone? Theme still there?
Is the site structure still there? Only blocks gone? Theme still there?
Yeh,
the theme is there, just all the blocks have vanished...all the pages are there, just nothing on them :(
Save the day and tell me there is a fix for this!
the theme is there, just all the blocks have vanished...all the pages are there, just nothing on them :(
Save the day and tell me there is a fix for this!
sorry but I currently don't have an idea what could have went wrong...
I'd probably dig into the code, never had this problem and I moved lots of sites. I'm not going to ask if you checked whether you restored an up to date backup file ;-)
I'd probably dig into the code, never had this problem and I moved lots of sites. I'm not going to ask if you checked whether you restored an up to date backup file ;-)
this is merely to confirm, but have you done everything said on this page?
http://www.concrete5.org/index.php?cID=22638...
http://www.concrete5.org/index.php?cID=22638...
Yes, although i think there has been a severe problem with my host, as although their server is back up, the site is as my "copied site" (e.g. no content) which with the help of Remo (thanks again) and my new web hosts is now up.
I have restored an old (4 weeks old :( ) backup to bring 'some' content back.
Its my own stupid fault for not doing more backups...I know, duh!
In summary i think something serious happened with my hosts which seems to have screwed the MySQL db, thus losing all the content. The rest is probably down to my lack of experience.
The site transferred easily the second time, following all the instructions. Just required the creation and connection of a user for the db. Simple when you know how!
This restore has also got rid of a load of weird block problems I have been having, when adding blocks to global scrapbook and being unable to move a "split block".
Now to add all that content back......
I have restored an old (4 weeks old :( ) backup to bring 'some' content back.
Its my own stupid fault for not doing more backups...I know, duh!
In summary i think something serious happened with my hosts which seems to have screwed the MySQL db, thus losing all the content. The rest is probably down to my lack of experience.
The site transferred easily the second time, following all the instructions. Just required the creation and connection of a user for the db. Simple when you know how!
This restore has also got rid of a load of weird block problems I have been having, when adding blocks to global scrapbook and being unable to move a "split block".
Now to add all that content back......