Wait.. I think I know what this is about. Considering the layout of how we are going to use drupal here, I went through and renamed all the tablespaces I was using for my site to have a prefix (the tib_ one) and everything seemed perfectly fine - apparently the indexing method got screwed up because it was reporting duplicates all the way up till it found a new number (thankfully only 9) and picked up again.
Why did renaming tablespaces reset the content index number?
<EOL> Tib
On Mon, 20 Jun 2005, Tib wrote:
I was trying to use the story module, and when I created my first page it gave me a 'duplicate entry' error. I thought maybe the ()'s and such in the text were confusing it, so I tried again with none of that.
I still get the error. Why is the story module using the same content type (node) as a page, yet has it's own counter to track actual records/entries?
This is going to be a pain in the ass real quick unless I can find a work around. Any ideas?
Duplicate entry '2' for key 1 query: INSERT INTO tib_node (status, moderate, promote, sticky, comment, title, body, format, uid, created, type, teaser, changed, nid) VALUES('1', '0', '0', '0', '2', 'test', 'testing', '3', '1', '1119314160', 'story', 'testing', '1119314228', '2') in /home/tib/public_html/includes/database.mysql.inc on line 66.