FATAL ERROR all of a sudden?

Permalink
Hello, I went to visit my site this evening and I receive this error message:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [-32000: Cache write error] in CacheExecute(/home/paulrit/public_html/files/cache/56/adodb_56feeb1450a9625ddd79d502e5b0919b.cache, select ctID from PageTypes) ' in /home/paulrit/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/paulrit/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1819): adodb_throw('mysql', 'CacheExecute', -32000, 'Cache write err...', '/home/paulrit/p...', 'select ctID fro...', Object(ADODB_mysql)) #1 /home/paulrit/public_html/concrete/libraries/database.php(34): ADOConnection->CacheExecute(10, 'select ctID fro...') #2 /home/paulrit/public_html/concrete/models/permissions.php(458): Database->querycache(10, 'select ctID fro...') #3 /home/paulrit/public_html/concrete/models/permissions.php(72): CollectionPermissions->CollectionPermissions(Object(Page)) #4 /home/paulrit/public_html/concrete/models/permissions.php(116): PermissionsProxy::getNewOrCached(Object(Page), 'Colle in /home/paulrit/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

I haven't changed anything to do with the site or server, and it was working perfectly fine the last time I was on it (a couple of hours ago)...and now all of a sudden its saying this.

Can anyone help me?? :(

 
chunksmurray replied on at Permalink Reply
chunksmurray
Are you able to get to your dashboard and login? Try clearing your cache and see if that makes any difference

If you don't know how, you'll find it at: Dashboard -> Sitewide Settings -> Debug

It may not be the answer but definitely worth a shot. With the 5.3 upgrade I've personally found a lot of stuff has been fixed by clearing site and browser cache.

Also you said you didn't make any changes to the server, so no permissions have changed that you of?
Iconoclast replied on at Permalink Reply
Hi, I can't access my dashboard, no, I get the same error message.

The only permissions thing that I can think of it that since I had to reinstall C5 a couple of different times, each time it wouldn't let me delete the /files directory (I get a permission denied error for whatever reason). So I sent off a support ticket to my host asking a question about why this is happening since I'm logged in a the root account user, and he said:

"Hello Paul,

I have fixed file ownership and public_html permissions related issue for your account.

It has been my pleasure to assist you today. If you have any further questions or concerns feel free to contact us again."

So obviously something got changed, and now I'm getting this error. I've already sent back a reply to the support staff explaining this error, and have requested them to revert whatever changes they made...hopefully they are able to do this. Do you think this is the cause of this error?
chunksmurray replied on at Permalink Reply
chunksmurray
Yeah I think the permissions on the Files directory are to blame. The cache is stored within this directory, so the webserver needs to be able to write to it.

Ask them to confirm that you have write permissions to /files and /config, as perhttp://www.concrete5.org/help/building_with_concrete5/installation/...
Iconoclast replied on at Permalink Reply
EDIT: Okay, this is really weird. I'm using Firefox, and that's when I'm getting that error...but if I use IE and go to my domain, it seems to be working fine...does it have something to do with me being logged in as admin, or something? Like, what would cause that?


-------------------

Yes, both of those directories are still chmoded to 777...any other ideas?


This was his response:

"Hello Paul,

Well, I see the following content on your website:

I also checked your website from multiple locations all around the world by using this tool:http://www.serviceuptime.com/quickcheck.php...

It shows that your website is accessible from United States, Italy and United Kingdom.

To test your website accessibility you may also use this tool:http://www.proxy.org

So, it seems your website works fine. But please let me know if you still getting problems, so we can investigate it further.

We look forward to being of service."
chunksmurray replied on at Permalink Reply
chunksmurray
Ok well at least it is up and working!

Have you cleared out your browser cache in Firefox?
Iconoclast replied on at Permalink Reply
Yes I just did this, I'm still getting the fatal error in FF =/
Iconoclast replied on at Permalink Reply
Okay, so I realized that the error still occurs in IE, it just doesn't occur on the home page...and also, it still lets you view the page, but contains the error wherever it's occurring.

It seems to be a write issue with the /files/cache directory...you mentioned something about trying to clear the cache if I could access my dashboard (which I can't).

What exactly does that function do? I mean, which files is it getting rid of? Because in my files/cache folder there are a bunch of subfolders with names like "17", "1c", "5f", "c9", "67", "e7", etc., as well as files that I believe have to do with the database and the blocks, since they follow the same naming convention:

adodb_mysql_active_BlockTypes.cache
adodb_mysql_active_btSearch.cache
adodb_mysql_active_btYoutube.cache
adodb_mysql_active_btSurvey.cache

etc.

Can I "manually" clear the cache by deleting all of the subfolders in this directory? The ones with names like I just listed above? Because all the errors I seem to be receiving are all pointing to .cache files located within those subfolders.

I just want to be sure that's not going to affect anything else if I do delete them or if it's a good idea at all. Please let me know...or any other ideas you might have! Thanks!
bodenski replied on at Permalink Reply
I have a website hosted by bluehost.com, and my site works with 5.2.1. However I have tried to use their automatic upgrade path (simplescripts) to get 5.3 and when I do I have the same adodb error when I try to access the home page. Luckily simplescripts gives an easy way to role-back to the last version, and the roled-back version works fine. I have two seperate installs that were installed the same way, and one was just a basic install (no custom anything). Both of them gave the adodb error with the attempted upgrade.

I was thinking it was just an error with the way simplescripts coded the update but now I'm not so sure. I have submitted the particular error message I got to them to see if they can see what's going on. Something is obviously screwy here!
ringo replied on at Permalink Reply
All the files in my cache folder were assigned to user 99. As a result the upgrade didn't happen correctly and the cache files were not accessible. I got my host to move me to a new server which runs suPHP. This solved all the problems as the scripts now run under my user.
Iconoclast replied on at Permalink Reply
suPHP, I've never really heard of it to be honest...I just did some really quick research and I'm interested to see if it'll fix my problem.

Is it something my host has to support, or is it something that I can download and install on my account?

Thanks...
beeman89045 replied on at Permalink Reply
I had this error yesterday. Deleting files/cache solved this issue for me.
jincmd replied on at Permalink Reply
jincmd
conflictions between firefox and ie, (manually deteleting contents of /files/cache got me here to begin with" now im trying to figure out how to see what users its identifying...

please refer to my sire below.. your comments arealways helpfuul

http://www.projecterior.com/
www.www.projecterior.com/index.php/login...
Thanks
lexteo replied on at Permalink Reply
If i delete the files from Files/Cache i have to do the same thing every morning. Can somebody find a solution to this ?
Pyros replied on at Permalink Reply
First connect is fine, any click or call to new page give me the cache error .

This is a fresh new install

You can check onhttp://hacout.free.fr

Got the error : mysql error: [-32000: Cache write error] in CacheExecute(/mnt/148/sdb/9/e/hacout/files/cache/adodb_55ae04ebee72c2455e172625366fd20d.cache, select ctID from PageTypes)

If i try the same query within phpmysqladmin, it's working fine...

After a refresh got this full message :
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [-32000: Cache write error] in CacheExecute(/mnt/148/sdb/9/e/hacout/files/cache/adodb_55ae04ebee72c2455e172625366fd20d.cache, select ctID from PageTypes) ' in /mnt/148/sdb/9/e/hacout/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /mnt/148/sdb/9/e/hacout/concrete/libraries/3rdparty/adodb/adodb.inc.php(1819): adodb_throw('mysql', 'CacheExecute', -32000, 'Cache write err...', '/mnt/148/sdb/9/...', 'select ctID fro...', Object(ADODB_mysql)) #1 /mnt/148/sdb/9/e/hacout/concrete/libraries/database.php(34): ADOConnection->CacheExecute(10, 'select ctID fro...') #2 /mnt/148/sdb/9/e/hacout/concrete/models/permissions.php(461): Database->querycache(10, 'select ctID fro...') #3 /mnt/148/sdb/9/e/hacout/concrete/models/permissions.php(72): CollectionPermissions->CollectionPermissions(Object(Page)) #4 /mnt/148/sdb/9/e/hacout/concrete/models/permissions.php(116): PermissionsProxy::getNewOrCached(Object(Page), 'CollectionPermi...') # in /mnt/148/sdb/9/e/hacout/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
lexteo replied on at Permalink Reply
To Solve this problem you should disable adodb cache, apparently this is a server issue. And the only sollution i found was to disable Adodb cache.
Take a look here>http://www.concrete5.org/index.php?cID=15080...
Pyros replied on at Permalink Reply
I just disabled DB cache and that's fine !!!

Thanks a lot