So I've had the error and looked around google and here and no luck yet on getting this resolved. However, what I don't understand is that I opened the database in myPhpAdmin and emptied all the cache_xx tables including the cache table but am getting this at my drupal site:
user warning: MySQL server has gone away query: UPDATE cache_content SET data = 'a:4:{s:11:\"field types\";a:11:{s:13:\"nodereference\";a:4:{s:5:\"label\";s:14:\"Node reference\";......and about 500 more lines...
So, if it's solely some memory/packet/import issue, why wouldn't it be somewhere else other than when trying to UPDATE cache_xx? All of those tables are empty. I've doubled checked my settings.php to make sure I'm editing the correct database. I have my browser disabled.
Is there some other aspect or table within the standard drupal database that pulls other content to start updating those tables?
Comments
Increase MySQL "max_allowed_packet"
The problem is related by MySQL, and you probably need to increase the MySQL "max_allowed_packet" setting to resolve the issue.
Here is a link to the MySQL :: MySQL 5.0 Reference Manual :: C.5.2.9 MySQL server has gone away
yes, I've changed all of
UPDATE: I just found this in phpMyAdmin:
Domain access failed to load during phase: bootstrap include. Please check your settings.php file and site configuration.
So, before glancing the tome below, does anybody know when running a site locally that includes access to other domains via the Domain Access module, the settings to use for a local install?
yes, I've changed all of those:
upload_max_filesize = 512M
post_max_size = 1G (has to be more than upload_max)
memory_limit = -1 (no limit) this has to be more than both
but the main thing is that those tables are empty. No data. So somehow after the Drupal install, after the initial creation of the database, Drupal is trying to insert something at runtime....or at least that is what it seems like.
I am now getting around 100 errors on the Watchdog table like:
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:2973044:\"MySQL server has gone away\nquery: UPDATE cache_content SET data = 'a:4:{s:11:\\"field types\\";a:13:{s:13:\\"nodereference\\";a:4:{s:5:\\"label\\";s:14:\\"Node reference\\";s:11:\\"description\\";s:51:\\"Store the ID of a related node as an integer value.\\";s:6:\\"module\\";s:13:\\"nodereference\\";s:10:\\"formatters\\";a:4:{s:7:\\"default\\";a:4:{s:5:\\"label\\";s:12:\\"Title (link)\\";s:11:\\"field types\\";a:1:{i:0;s:13:\\" in /Applications/MAMP/htdocs/drupal/includes/database.mysql.inc on line 135
Looking at database.mysql.inc and line 135, it just says to show an error if something is wrong with the database but I ran the standard repair/optimize after import though all imported fine.
After emptying the Watchdog table I still get this. There were tables with actual data much larger that imported fine since all the tables import alphabetically. What else could be wrong?
Is there some file in the drupal install that I can experiment with that just won't even use the Watchdog table so I can start tracking what's going on?
It's an empty table