I've got 'Webform 7.x.3.20" installed on my Drupal 7 and it works perfectly, apart from it seems to have 'broken' the MySQL database. I first noticed this when I tried to use the 'Backup and Migrate' module - I got the following error: Additional uncaught exception thrown while handling exception.
Additional uncaught exception thrown while handling exception.
Original
PDOException: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query: show table status; Array ( ) in backup_migrate_source_db_mysql->query() (line 435 of /home/example.com/public_html/sites/all/modules/backup_migrate/includes/sources.db.mysql.inc).
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:112:"SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query: show table status; Array ( ) ";s:9:"%function";s:39:"backup_migrate_source_db_mysql->query()";s:5:"%file";s:96:"/home/example.com/public_html/sites/all/modules/backup_migrate/includes/sources.db.mysql.inc";s:5:"%line";i:435;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://example.com/admin/config/system/backup_migrate [:db_insert_placeholder_7] => http://example.com/admin/config/system/backup_migrate [:db_insert_placeholder_8] => 82.29.92.127 [:db_insert_placeholder_9] => 1409596675 ) in dblog_watchdog() (line 160 of /home/example.com/public_html/modules/dblog/dblog.module).
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] => Zy8B5O3kHHKb5uIZnFFODRyXl9C_a82Ek-o9why5wNU [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of /home/example.com/public_html/includes/session.inc).
I then went to look on phpMyAdmin to find that if I clicked on the database itself, it showed that there were no tables and has started logging me out of phpMyAdmin almost immediately. However, if I click on the '+' to the left of database name on the left hand side, I can view all of the tables in the database and even browse them individually.
Finally, I have used mysqlcheck
over SSH and found that all the tables are OK until it reaches any belonging to webforms, and then I get "Got error: 2013..." again. I know for definite it is the module because I tried removing the tables for the database, and everything goes back to normal.
Any ideas why this is happening and how this can be fixed? The webform module is excelllent and I do make good usage of it, however I'm going to have to find an alternative if this continues as I can't even update Drupal core or backup the database at the minute!