Installed commerce_node_checkout on my site with unexpected effects. Now I cant access, create or edit contet types. I get the following error that points to the comments module
Additional uncaught exception thrown while handling exception.
With this as the original description
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT COUNT(cid) FROM {comment} WHERE status = :status; Array ( [:status] => 0 ) in comment_count_unpublished() (line 314 of /var/www/vhosts/mysite.com/drupal/modules/comment/comment.module).
This has something to do with unpublished comments or ...
308 /**
309 * Returns a menu title which includes the number of unapproved comments.
310 */
311 function comment_count_unpublished() {
312 $count = db_query('SELECT COUNT(cid) FROM {comment} WHERE status = :status', array(
313 ':status' => COMMENT_NOT_PUBLISHED,
314 ))->fetchField();
315 return t('Unapproved comments (@count)', array('@count' => $count));
316 }
I'm compleatly lost in all this, as it seems nobody has encountered this type of error. The error stays, even after I disable the module.
Would really appreciate answers to this, as the site really needs the possibility to sell the publishing of individual nodes
In addition these come up as additional error messages
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => php [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:154:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT COUNT(cid) FROM {comment} WHERE status = :status; Array ( [:status] => 0 ) ";s:9:"%function";s:27:"comment_count_unpublished()";s:5:"%file";s:77:"/var/www/vhosts/mysite.com/drupal/modules/comment/comment.module";s:5:"%line";i:314;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://mysite.com/admin/structure/types/manage/node-type [:db_insert_placeholder_7] => http://mysite.com/ [:db_insert_placeholder_8] => 78.40.254.55 [:db_insert_placeholder_9] => 1363458917 ) in dblog_watchdog() (line 154 of /var/www/vhosts/mysite.com/drupal/modules/dblog/dblog.module).
regards
Jon
Comments
Update max_allowed_packet
Not sure if this will apply to your system, but I received a similar error in MAMP. I was able to fix it by following the suggestion in http://drupal.org/node/984112 and updating the max_allowed_packet to 32M in my.cnf.
not a drupal error
When I stoped considering this a Drupal error, I began to see this mentioned in various places. This has to do with the hosting and configiration limits. johnbburg is mentioning the soloution that I believe to be the most likely one. My solution was to change hosting ;) as this something my previous host had a difficulty in solving.