I am trying to install Open Outreach on my local MAMP setup.

It seemed to install fine and I went through all the set up pages, but when I went to visit the site I got a page full of errors.

I can see that the Original exception is for an SQL error, so perhaps it is my MAMP setup, but wouldn't the installation have failed if there were serious SQL issues.

I'm looking for help from anyone who knows Open Outreach and can can tell me if there is anything in here that looks familiar or can better parse the errors.

It seems that all the errors start with "General error: 2006 MySQL server has gone away:..." Does this mean I'm having an issue with the MySQL server rather than with OpenOutreach?

Thank you!

The Error page looks like this:

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] => 0 ) in comment_count_unpublished() (line 314 of /Users/cdd/webdev/localdev.repa-nh-oo.org/modules/comment/comment.module).

Additional

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:72:"/Users/cdd/webdev/localdev.repa-nh-oo.org/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://localhost/localdev.repa-nh-oo.org/ [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => ::1 [:db_insert_placeholder_9] => 1411662690 ) in dblog_watchdog() (line 160 of /Users/cdd/webdev/localdev.repa-nh-oo.org/modules/dblog/dblog.module).

Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 2105447106542443610a5153.54704879 ) in lock_release_all() (line 269 of /Users/cdd/webdev/localdev.repa-nh-oo.org/includes/lock.inc).

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] => iQaZUV8eStPg9ZyGzWXa_coWMsue2vPcLnCGGGSY6PU [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of /Users/cdd/webdev/localdev.repa-nh-oo.org/includes/session.inc).

Comments

nedjo’s picture

Status: Active » Fixed

When this sort of error occurs, try a web search for the error message, in this case "General error: 2006 MySQL server has gone away", in combination with "Drupal". In this case you'll find lots of hits, amounting to: you have a MySQL connection issue, likely due to low resource limits in your MySQL configuration.

cdd23’s picture

Issue summary: View changes
cdd23’s picture

Hi nedjo, I was just updating my question to note that the MySQL error was peppered throughout, so I missed your comment.

I will try to track down the issue.

Thank you for the quick response!

EDIT: I found this page helpful, in case others come here with the same problem:

https://www.drupal.org/node/1787038

especially:

https://www.drupal.org/node/1787038#comment-7941977

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.