Whenever I edit an event under a category, I receive errors similar to the following:

user warning: Duplicate entry '644' for key 1 query: INSERT INTO book (nid, mlid, bid) VALUES (394, 644, 0) in /home/hsphere/local/home/eapprais/new.dast2dast.org/modules/category/wrappers/book/book.module on line 216.

user warning: Duplicate entry '254' for key 2 query: INSERT INTO book (nid, mlid, bid) VALUES (254, 303, 0) in /home/hsphere/local/home/eapprais/new.dast2dast.org/modules/category/wrappers/book/book.module on line 216.

http://www.new.dast2dast.org is a fresh install of Drupal 6.8 upgraded to 6.9

Thanks in advance

Comments

Jaza’s picture

Haven't seen this error before. The book wrapper already contains a check just above line 216, to ward against duplicate inserts. Can't reproduce for now. Please describe steps to reproduce.

desiree’s picture

Okay here is what I did today to reproduce:

1- Cloned an event and saved: no errors.
2- Edited the event without any change (just clicked on edit and then on save): no errors.
3- Edited the event's title and clicked on save produced the following errors:

user warning: Duplicate entry '994' for key 1 query: INSERT INTO book (nid, mlid, bid) VALUES (397, 994, 0) in /home/hsphere/local/home/eapprais/new.dast2dast.org/modules/category/wrappers/book/book.module on line 216.

Any thoughts?

Thank you

desiree’s picture

Also, when I edit the event node by deleting and adding another attachment, I get the same error:

user warning: Duplicate entry '994' for key 1 query: INSERT INTO book (nid, mlid, bid) VALUES (397, 994, 0) in /home/hsphere/local/home/eapprais/new.dast2dast.org/modules/category/wrappers/book/book.module on line 216.

desiree’s picture

Hi Jaza,

I searched drupal to see if anybody else is having this problem and found out that this is not unique to me and others are also having the same problem but have not posted their issues in the proper project. See http://drupal.org/node/332357

Have you had a chance to look into this?

I also wanted to add that although a duplicate entry error is posted when editing, the changes are saved.