By priyanka2008 on

Hello Everybody, When i was creating the content type fields, I got the this error , please any one could tell me why i am getting this error

"Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE cache_views SET data = 'a:4:{s:6:\\"tables\\";a:173:{s:17:\\"nodefamily_parent\\";a:3:{s:4:\\"name\\";s:10:\\"nodefamily\\";s:4:\\"join\\";a:3:{s:4:\\"left\\";a:2:{s:5:\\"table\\";s:4:\\"node\\";s:5:\\"field\\";s:3:\\"nid\\";}s:5:\\"right\\";a:1:{s:5:\\"field\\";s:10:\\"parent_nid\\";}s:4:\\"type\\";s:5:\\"inne in /homez.116/linkus/www/link-us/includes/database.mysql.inc on line 172"

Please any one could help me...

⋅ Categories: Drupal 5.x

Comments

beautifulmind’s picture

beautifulmind
he/him
Primary language Gujarati
Location Dubai
commented

Remove those fields, and empty the cache using devel module. Run the cron.
Try to re-create those fields.

Regards.

Regards.
🪷 Beautifulmind

priyanka2008’s picture

priyanka2008 commented

yes i removed the fields...and the error was solved....and i runed the cron also....But after recreating the field...i again got the same error...i think the database is full....plss reply

umarbukhari’s picture

umarbukhari commented

I think you must clear the cache of drupal or go to the theme selection page and change your theme and then again select your theme. It will solve your problem.

Drupal Developers

priyanka2008’s picture

priyanka2008 commented

i cleared the cache but there is a same error....

beautifulmind’s picture

beautifulmind
he/him
Primary language Gujarati
Location Dubai
commented

I think the error is not b'coz of the CCK fields.
Check if the same error occurs at admin > build and its children.

Regards.

Regards.
🪷 Beautifulmind

priyanka2008’s picture

priyanka2008 commented

yes there is a error ocuuring at the admin.....too

beautifulmind’s picture

beautifulmind
he/him
Primary language Gujarati
Location Dubai
commented

Got you!!!

Check this out http://drupal.org/node/379976

Regards.

Regards.
🪷 Beautifulmind

priyanka2008’s picture

priyanka2008 commented

sorry Not got..

beautifulmind’s picture

beautifulmind
he/him
Primary language Gujarati
Location Dubai
commented

You have to set max_allowed_packet to 2M in your my.cnf file.

Ask your system admin or host to do that for you.

Regards.

Regards.
🪷 Beautifulmind

esmailzadeh’s picture

esmailzadeh commented

check the lock permission of mysql db user

priyanka2008’s picture

priyanka2008 commented

Checked...No problem on..lock permission

fuquam’s picture

fuquam commented

I'm having the same issue. I've asked my host to change the my.cnf file. This has happened to me before while trying to create form components via the webform module.

-------------------------
Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Unknown column 'email' in 'field list'\nquery: INSERT INTO webform_component (nid, cid, pid, form_key, name, type, value, extra, mandatory, weight, email) . . . . . .

fuquam’s picture

fuquam commented

"We cannot change the my.cnf sorry.
If you have tables that won't unlock let us know we can help with that. "

Not sure if it has to do with being on a shared server. I tried removing the watchdog module but the error still comes up. I don't want to delete the watchdog table in the db.