Textpattern CMS

#1 2007-06-09 17:54:44

mattgilbert

Member

Registered: 2006-03-23

Posts: 70

Warning: Duplicate entry

I just move a textpattern installation to a different server, and everything seems alright, except there’s this warning when the site is loaded:

Warning: Duplicate entry ‘0’ for key 1 insert into rre_txp_log set `time`=now(),page=’/txp/projects/3/test-project’,ip=‘76.17.114.241’,host=‘c-76-17-114-241.hsd1.ga.comcast.net’,refer=’‘,status=‘200’,method=‘GET’ textpattern/publish/log.php:66 safe_insert() in /home/rrenetaa/public_html/txp/textpattern/lib/txplib_db.php on line 84

Also, when I add a new article (except for the first one i added) it has this warning:

Warning: Duplicate entry ‘0’ for key 1 insert into rre_textpattern set Title = ‘Another test project’, Body = ‘One more test’, Body_html = ‘One more test’, Excerpt = ‘’, Excerpt_html = ‘’, Image = ‘’, Keywords = ‘’, Status = 4, Posted = now(), LastMod = now(), AuthorID = ‘mattgilbert’, Section = ‘projects’, Category1 = ‘’, Category2 = ‘’, textile_body = 0, textile_excerpt = 0, Annotate = 0, override_form = ‘’, url_title = ‘another-test-project’, AnnotateInvite = ‘’, custom_1 = ‘’, custom_2 = ‘’, custom_3 = ‘’, custom_4 = ‘’, custom_5 = ‘’, custom_6 = ‘’, custom_7 = ‘’, custom_8 = ‘’, custom_9 = ‘’, custom_10 = ‘’, uid = ‘0c6ab8c2c1380c25e79123b427477ee6’, feed_time = now() textpattern/include/t in /home/rrenetaa/public_html/txp/textpattern/lib/txplib_db.php on line 84

So it seems to be giving logs and articles no id, or an id or ‘0’ all the time. Any clues? I moved to an older version of MySQL, from 4.1.15 to 4.0.27, so that might have something to do with it.

#2 2007-06-09 18:15:52

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Warning: Duplicate entry

See this topic for an explanation and solution.

#3 2007-06-09 18:26:13

mattgilbert

Member

Registered: 2006-03-23

Posts: 70

Re: Warning: Duplicate entry

Thanks! That did the trick. Not sure why I couldn’t find that thread in my searches.