By Mind Design on

Hi,

I have been searching on this error message and I can see others have the same problem, but with specific modules.

This error message suddenly appeared when inserting new content (nodes). Editing existing nodes is no problem.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 2: INSERT INTO {node} (vid, type, language, title, uid, status, created, changed, promote, sticky) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => page [:db_insert_placeholder_2] => und [:db_insert_placeholder_3] => App [:db_insert_placeholder_4] => 1 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 1314293406 [:db_insert_placeholder_7] => 1314293406 [:db_insert_placeholder_8] => 0 [:db_insert_placeholder_9] => 0 ) i drupal_write_record() (linje 6861 av /<install dir>/includes/common.inc).

I have tried to disable modules to see if that helps, but no luck so far. So I try to post my problem here.

Can anyone help? Just point me in any direction?

Regards,
Tommy

⋅ Categories: Drupal 7.x

Comments

DooDoo’s picture

DooDoo commented

I also have a same problem, anyone please kindly advise.

owntheweb’s picture

owntheweb commented

I guess I'm having the same issue now myself. It started after I added Organic Groups. Are you two using Organic Groups? I was also futzing with the OG field permissions. Not sure if that helps at all.

I'm not having the same issues when adding other non-related content types like pages.

Chris

Worlds to explore. Worlds to create.
Blog: http://www.christopherstevens.cc/blog
Twitter: http://www.twitter.com/owntheweb

owntheweb’s picture

owntheweb commented

Perhaps OG is unrelated. I disabled a rule (Rules module) that checked and altered my content on save. Errors gone! My guess at the moment is that the error started happening after I added more fields to my content type after creating my rule? The errors start happening after re-enabling my rule. I guess I need to troubleshoot, but at least I can make the errors stop. :)

Worlds to explore. Worlds to create.
Blog: http://www.christopherstevens.cc/blog
Twitter: http://www.twitter.com/owntheweb

etron770’s picture

etron770 commented

The same error occurs when enabled http://drupal.org/project/captcha 7.x-1.0-beta1
disabling this module solved the problem

Drupal 7.8
Domain Access - without Domain Theme
IMCE
Wysiwyg
IMCE Wysiwyg API bridge

Kernel without:
Aggregator
Blog
Book
Content translation
OpenID
Syslog
Testing
Tracker

knalstaaf’s picture

knalstaaf commented

#1370982: Relevant Content: Errors when saving a block (PDOException)

mhamed’s picture

mhamed commented

This triggered after activating the forum module .

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'forums' for key 'machine_name': INSERT INTO {taxonomy_vocabulary} (name, machine_name, description, hierarchy, module, weight) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => Forums [:db_insert_placeholder_1] => forums [:db_insert_placeholder_2] => Forum navigation vocabulary [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => forum [:db_insert_placeholder_5] => -10 ) in drupal_write_record() (line 6975 of /public_html/includes/common.inc).

larsam

http://larssam.org

facebook

http://www.facebook.com/#!/hmimid

Twitter

https://twitter.com/#!/word_to_say

Gmail

mhamed.hmimid@gmail.com

Skype

mhamed.hmimid