Error Only When Administrator Logs In.

Posted by nxtguy on November 4, 2012 at 8:29pm

Hello,

I'm having a problem when only I (the SuperUser/Administator) log in to my drupal website.

Additional uncaught exception thrown while handling exception.

Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT COUNT(cid) FROM {comment} WHERE status = :status; Array ( [:status] =&gt; 0 ) in comment_count_unpublished() (line 313 of /home/**USER**/public_html/modules/comment/comment.module).

It's fine when other users log in, but I only get this error when I log in.

Does anyone know a way I can fix this?

Thanks,
NXTGUY

Comments

=-=

Posted by VM on November 4, 2012 at 8:36pm

how many unpublished comments are there on the site?

What do you mean by

Posted by nxtguy on November 4, 2012 at 8:37pm

What do you mean by unpublished?

=-=

Posted by VM on November 4, 2012 at 9:44pm

unpublished = comments that were submitted to the site but aren't published. try admin/content/comment/approval

the db server is timing out durin comment_count_unpublished() which is the function that counts unpublished comments.

I can't access the front end

Posted by nxtguy on November 4, 2012 at 9:51pm

I can't access the front end because I can't access my account. Is there something I can edit right on the database using phpMyAdmin?

=-=

Posted by VM on November 4, 2012 at 10:01pm

you can try emptying all cache tables.

run a query on the comment table for rows with a status of 0

I emptied all the cache

Posted by nxtguy on November 4, 2012 at 10:17pm

I emptied all the cache tables, but there were no comments with the status of 0. They were all 1. When I tried logging in again I still got the same error. But I noticed the first time I see the error page I get this message:
http://pastebin.com/24jQ8VYc

But then when I refresh the page, I get this message:
http://pastebin.com/xErQ5hD1

=-=

Posted by VM on November 4, 2012 at 10:28pm

any other sites on the account having issues with the db server?

exactly what version of Drupal 7 is in use?

how large is the watchdog table?
you can empty it and test (back it up if you want the errors that have been logged)

I've submitted a ticket

Posted by nxtguy on November 4, 2012 at 10:54pm

I've submitted a ticket asking if any other clients are having this problem.

I'm using Drupal Version 7.12.

I copied and removed my existing watchdog table to watchdog_old then I tried and log in as a Administrator and I'm just getting some favicon.ico errors and "Session opened for %name."

(Thanks for you help so far. )

=-=

Posted by VM on November 4, 2012 at 11:03pm

you didn't want to remove the watchdog table. you wanted to empty it.

7.12 is 4 security and bug fix releases behind the current stable release. I'd research release notes on the 4 versions you've not updated to to see what's been fixed and if those fixes may be related.

I meant emptied. Okay, I'll

Posted by nxtguy on November 4, 2012 at 11:08pm

I meant emptied.

Okay, I'll do that. Thanks for all your help VM!

I got this error after I

Posted by nxtguy on November 6, 2012 at 2:00am

I got this error after I installed drupal commerce and address field.

How can I un-install the modules I've installed?

=-=

Posted by VM on November 6, 2012 at 2:37am

you can disable them by setting their status to 0 in the system table.
after the are disabled see if you get access to the site
if you do gain access then you can run the uninstall routine using the uninstall tab

else, utilize the backup of the database you would have taken before installing the modules if you followed best practices.