Hello, I got an unexpected error on the last step of importing data from csv file. Before all have been done excellent, I've changed only one thing in process: for refreshing catalog with thousands of parts i use bulk delete module for deleting 6400 imported nodes which build views table. Next importing was failed with:
"You need to have Javascript enabled to see the progress of this import.
Возникла ошибка. \n/admin/content/node_import/9/continue\n
Warning: Got a packet bigger than 'max_allowed_packet' bytes 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:1726726:\"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE cache_menu SET data = 'a:2:{s:4:\\"tree\\";a:111:{i:2;a:2:{s:4:\\"link\\";a:37:{s:14:\\"load_functions\\";s:0:\\"\\";s:16:\\"to_arg_functions\\";s:0:\\"\\";s:15:\\"access_callback\\";s:11:\\"user_access\\";s:16:\\"access_arguments\\";s:45:\\"a:1:{i:0;s:27:\\"access administration pages\\";}\\";s:13:\\"page_callback\\";s:22:\\"s in /home/jpauto/data/www/jpauto.ru/includes/database.mysql.inc on line 128
{ "status": 1, "message": "1 row imported\x3cbr /\x3e0 rows with errors", "percentage": 0 }"
Try to fixed mysql, clear caches, reinstall module to the last dev version but nothing. Please help me, I haven't any oportunity to fixed this error by myself and wish to thank you for this powerfull module when create a paypal instead of webmoney. I would be grateful for any help!

CommentFileSizeAuthor
node_import-node_cat_parts-9.txt53.4 KBDamagE

Comments

Robrecht Jacques’s picture

Robrecht Jacques commented

Can you try and increase the max_allowed_packet MySQL setting?

See: http://drupal.org/node/379976 or http://drupal.org/project/db_tweaks (now in http://drupal.org/project/drupal_tweaks).

DamagE’s picture

DamagE commented

Robrecht Jacques, thank you very much for diagnosis! I tried solve this error but after your advice take a look in that direction. Drupal tweaks don't help me directly, so I found my.cnf and change this value to 32 Mb. Now all works perfect, thanks again!

DamagE’s picture

DamagE commented
Title: node import error "You need to have Javascript enabled to see the progress of this import." » [SOLVED] node import error "You need to have Javascript enabled to see the progress of this import."
mautumn’s picture

mautumn commented
Title: [SOLVED] node import error "You need to have Javascript enabled to see the progress of this import." » NOT [SOLVED] node import error "You need to have Javascript enabled to see the progress of this import."

Our max_allowed_packet is much higher than 32Mb (1024Mb) and we are only importing a handful of nodes with 4 plain text fields, each about 20 characters (Bytes) long - and we still get this message! Moreover, it is only importing one record per cron run! Is this normal or am I doing wrong? The only thing that comes to mind is the fact we are importing Ubercart products. The imported records look fine, our main problem is that it is just doing one at each cron run.

anonymous07’s picture

anonymous07 commented

In my case, this didn't go away even after increasing the max_allowed_packet ... what did fix it was increasing the PHP memory limit.

timmeh’s picture

timmeh commented

subscribe to this. i am having the exact same problems