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?? :(
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?? :(
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?
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?
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/...
Ask them to confirm that you have write permissions to /files and /config, as perhttp://www.concrete5.org/help/building_with_concrete5/installation/...
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."
-------------------
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."
Ok well at least it is up and working!
Have you cleared out your browser cache in Firefox?
Have you cleared out your browser cache in Firefox?
Yes I just did this, I'm still getting the fatal error in FF =/
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!
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!
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!
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!
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.
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...
Is it something my host has to support, or is it something that I can download and install on my account?
Thanks...
I had this error yesterday. Deleting files/cache solved this issue for me.
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
please refer to my sire below.. your comments arealways helpfuul
http://www.projecterior.com/
www.www.projecterior.com/index.php/login...
Thanks
If i delete the files from Files/Cache i have to do the same thing every morning. Can somebody find a solution to this ?
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
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
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...
Take a look here>http://www.concrete5.org/index.php?cID=15080...
I just disabled DB cache and that's fine !!!
Thanks a lot
Thanks a lot
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?