Hello,
I have a strange case of duplicate entry error. It is strange because I did not upgrade prior to this error message; the only thing I did was to rearrange fields for my content_type blog entry. This is the message I get whenever I try to change an entry or to submit a new entry:
Warning: Duplicate entry '4647' for key 1 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:565:\"Duplicate entry '4647' for key 1\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (1, 'content', '@type: added %title.', 'a:2:{s:5:\\"@type\\";s:4:\\"page\\";s:6:\\"%title\\";s:4:\\"test\\";}', 5, '<a href=\\"/node/110\\">Anzeigen</a>', 'http://www.moviephil.de/node/add/page', 'http://www.moviephil.de/node/add/page', '213.39.1 in /home/www/doc/17446/moviephil.de/www/includes/database.mysqli.inc on line 128
Does anybody have a guess what might cause this problem? Any support is much appreciated.
Comments
Key 1 in the {watchdog}
Key 1 in the {watchdog} table is wid which should be an auto-increment field, so MySQL should automatically ensure that you don't get a duplicate entry (there must already be a row with wid=4647). Maybe the table (or its index) is damaged. Try checking/repairing it.
gpk
----
www.alexoria.co.uk
gpk
----
www.alexoria.co.uk
another error message
Thank you, I checked the wid but did not find a row wid=4647. Also, if I check the table I get the message that it is okay. What I did instead was to delete two rows in the table search_dataset which referred to the two posts I tried to change and could not, the column Reindex had a different number from "0". After that, I was able to change the content; however, I still get error messages:
user warning: Incorrect key file for table './db174460008/node.MYI'; try to repair it query: UPDATE node SET vid = 39, type = 'blog', language = '', title = 'title', uid = 1, status = 1, created = 1197386507, changed = 1218889973, comment = 2, promote = 1, sticky = 0 WHERE nid = 39 in /home/www/doc/17446/moviephil.de/www/includes/common.inc on line 3308.
warning: mysqli_query() [function.mysqli-query]: (HY000/1030): Got error 134 from storage engine in /home/www/doc/17446/moviephil.de/www/includes/database.mysqli.inc on line 108.
I really don't know what to do about that.
Try repairing the whole
Try repairing the whole database...
Also check for anything similar in the CCK issue queue(s).
gpk
----
www.alexoria.co.uk
gpk
----
www.alexoria.co.uk
Just did that
I just repaired the whole database and now it seems to work again. So thank you very much for your support. I'd be even more happy if I knew what caused this behaviour. Thanks also for your adivce, I will check the CCK issue queues.
DB can get damaged if server
DB can get damaged if server is overloaded and a page request fails to complete properly for this, or another, reason.
gpk
----
www.alexoria.co.uk
gpk
----
www.alexoria.co.uk
I think I have the same
I think I have the same problem:
user warning: Incorrect key file for table '/var/tmp/#sql_3b8_0.MYI'; try to repair it query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta LEFT JOIN i18n_blocks i18n ON b.module = i18n.module AND b.delta = i18n.delta WHERE (i18n.language ='ru' OR i18n.language ='' OR i18n.language IS NULL) AND ( b.theme = 'framework' AND b.status = 1 AND (r.rid IN (2,4) OR r.rid IS NULL) )ORDER BY b.region, b.weight, b.module in /usr/home/bshm/www/site1/public_html/modules/block/block.module on line 407.
Could you please tell me what you mean by repairing the database? Any new information since your last post?