I get this error message on some hard to define admin/ pages, such as the module page, the display and manage fields page mostly.
See attached "filefield_errors-RTF.zip" (Zipped RTF for complete logs), when the error first appeared:
- error 1 is after the first saving of a filefield field (widget and machine name submit)
- error 2 is after the saving of the field (human name and filefield settings submit)
- error 3 appeared in a blank page after weighting a second filefield and submitting
Errors just stops when I disable book.module. But I first thought it was a filefield.module issue. When I disabled this filefield.module, the error message on the manage/display field page disappeared. But it came back so I'm not sure whether this is an incompatibility or something else. The red error message appeared in any case, but seems bigger each time. It seems that I get the following top-of-page error message (see "book_top-of-module-page_error.png" attached) only on the module page:
Warning: Got a packet bigger than 'max_allowed_packet' bytes query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Got a packet bigger than &#039;max_allowed_packet&#039; bytes\nquery: UPDATE cache_views SET data = &#039;a:4:{s:6:\\&quot;tables\\&quot;;a:241:{s:4:\\&quot;book\\&quot;;a:5:{s:4:\\&quot;name\\&quot;;s:4:\\&quot;book\\&quot;;s:8:\\&quot;provider\\&quot;;s:8:\\&quot;internal\\&quot;;s:4:\\&quot;join\\&quot;;a:2:{s:4:\\&quot;left\\&quot;;a:2:{s:5:\\&quot;table\\&quot;;s:4:\\&quot;node\\&quot;;s:5:\\&quot;field\\&quot;;s:3:\\&quot;vid\\&quot;;}s:5:\\&quot;right\\&quot;;a:1:{s:5:\\&quot;field\\&quot;;s:3:\\&quot;vid\\&quot;;}}s:7:\\&quot;f in /Shared Items/iDoc/drupalpp/includes/database.mysql.inc on line 172
As I fear to get an error of the "blank page" type (RTF #3) which would leave me with no possibility to get my site back working, I'm not testing too much...
For info:
- I have about 500 hundred terms under about 20 vocabs. Six to ten vocabs have each a cck_taxonomy in one node type, and at least six of those vocabs have a specific cck_taxonomy_ssu field for EACH of 5 to 6 nodetype (I should not reuse my fields from one type to another*), which makes a lot of cck content to log in watchdog. What is strange is that the book page type has no field of its own, and its error is shown on -what appears to be- non-related pages...
- I think this precision is important according to the red-error message which evokes field content (see the content and the length of the scrolling bar of image 13)
* The reason is the need for different field labels and the need for independency and clear machine_name reference of the tables concerned in case of nodedata exports. But I may reconsider this decision in case its inapropriate for drupal and my server...
- My site's cache is turn off (3 users max without big database requests. The error shows even when I'm the only user on the site)
- My specs: see attached Zipped RTF server_specs file which is a capture of my system_info.module page.
- (don't forget to add the .rtf extension once unzipped if you use a PC/windows)
Hope you'll get enough to see what's wrong. Good luck. And don't hesitate to ask me for further infos...
Greetings, Arsène
| Comment | File | Size | Author |
|---|---|---|---|
| server_specs.zip | 2.01 KB | doc2@drupalfr.org | |
| Image 13.png | 174.81 KB | doc2@drupalfr.org | |
| book_top-of-module-page_error.png | 30.29 KB | doc2@drupalfr.org | |
| filefield_errors-RTF.zip | 179.09 KB | doc2@drupalfr.org |
Comments
Comment #1
doc2@drupalfr.org commentedThe bug first appeared to be related to other modules...
In fact, this is a duplicate from: #121390: Many CCK fields and using views causing max_allowed_packet errors with MySQL query "UPDATE cache"
Therefore changing from "book" to "views" (cache) and from "active" to "duplicate"