Textpattern CMS

#1 2007-03-08 01:27:52

stebastian

New Member

Registered: 2005-07-29

Posts: 6

Warning message after upgrading to 4.0.4

Hi,

I upgraded a textpattern installation from 4.0.3 to 4.0.4. Everything seems to be in order except for a warning message I’m receiving at the top of the page:

Warning: Duplicate entry ‘0’ for key 1 insert into txp_log set `time`=now(),page=’/’

I looked at the txp_log table and see only one entry (entry ‘0’). If my assumption is correct, the textpattern is attempting to write to the database to log the activity on the website however it keep inserting entries at ‘0’

Any one else encounter a similar problem? How were you able to resolve it?

Steve

#2 2007-03-08 01:37:47

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Warning message after upgrading to 4.0.4

Open up a program like phpMyAdmin and view your txp_log table. In the Structure tab, there should be a listing of all the columns.

Look along the id field to the “Extra” column. Does it say “auto_increment”?

Next, lookat “Row Statistics”. What does “Next Autoindex” have?

#3 2007-03-08 02:22:44

stebastian

New Member

Registered: 2005-07-29

Posts: 6

Re: Warning message after upgrading to 4.0.4

Hi Mary,

Thanks for your prompt response!

It doesn’t say “auto_increment”. Perhaps, as a result, there is no item in the row statistics table that pertains to “Next Autoindex”

Do you suppose the this was changed when I upgraded to 4.0.4?

Steve

#4 2007-03-08 04:21:12

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Warning message after upgrading to 4.0.4

It shouldn’t have, but there’s not really any way of telling short of redoing everything (which I wouldn’t bother with).

What you need to do, then:

1. Click the “Empty” tab (if it is clickable) to empty the txp_log table.
2. Check the box for that id field and edit it (Pencil icon).
3. Choose “auto_increment” from the “Extra” dropdown.
4. Click save.

That should resolve the problem. :)