Textpattern CMS

#1 2008-02-08 19:21:23

csaba

Member

Registered: 2007-12-21

Posts: 28

Error message: Duplicate entry '4' for key 1 insert into textpattern..

All was fine until now, but now when i writing an article the following error message appears. I have wrote several other articles today and i have no idea why is this happening now. Here is the error what appears above on the page wheare i was writing the article:

Warning: Duplicate entry ‘4’ for key 1 insert into textpattern set Title = ‘test’, Body = ‘test’, Body_html = ‘

test
‘, Excerpt = ‘’, Excerpt_html = ‘’, Image = ‘’, Keywords = ‘’, Status = 4, Posted = from_unixtime(1202498067), LastMod = now(), AuthorID = ‘Aldor’, Section = ‘About’, Category1 = ‘’, Category2 = ‘’, textile_body = 1, textile_excerpt = 1, Annotate = 0, override_form = ‘’, url_title = ‘test’, AnnotateInvite = ‘Comenteaza’, custom_1 = ‘’, custom_2 = ‘’, custom_3 = ‘’, custom_4 = ‘’, custom_5 = ‘’, custom_6 = ‘’, custom_7 = ‘’, custom_8 = ‘’, custom_9 = ‘’, custom_10 = ‘’, uid = ‘368af8c99bd5238adf776215d7d3e7d1’, feed_time = now() in /home/numism/public_html/coins/textpattern/lib/txplib_db.php on line 84

#2 2008-02-08 22:10:03

csaba

Member

Registered: 2007-12-21

Posts: 28

Re: Error message: Duplicate entry '4' for key 1 insert into textpattern..

After reading several topics, i have checked the ‘textpattern’ table, and it has the “auto_increment” set on column ‘ID’ … then what could be the problem? i did not changed anything in the database, and i did not made an update..

#3 2008-02-08 22:12:50

iblastoff

Plugin Author

From: Toronto

Registered: 2006-06-11

Posts: 1,197

Website

Re: Error message: Duplicate entry '4' for key 1 insert into textpattern..

tried repairing the table?

---

my plugins || iblastoff.ca

#4 2008-02-08 22:14:29

csaba

Member

Registered: 2007-12-21

Posts: 28

Re: Error message: Duplicate entry '4' for key 1 insert into textpattern..

but how? i dont know much about this..
i made a database check and i see this error:
textpattern warning : Auto-increment value: 3 is smaller than max used value: 93

what should i do?

#5 2008-02-08 22:21:43

csaba

Member

Registered: 2007-12-21

Posts: 28

Re: Error message: Duplicate entry '4' for key 1 insert into textpattern..

It was so simple .. and you were right .. i did a Repair Table under Table Maintenance and that fixed it…

thanks!