- CCK form field changes using Drupal's hook_form_alter don't work? Use #after_build
- Views query substitutions in Drupal 6
- Should you be building your next website in Drupal?
- How to add Zoopy video to your Drupal site using CCK and the Embedded Media Field module
- My state of Drupal, today, 18 March 2009
- Drupal Johannesburg 11 March meetup notes
- Quick Drupal setup using Acquia's DAMP stack
- Drupal conference 2009 videos available on the Internet Archive
- Drupal 500 Internal Server Error on shared hosting
- The case for Drupal
Drupal node insert error related to the sequences table
I recently added a lot of data to a drupal site by running some scripts that I'd created in php. This was to save me the time of manually capturing the content. After successfully adding the content, when I tried to add a new content item, I got the following error: Warning: Duplicate entry '503-503' for key 1 query: INSERT INTO node (nid, vid, title, type, uid, status, created, changed, comment, promote, moderate, sticky) VALUES (503, 503, 'World Bank ', 'content_organisation', 1, 1, 1171017191, 1171017191, 2, 1, 0, 0) in It turns out that Drupal uses the sequences table to keep track of what the highest id in certain tables is. I had forgotten to update this table with the id of the most recent node that I'd added.
This is how my sequences table looked:

This is how my node table looked:
After updating the sequences table fields node_nid, and node_revisions_vid to be 583, I was able to add a new node, and my Drupal site was back to normal. For more information check out: http://drupal.org/node/69722
- Tags:
- Wordpress category:
