By linuxpimp on

Hi all

I am _trying_ to create a large CCK form using CCK and fieldgroup as well as other peripheral modules.

I managed to add many fields, but now get the following error:

user warning: Got a packet bigger than 'max_allowed_packet' bytes query: UPDATE cache SET data = 'a:4:{s:6:\"tables\";a:107:{s:25:\"node_data_field_last_name\";a:5:{s:4:\"name\";s:14:\"node_1\";s:4:\"join\";a:2:{s:4:\"left\";a:2:{s:5:\"table\";s:4:\"node\";s:5:\"field\";s:3:\"vid\";}s:5:\"right\";a:1:{s:5:\"field\";s:3:\"vid\";}}s:6:\"fields\";a:1:{s:21:\"field_last_name_value\";a:9:{s:4:\"name\";s:33:\"Text: Last Name (field_last_name)\";s:10:\"addlfields\";a:0:{}s:8:\"sortable\";b:1;s:13:\"query_handler\";s:33:\"content_views_field_query_handler\";s:7:\"handler\";a:2:{s:33:\"content_views_field_handler_group\";s:21:\"Group multiple values\";s:35:\"content_views_field_handler_ungroup\";s:28:\"Do not group multiple values\";}s:6:\&quo in $MY_PATHincludes/database.mysql.inc on line 172

PLease advise.....

LP

⋅ Categories: Drupal 5.x

Comments

coreyp_1’s picture

coreyp_1 commented

http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

- Corey

lunatinker’s picture

lunatinker commented

Tools, tips, and links on optimizing mysql
http://drupal.org/node/85768
also -> http://drupal.org/node/121390

linuxpimp’s picture

linuxpimp commented

Thanks

What i'm trying to understand if the max_packet_size warning is just a message or if there is actual data loss?

Any ideas?

lp

coreyp_1’s picture

coreyp_1 commented

Well, it means that the query in question did not execute. In other words, if you were trying to insert or update data, then the query did not execute. No data was "lost", but nothing was added or changed, either (hopefully).

- Corey

linuxpimp’s picture

linuxpimp commented

got it, thanks!

I have asked the hosting company to double the max_size.

Thanks to all for contributing.

lp