Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.Please help! I can't seem to reclaim my site. Maybe if there is a way to manually delete an unfinished import? Any help that anyone can give me would be much appreciated.
Pre-issue History
I had completed several successful node imports into this site and content type using CSVs of a similar formatting. This time, I began the import and locked my computer for the night (don't know if that's what caused this, but I thought I'd mention the circumstances). When I returned to my computer, the import had failed, and I started experiencing the following symptoms:
Symptoms
1. Receiving the following message at the top of every page on the site.
Notice: unserialize() [function.unserialize]: Error at offset 0 of 32 bytes in /var/www/vhosts/umhb.edu/httpdocs/includes/bootstrap.inc on line 478
2. I receive the following error when view the import again to try to complete it:
You need to have Javascript enabled to see the progress of this import.
3. Then, after waiting a few minutes for the import to complete, I receive the following error, which I assume is basically just a MySQL timeout.
An error occurred. /admin/content/node_import/9/continue
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:101:\"MySQL server has gone away\nquery: DELETE FROM node_import_status WHERE taskid = 9 AND offset = 339429\";s:5:\"%file\";s:79:\"/var/www/vhosts/umhb.edu/httpdocs/sites/all/modules/node_import/node_import.inc\";s:5:\"%line\";i:809;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128Warning: MySQL server has gone away query: SELECT * FROM system WHERE type = 'theme' in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Notice: Undefined index: garland in /var/www/vhosts/umhb.edu/httpdocs/includes/theme.inc on line 59
Notice: Trying to get property of non-object in /var/www/vhosts/umhb.edu/httpdocs/includes/theme.inc on line 92
Notice: Trying to get property of non-object in /var/www/vhosts/umhb.edu/httpdocs/includes/theme.inc on line 219
Warning: MySQL server has gone away query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:' in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: SHOW TABLES LIKE 'date_format_types' in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'imagecache:presets' in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: SELECT * FROM imagecache_preset ORDER BY presetname in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: UPDATE cache SET data = 'a:0:{}', created = 1275663893, expire = 0, headers = '', serialized = 1 WHERE cid = 'imagecache:presets' in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'imagecache:presets' in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: SELECT * FROM imagecache_preset ORDER BY presetname in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: UPDATE cache SET data = 'a:0:{}', created = 1275663893, expire = 0, headers = '', serialized = 1 WHERE cid = 'imagecache:presets' in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Notice: Trying to get property of non-object in /var/www/vhosts/umhb.edu/httpdocs/includes/theme.inc on line 440
Notice: Trying to get property of non-object in /var/www/vhosts/umhb.edu/httpdocs/includes/theme.inc on line 440
Notice: Trying to get property of non-object in /var/www/vhosts/umhb.edu/httpdocs/includes/theme.inc on line 440
Warning: MySQL server has gone away query: UPDATE variable SET value = 's:20:\"theme_menu_item_link\";' WHERE name = 'oldtheme_menu_item_link' in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: DELETE FROM cache WHERE cid = 'variables' in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Notice: Trying to get property of non-object in /var/www/vhosts/umhb.edu/httpdocs/includes/theme.inc on line 235
Warning: MySQL server has gone away query: UPDATE cache SET data = 'a:365:{s:15:\"admin_menu_icon\";a:7:{s:9:\"arguments\";a:0:{}s:4:\"type\";s:6:\"module\";s:10:\"theme path\";s:25:\"modules/acquia/admin_menu\";s:8:\"function\";s:21:\"theme_admin_menu_icon\";s:13:\"include files\";a:0:{}s:11:\"theme paths\";a:1:{i:0;s:25:\"modules/acquia/admin_menu\";}s:20:\"preprocess functions\";a:1:{i:0;s:19:\"template_preprocess\";}}s:19:\"advanced_help_topic\";a:7:{s:9:\"arguments\";a:2:{s:6:\"module\";N;s:5:\"topic\";N;}s:4:\"type\";s:6:\"module\";s:10:\"theme path\";s:28:\"modules/acquia/advanced_help\";s:8:\"function\";s:25:\"theme_advanced_help_topic\";s:13:\"include files\";a:0:{}s:11:\"theme paths\";a:1:{i:0;s:28:\"modules/acquia/advanced_help\";}s:20:\"prep in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:128:\"MySQL server has gone away\nquery: INSERT INTO node_import_status (taskid, offset, errors) VALUES (9, 339429, 'a:0:{}')\";s:5:\"%file\";s:79:\"/var/www/vhosts/umhb.edu/httpdocs/sites/all/modules/node_import/node_import.inc\";s:5:\"%line\";i:810;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:117:\"MySQL server has gone away\nquery: UPDATE node_import_tasks SET offset = 594210, changed = 1275663893 WHERE taskid = 9\";s:5:\"%file\";s:79:\"/var/www/vhosts/umhb.edu/httpdocs/sites/all/modules/node_import/node_import.inc\";s:5:\"%line\";i:818;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:147:\"MySQL server has gone away\nquery: SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid ORDER BY v.weight, v.name\";s:5:\"%file\";s:66:\"/var/www/vhosts/umhb.edu/httpdocs/modules/taxonomy/taxonomy.module\";s:5:\"%line\";i:460;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:147:\"MySQL server has gone away\nquery: SELECT data, created, headers, expire, serialized FROM cache_content WHERE cid = 'content_type_info:en'\";s:5:\"%file\";s:52:\"/var/www/vhosts/umhb.edu/httpdocs/includes/cache.inc\";s:5:\"%line\";i:26;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:118:\"MySQL server has gone away\nquery: SELECT dft.type, dft.title, dft.locked FROM date_format_types dft ORDER BY dft.title\";s:5:\"%file\";s:69:\"/var/www/vhosts/umhb.edu/httpdocs/modules/acquia/date/date_api.module\";s:5:\"%line\";i:1974;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:137:\"MySQL server has gone away\nquery: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'imagecache:presets'\";s:5:\"%file\";s:52:\"/var/www/vhosts/umhb.edu/httpdocs/includes/cache.inc\";s:5:\"%line\";i:26;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:85:\"MySQL server has gone away\nquery: SELECT * FROM imagecache_preset ORDER BY presetname\";s:5:\"%file\";s:77:\"/var/www/vhosts/umhb.edu/httpdocs/modules/acquia/imagecache/imagecache.module\";s:5:\"%line\";i:909;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:193:\"MySQL server has gone away\nquery: UPDATE cache SET data = 'a:0:{}', created = 1275663893, expire = 0, headers = '', serialized = 1 WHERE cid = 'imagecache:presets'\";s:5:\"%file\";s:52:\"/var/www/vhosts/umhb.edu/httpdocs/includes/cache.inc\";s:5:\"%line\";i:109;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:137:\"MySQL server has gone away\nquery: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'imagecache:presets'\";s:5:\"%file\";s:52:\"/var/www/vhosts/umhb.edu/httpdocs/includes/cache.inc\";s:5:\"%line\";i:26;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:85:\"MySQL server has gone away\nquery: SELECT * FROM imagecache_preset ORDER BY presetname\";s:5:\"%file\";s:77:\"/var/www/vhosts/umhb.edu/httpdocs/modules/acquia/imagecache/imagecache.module\";s:5:\"%line\";i:909;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:193:\"MySQL server has gone away\nquery: UPDATE cache SET data = 'a:0:{}', created = 1275663893, expire = 0, headers = '', serialized = 1 WHERE cid = 'imagecache:presets'\";s:5:\"%file\";s:52:\"/var/www/vhosts/umhb.edu/httpdocs/includes/cache.inc\";s:5:\"%line\";i:109;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:93:\"MySQL server has gone away\nquery: SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC\";s:5:\"%file\";s:58:\"/var/www/vhosts/umhb.edu/httpdocs/modules/node/node.module\";s:5:\"%line\";i:558;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:28805:\"MySQL server has gone away\nquery: UPDATE cache_content SET data = 'a:4:{s:11:\\"field types\\";a:10:{s:4:\\"date\\";a:4:{s:5:\\"label\\";s:4:\\"Date\\";s:11:\\"description\\";s:89:\\"Store a date in the database as an ISO date, recommended for historical or partial dates.\\";s:6:\\"module\\";s:4:\\"date\\";s:10:\\"formatters\\";a:5:{s:7:\\"default\\";a:4:{s:5:\\"label\\";s:7:\\"Default\\";s:11:\\"field types\\";a:3:{i:0;s:4:\\"d in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:172:\"MySQL server has gone away\nquery: SELECT v.* FROM vocabulary v INNER JOIN vocabulary_node_types n ON v.vid = n.vid WHERE n.type = 'news' ORDER BY v.weight, v.name\";s:5:\"%file\";s:86:\"/var/www/vhosts/umhb.edu/httpdocs/sites/all/modules/node_import/supported/taxonomy.inc\";s:5:\"%line\";i:320;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:148:\"MySQL server has gone away\nquery: SELECT uid FROM users WHERE uid = -1 OR LOWER(name) = 'admin' OR LOWER(mail) = 'admin' LIMIT 1\";s:5:\"%file\";s:79:\"/var/www/vhosts/umhb.edu/httpdocs/sites/all/modules/node_import/node_import.inc\";s:5:\"%line\";i:1209;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:177:\"call_user_func_array() [<a href=\'function.call-user-func-array\'>function.call-user-func-array</a>]: First argument is expected to be a valid callback, \'news_node_form\' was given\";s:5:\"%file\";s:51:\"/var/www/vhosts/umhb.edu/httpdocs/includes/form.inc\";s:5:\"%line\";i:372;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:7053:\"MySQL server has gone away\nquery: UPDATE node_import_status SET status = 1, errors = 'a:6:{s:13:\\"node_import-0\\";s:2039:\\"Input error: <em>2008 &lt;br /&gt;Cost: $75 per camper &lt;br /&gt;Group discounts for 10 or more &lt;/p&gt;&lt;p&gt;Contact: UMHB Conservatory of Music &lt;br /&gt;254-295-4686&lt;/p&gt;&lt;p&gt;Summer Musical Camp &lt;br /&gt;July 14 - 19 &lt;br /&gt;Ages: 10 -18 &lt;br /&gt;&lt;br /&gt;Performances for Fiddler on the Roof:&a in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:105:\"MySQL server has gone away\nquery: UPDATE node_import_tasks SET row_error = row_error + 1 WHERE taskid = 9\";s:5:\"%file\";s:79:\"/var/www/vhosts/umhb.edu/httpdocs/sites/all/modules/node_import/node_import.inc\";s:5:\"%line\";i:825;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:96:\"MySQL server has gone away\nquery: DELETE FROM variable WHERE name = 'node_import:lock'\";s:5:\"%file\";s:79:\"/var/www/vhosts/umhb.edu/httpdocs/sites/all/modules/node_import/node_import.inc\";s:5:\"%line\";i:1984;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:144:\"Cannot modify header information - headers already sent by (output started at /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc:128)\";s:5:\"%file\";s:53:\"/var/www/vhosts/umhb.edu/httpdocs/includes/common.inc\";s:5:\"%line\";i:148;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
{ "status": 1, "message": "72 rows imported\x3cbr /\x3e1 row with errors", "percentage": 20 }
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:323:\"MySQL server has gone away\nquery: UPDATE sessions SET uid = 1, cache = 0, hostname = '67.79.54.130', session = 'node_overview_filter|a:1:{i:0;a:2:{i:0;s:4:\\"type\\";i:1;s:4:\\"news\\";}}updates_remaining|a:0:{}', timestamp = 1275663893 WHERE sid = '8nlr0jj00lormk8povc0foqfm4'\";s:5:\"%file\";s:54:\"/var/www/vhosts/umhb.edu/httpdocs/includes/session.inc\";s:5:\"%line\";i:70;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:84:\"MySQL server has gone away\nquery: UPDATE users SET access = 1275663893 WHERE uid = 1\";s:5:\"%file\";s:54:\"/var/www/vhosts/umhb.edu/httpdocs/includes/session.inc\";s:5:\"%line\";i:75;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:96:\"MySQL server has gone away\nquery: DELETE FROM variable WHERE name = 'node_import:lock'\";s:5:\"%file\";s:79:\"/var/www/vhosts/umhb.edu/httpdocs/sites/all/modules/node_import/node_import.inc\";s:5:\"%line\";i:1984;}', 3, '', 'http://news.umhb.edu/admin/content/node_import/9/continue', 'http://news.umhb.edu/admin/content/node_import/9', '67.79.54.130', 1275663893) in /var/www/vhosts/umhb.edu/httpdocs/includes/database.mysql.inc on line 128
Additional Info
I have tried to track down the source of this issue, and got as far as using the technique mentioned here: http://groups.drupal.org/node/26554#comment-103260. This is the result of adding that line of code after line 478 of bootstrap.inc :
Parsed: theme_default
Parsed: filter_html_1
Parsed: node_options_forum
Parsed: drupal_private_key
Parsed: menu_masks
Parsed: install_task
Parsed: menu_expanded
Parsed: file_directory_temp
Parsed: site_name
Parsed: site_mail
Parsed: date_default_timezone
Parsed: user_email_verification
Parsed: clean_url
Parsed: install_time
Parsed: upload_test
Parsed: node_options_page
Parsed: comment_page
Parsed: theme_settings
Parsed: acquia_welcome
Parsed: theme_garland_settings
Parsed: web_test_case_profile
Parsed: update_last_check
Parsed: css_js_query_string
Parsed: install_profile
Parsed: views_block_hashes
Parsed: content_schema_version
Parsed: fieldgroup_schema_version
Parsed: site_404
Parsed: pathauto_modulelist
Parsed: pathauto_taxonomy_supportsfeeds
Parsed: pathauto_taxonomy_pattern
Parsed: pathauto_taxonomy_bulkupdate
Parsed: pathauto_taxonomy_applytofeeds
Parsed: pathauto_taxonomy_2_pattern
Parsed: pathauto_taxonomy_1_pattern
Parsed: pathauto_ignore_words
Parsed: pathauto_indexaliases
Parsed: pathauto_indexaliases_bulkupdate
Parsed: pathauto_max_component_length
Parsed: pathauto_max_length
Parsed: pathauto_node_bulkupdate
Parsed: pathauto_node_forum_pattern
Parsed: pathauto_node_image_pattern
Parsed: pathauto_node_page_pattern
Parsed: pathauto_node_pattern
Parsed: pathauto_node_story_pattern
Parsed: pathauto_punctuation_quotes
Parsed: pathauto_separator
Parsed: pathauto_update_action
Parsed: pathauto_user_bulkupdate
Parsed: pathauto_user_pattern
Parsed: pathauto_user_supportsfeeds
Parsed: pathauto_verbose
Parsed: pathauto_punctuation_hyphen
Parsed: oldtheme_menu_item_link
Parsed: javascript_parsed
Parsed: nice_menus_custom_css
Parsed: pathauto_transliterate
Parsed: pathauto_node_supportsfeeds
Parsed: pathauto_case
Parsed: pathauto_max_bulk_update
Parsed: pathauto_reduce_ascii
Parsed: pathauto_punctuation_double_quotes
Parsed: pathauto_punctuation_backtick
Parsed: pathauto_punctuation_comma
Parsed: pathauto_punctuation_period
Parsed: pathauto_punctuation_underscore
Parsed: pathauto_punctuation_colon
Parsed: pathauto_punctuation_semicolon
Parsed: pathauto_punctuation_pipe
Parsed: pathauto_punctuation_left_curly
Parsed: pathauto_punctuation_left_square
Parsed: pathauto_punctuation_right_curly
Parsed: pathauto_punctuation_right_square
Parsed: pathauto_punctuation_plus
Parsed: pathauto_punctuation_equal
Parsed: pathauto_punctuation_asterisk
Parsed: pathauto_punctuation_ampersand
Parsed: pathauto_punctuation_percent
Parsed: pathauto_punctuation_caret
Parsed: pathauto_punctuation_dollar
Parsed: pathauto_punctuation_hash
Parsed: pathauto_punctuation_at
Parsed: pathauto_punctuation_exclamation
Parsed: pathauto_punctuation_tilde
Parsed: pathauto_punctuation_left_parenthesis
Parsed: pathauto_punctuation_right_parenthesis
Parsed: pathauto_punctuation_question_mark
Parsed: pathauto_punctuation_less_than
Parsed: pathauto_punctuation_greater_than
Parsed: pathauto_punctuation_back_slash
Parsed: pathauto_node_applytofeeds
Parsed: filter_default_format
Parsed: google_cse_cx
Parsed: google_cse_results_display
Parsed: google_cse_results_title
Parsed: google_cse_results_tab
Parsed: google_cse_results_prefix
Parsed: google_cse_results_suffix
Parsed: google_cse_sitesearch
Parsed: google_cse_sitesearch_option
Parsed: google_cse_sitesearch_default
Parsed: google_cse_cof_here
Parsed: google_cse_cof_google
Parsed: google_cse_searchbox_width
Parsed: google_cse_results_searchbox_width
Parsed: google_cse_results_width
Parsed: google_cse_results_gadget
Parsed: google_cse_domain
Parsed: google_cse_cr
Parsed: google_cse_gl
Parsed: google_cse_hl
Parsed: google_cse_locale_hl
Parsed: google_cse_ie
Parsed: google_cse_lr
Parsed: google_cse_locale_lr
Parsed: google_cse_oe
Parsed: google_cse_safe
Parsed: search404_jump
Parsed: search404_first
Parsed: search404_block_show
Parsed: search404_do_google_cse
Parsed: search404_use_or
Parsed: search404_use_search_engine
Parsed: search404_ignore
Parsed: search404_ignore_extensions
Parsed: search404_ignore_query
Parsed: search404_regex
Parsed: node_options_news
Parsed: upload_news
Parsed: form_build_id_news
Parsed: comment_news
Parsed: comment_default_mode_news
Parsed: comment_default_order_news
Parsed: comment_default_per_page_news
Parsed: comment_controls_news
Parsed: comment_anonymous_news
Parsed: comment_subject_field_news
Parsed: comment_preview_news
Parsed: comment_form_location_news
Parsed: nice_menus_name_1
Parsed: date_api_version
Parsed: nice_menus_menu_1
Parsed: nice_menus_type_1
Parsed: content_extra_weights_news
Parsed: googleanalytics_visibility
Parsed: googleanalytics_pages
Parsed: googleanalytics_account
Parsed: googleanalytics_custom
Parsed: googleanalytics_roles
Parsed: googleanalytics_segmentation
Parsed: googleanalytics_trackoutgoing
Parsed: googleanalytics_trackmailto
Parsed: googleanalytics_trackfiles
Parsed: googleanalytics_trackfiles_extensions
Parsed: googleanalytics_cache
Parsed: googleanalytics_site_search
Parsed: googleanalytics_trackadsense
Parsed: googleanalytics_codesnippet_before
Parsed: googleanalytics_codesnippet_after
Parsed: googleanalytics_js_scope
Parsed: admin_menu_margin_top
Parsed: admin_menu_position_fixed
Parsed: admin_menu_tweak_modules
Parsed: admin_menu_tweak_tabs
Parsed: wipe
Parsed: show_memcache_statistics
Parsed: pathauto_node_news_pattern
Parsed: site_offline
Parsed: user_register
Parsed: user_registration_help
Parsed: user_mail_register_admin_created_subject
Parsed: user_mail_register_admin_created_body
Parsed: user_mail_register_no_approval_required_subject
Parsed: user_mail_register_no_approval_required_body
Parsed: user_mail_register_pending_approval_subject
Parsed: user_mail_register_pending_approval_body
Parsed: user_mail_password_reset_subject
Parsed: user_mail_password_reset_body
Parsed: user_mail_status_activated_notify
Parsed: user_mail_status_activated_subject
Parsed: user_mail_status_activated_body
Parsed: user_mail_status_blocked_notify
Parsed: user_mail_status_blocked_subject
Parsed: user_mail_status_blocked_body
Parsed: user_mail_status_deleted_notify
Parsed: user_mail_status_deleted_subject
Parsed: user_mail_status_deleted_body
Parsed: user_signatures
Parsed: user_pictures
Parsed: user_picture_path
Parsed: user_picture_default
Parsed: user_picture_dimensions
Parsed: user_picture_file_size
Parsed: user_picture_guidelines
Parsed: cache
Parsed: cache_lifetime
Parsed: page_compression
Parsed: block_cache
Parsed: preprocess_css
Parsed: preprocess_js
Parsed: clear
Parsed: site_403
Parsed: error_level
Parsed: node_import:directory
Parsed: node_import:ftp:enabled
Parsed: node_import:ftp:user
Parsed: node_import:ftp:extensions
Parsed: site_offline_message
Parsed: site_slogan
Parsed: site_mission
Parsed: site_footer
Parsed: anonymous
Parsed: site_frontpage
Parsed: date:news:teaser:field_date_show_repeat_rule
Parsed: date:news:teaser:field_date_multiple_number
Parsed: date:news:teaser:field_date_multiple_from
Parsed: date:news:teaser:field_date_multiple_to
Parsed: date:news:teaser:field_date_fromto
Parsed: date:news:full:field_date_show_repeat_rule
Parsed: date:news:full:field_date_multiple_number
Parsed: date:news:full:field_date_multiple_from
Parsed: date:news:full:field_date_multiple_to
Parsed: date:news:full:field_date_fromto
Parsed: nice_menus_name_2
Parsed: nice_menus_menu_2
Parsed: nice_menus_type_2
Parsed: taxonomy_block_settings_vid
Parsed: taxonomy_block_settings_max_term
Parsed: taxonomy_block_settings_node_count
Parsed: taxonomy_block_settings_order_by
Parsed: taxonomy_block_settings_order_type
Parsed: statistics_enable_access_log
Parsed: statistics_flush_accesslog_timer
Parsed: statistics_count_content_views
Parsed: date_format_long
Parsed: date_format_medium
Parsed: date_format_short
Parsed: add_date_format_title
Parsed: add_date_format_type
Parsed: date_format_month_year
Parsed: drupal_http_request_fails
Parsed: date_format_dateline
Parsed: twitter_global_name
Parsed: twitter_global_password
Parsed: twitter_import
Parsed: twitter_expire
Parsed: twitter_types
Parsed: twitter_default_format
Parsed: twitter_api_url
Parsed: twitter_set_source
Parsed: views_defaults
Parsed: browscap_version
Parsed: browscap_imported
Parsed: cron_last
Parsed: content_extra_weights_zenfolio_gallery
Parsed: node_options_zenfolio_gallery
Parsed: upload_zenfolio_gallery
Parsed: form_build_id_zenfolio_gallery
Parsed: statistics_advanced_ignore_crawlers
Parsed: rules_counter
Parsed: statistics_advanced_ignore_repeat_views
Parsed: statistics_advanced_counter_node_types
Parsed: reset_accesslog
Parsed: reset_counter
Parsed: cck_required_single_select_field_test2_disallowed_first_option
Parsed: comment_default_mode_zenfolio_gallery
Parsed: taxonomy_breadcrumb_use_synonym
Parsed: taxonomy_breadcrumb_include_node_title
Parsed: comment_zenfolio_gallery
Parsed: custom_breadcrumbs_menu_list
Parsed: comment_form_location_zenfolio_gallery
Parsed: comment_preview_zenfolio_gallery
Parsed: custom_breadcrumbs_taxonomy_show_current_term_term
Parsed: comment_subject_field_zenfolio_gallery
Parsed: custom_breadcrumbs_taxonomy_result_nodes
Parsed: comment_default_order_zenfolio_gallery
Parsed: comment_default_per_page_zenfolio_gallery
Parsed: comment_controls_zenfolio_gallery
Parsed: comment_anonymous_zenfolio_gallery
Parsed: custom_breadcrumbs_use_exclude_list
Parsed: custom_breadcrumbs_exclude_list
Parsed: custom_breadcrumbs_home_id
Parsed: custom_breadcrumbs_parts_class
Parsed: custom_breadcrumbs_even_odd_class
Parsed: custom_breadcrumbs_type_class
Parsed: custom_breadcrumbs_append_bid_class
Parsed: table
Parsed: node_options_test
Parsed: form_build_id_test
Parsed: pathauto_node_zenfolio_gallery_pattern
Parsed: cck_required_single_select_field_select_test_disallowed_first_option
Parsed: vertical_tabs_forms
Parsed: content_extra_weights_test
Parsed: cck_required_single_select_field_test3_disallowed_first_option
Parsed: cck_required_single_select_field_test_disallowed_first_option
Parsed: googleanalytics_last_cache
Parsed: advanced_help_last_cron
Parsed: node_cron_comments_scale
Parsed: node_cron_views_scale
Parsed: node_cron_last
Parsed: statistics_day_timestampNotice: unserialize() [function.unserialize]: Error at offset 0 of 32 bytes in /var/www/vhosts/umhb.edu/httpdocs/includes/bootstrap.inc on line 478
Parsed: node_import:lock
Parsed: admin_menu_rebuild_linksWarning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/umhb.edu/httpdocs/includes/bootstrap.inc:479) in /var/www/vhosts/umhb.edu/httpdocs/includes/bootstrap.inc on line 637
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/umhb.edu/httpdocs/includes/bootstrap.inc:479) in /var/www/vhosts/umhb.edu/httpdocs/includes/bootstrap.inc on line 638
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/umhb.edu/httpdocs/includes/bootstrap.inc:479) in /var/www/vhosts/umhb.edu/httpdocs/includes/bootstrap.inc on line 639
Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/umhb.edu/httpdocs/includes/bootstrap.inc:479) in /var/www/vhosts/umhb.edu/httpdocs/includes/bootstrap.inc on line 640
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | node-import-818348.patch | 518 bytes | pebosi |
| Debug Report | 67.15 KB | cwebster |
Comments
Comment #1
cwebster CreditAttribution: cwebster commentedUninstalled the Node Import Module, removed the variable definition row for node_import:lock.
Comment #2
cwebster CreditAttribution: cwebster commentedThere was a problem with the CSV.
Comment #3
pebosi CreditAttribution: pebosi commentedThis bug is not really fixed yet. If you set variables directly on variables table you need to serialize the value. See attached patch.
Comment #4
Strompf CreditAttribution: Strompf commentedI'm having similar problems with Node_Import 1.2:
Eih, it does seem to work! I suspect the patch did the trick!
Thank you!