Hi,
I have a view with http://drupal.org/project/views_bulk_operations in relation with http://drupal.org/project/taxonomy_node_operations. This worked great, but after updating views_bulk_operations I got following errors:

user warning: Got a packet bigger than 'max_allowed_packet' bytes query: INSERT INTO variable (name, value) VALUES ('views_bulk_operations_prefs_94', 'a:2034:{s:32:\"bccda4144f0c6959df618f2744e5dd89\";a:6:{s:5:\"label\";s:24:\"Rebuild image thumbnails\";s:8:\"callback\";s:24:\"image_operations_rebuild\";s:18:\"callback arguments\";N;s:7:\"enabled\";i:0;s:12:\"configurable\";b:0;s:4:\"type\";s:4:\"node\";}s:32:\"aca777456df408ac8b61e37738a22cac\";a:6:{s:5:\"label\";s:17:\"Update path alias\";s:8:\"callback\";s:31:\"pathauto_node_operations_update\";s:18:\"callback arguments\";N;s:7:\"enabled\";i:0;s:12:\"configurable\";b:0;s:4:\"type\";s:4:\"node\";}s:32:\"e4c1b356fe435015ae7b05add26f31f8\";a:6:{s:5:\"label\";s:25:\"Publicatie ongedaan maken\";s:8:\"callback\";s:25:\"node_operations_unpublish\";s:18:\"callback arguments\";N;s:7:\"enabled\";i:0;s:12:\"configurable\";b:0;s:4:\"type\";s:4:\"node\";}s:32:\"1e360b8fd1952c530fda6390e7fee4dc\";a:6:{s:5:\"label\";s:27:\"Aanraden voor de voorpagina\";s:8:\"callback\";s:23:\"node_operations_promote\";s:18:\"callback arguments\";N;s:7:\"enabled\";i:0;s:12:\"configurable\";b:0;s:4:\"type\";s:4:\"node\";}s:32:\"cd92746288f4f0c296a175b046e45e64\";a:6:{s:5:\"label\";s:23:\"Aanraden ongedaan maken\";s:8:\"callback\";s:22:\"node_operations_demote\";s:18:\"callback arguments\";N;s:7:\"enabled\";i:0;s:12:\"configurable\";b:0;s:4:\"type\";s:4:\"node\";}s:32:\"e1d403c4579335a49ec15986b95fa1bd\";a:6:{s:5:\"label\";s:29:\"Vastplakken bovenaan de lijst\";s:8:\"callback\";s:22:\"node_operations_sticky\";s:18:\"callback arguments\";N;s:7:\"enabled\";i:0;s:12:\"configurable\";b:0;s:4:\"type\";s:4:\"node\";}s:32:\"5c6b92c5ca2fcd8df76f6d2c0b42cbfd\";a:6:{s:5:\"label\";s:26:\"Vastplakken ongedaan maken\";s:8:\"callback\";s:24:\"node_operations_unsticky\";s:18:\"callback

Thanks for going into this!
Greetings, Martijn

Comments

infojunkie’s picture

infojunkie
Location Vancouver
commented
Assigned: Unassigned » infojunkie

Interesting bug. As far as I understand taxonomy_node_operations, it creates a new action for each and every taxonomy term. If your vocabulary is huge, then the number of actions to be stored in the VBO prefs variable (shown above) will also be huge. For example, the views_bulk_operations_prefs_94 variable contains 2034 entries! Clearly a very long string that MySQL isn't able to handle in one go. This is a scalability problem that needs to be addressed.

summit’s picture

summit commented

Well said kratib! Please someone with the right knowledge get into it please! Greetings, Martijn

infojunkie’s picture

infojunkie
Location Vancouver
commented
Version: 5.x-1.0-beta5 » 5.x-1.x-dev

I am about to make changes in the Operations settings tab of VBO so I will likely change the way the settings are saved as well, so as to avoid the overly large settings string. Thanks for your patience.

In the meantime, the latest VBO-dev version contains a new action called taxonomy_action (designed for actions 2.x) that removes the need to use Taxonomy Node Operations. If you get the chance, please try it.

infojunkie’s picture

infojunkie
Location Vancouver
commented
Status: Active » Closed (fixed)

Closed unless someone minds.