Error Messages [#1542432]

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 313 of C:\wamp\www\modules\comment\comment.module).
Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT ff.* FROM {filter_format} ff WHERE (status = :db_condition_placeholder_0) ORDER BY weight ASC; Array ( [:db_condition_placeholder_0] => 1 ) in filter_formats() (line 407 of C:\wamp\www\modules\filter\filter.module).
Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 206 of C:\wamp\www\includes\session.inc).

The above error messages appear after installing Hierarchical Select 7.x-3.0-alpha5 and Hierarchical Select - Taxonomy when one clicks on the "EDIT" tab of all Content Types.

The error does not appear if the database is restored to a state immediately preceding the installation of the module.

Any idea what may cause this and how to fix it? Thanks. :)

Comments

Comment #1

wim leers

Ghent 🇧🇪🇪🇺

commented 23 April 2012 at 09:13

Component:	Code - Content Taxonomy	» Code - Taxonomy
Assigned:	Unassigned	» wim leers
Status:	Active	» Postponed (maintainer needs more info)

On which particular page (post the Drupal path) are you clicking on the "edit" tab?

Comment #2

Triumphent commented 28 April 2012 at 12:52

@Wim Leers
When I am on the Content Type page. It happens when I click on any content type's Edit link or, if I am editing a field or field display, when I click on the Edit tab at the top of the page.
Having said that, it appears it is a problem related to Winamp. The research I have made indicates this can be solved by adding the following statement: max_allowed_packet = 100M to the [mysqld] section of the my.ini file. Services then need to be stopped and restarted.
So far, this fix is working for me.
Thanks for your prompt response.
Cheers.

Comment #3

sprite commented 13 May 2012 at 10:06

This problem may be more generalized than just this module.

This may be a general Drupal bug that is related somehow to MySql version compatibility.

As of today, my local Drupal installation is down because of this same problem.

Nothing I have done has fixed the problem. I have even encountered the problem right after creating a brand new Drupal installation, something I did to diagnose the problem.

Also, I do not have this module installed.

Given the potential commonalities involved, this bug may be related to a version compatibility problem in XAMPP with the version of mysql, apache, and drupal.

I experienced this problem after installing a new theme/template to try out on my local machine test Drupal installation. I can no longer run any Drupal installations locally. After encountering this bug I even tried to create some fresh installations with new Mysql databases. All this installations now experience this severe total failure.

Nothing I have tried has fixed the problem.

(spent a few hours diagnosing this problem)

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

---

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 209 of C:\__sites\mysite\includes\session.inc).
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] => 4420179764faf6fdf34fb48.88262114 ) in lock_release_all() (line 269 of C:\__sites\mysite\includes\lock.inc).

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' in C:\__sites\mysite\includes\database\database.inc:2136 Stack trace: #0 C:\__sites\mysite\includes\database\database.inc(2136): PDOStatement->execute(Array) #1 C:\__sites\mysite\includes\database\database.inc(664): DatabaseStatementBase->execute(Array, Array) #2 C:\__sites\mysite\includes\database\database.inc(2315): DatabaseConnection->query('SELECT expire, ...', Array, Array) #3 C:\__sites\mysite\includes\lock.inc(167): db_query('SELECT expire, ...', Array) #4 C:\__sites\mysite\includes\lock.inc(146): lock_may_be_available('schema:runtime:...') #5 C:\__sites\mysite\includes\bootstrap.inc(405): lock_acquire('schema:runtime:...') #6 C:\__sites\mysite\includes\bootstrap.inc(427): DrupalCacheArray->set(Array) #7 [internal function]: DrupalCacheArray->__destruct() #8 {main} thrown in C:\__sites\mysite\includes\database\database.inc on line 2136