I had to update MySQL 5.5 to 5.6. Prior to the update I could add components to a webform. After the update I can create the webform but can't add any components. When I press Add button the screen goes blank. I was having this problem previously in MySQL 5.5 but when I refreshed the screen the component configuration screen would allow me to set up the component and I could create the webform.

But now, a refresh doesn't fix it and I have no errors in my error log or in dblog. I am using the latest/current drupal 7x install.

Comments

lias’s picture

lias commented

Got a HTTP 500 server error using IE 8 and looking into PHP error log found the following error after trying to add a component:

PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' in C:\Inetpub\wwwroot\myz\includes\database\database.inc:2168
Stack trace:
#0 C:\Inetpub\wwwroot\myz\includes\database\database.inc(2168): PDOStatement->execute(Array)
#1 C:\Inetpub\wwwroot\myz\includes\database\database.inc(680): DatabaseStatementBase->execute(Array, Array)
#2 C:\Inetpub\wwwroot\myz\includes\database\database.inc(2347): DatabaseConnection->query('SELECT expire, ...', Array, Array)
#3 C:\Inetpub\wwwroot\myz\includes\lock.inc(167): db_query('SELECT expire, ...', Array)
#4 C:\Inetpub\wwwroot\myz\includes\lock.inc(146): lock_may_be_available('theme_registry:...')
#5 C:\Inetpub\wwwroot\myz\includes\theme.inc(449): lock_acquire('theme_registry:...')
#6 C:\Inetpub\wwwroot\myz\includes\bootstrap.inc(442): ThemeRegistry->set(Array)
#7 [internal function]: DrupalCacheArray->__destruct()
#8 {main} thrown in C:\Inetpub\wwwroot\myz\includes\database\database.inc on line 2168
lias’s picture

lias commented
Status: Active » Closed (fixed)

The solution to this was increasing the max_allowed_packet in MySQL 5.6 my.ini file.

The default is set to 4M and I increased to 128M (some recommended 256M).