Thanks, Casper. So it must've been a problem in 4.7.0 RC1.
The sequences table doesn't have an entry for watchdog (at least not in my sites), and from what I can tell, it doesn't need it, as there are never updates to the table, just additions and automatic deletions, and no links to other database tables.
Regards,
Kobus
casperl@krooninfo.co.za 8/7/2006 5:49:50 PM >>>
On Mon, 07 Aug 2006 16:13:03 +0200, Kobus Myburgh ITBJDM@puknet.puk.ac.za wrote:
I found the error - the wid field of the watchdog table doesn't have the auto_increment attribute set. Is this perhaps a bug? Giving it
an
auto_increment value removes this error.
I would be the first to confess that I am just a little out of my depth
here but let me try....
A good rule of thumb with SQL errors that report duplicate content for
auto_increment fields is to go and check if that database / field does not perhaps exist in the sequences table. It has happened many times that values in the sequences table get zapped and I would manually set it higher in the sequences table.
It works but 1) why it happens, I don't know and 2) whether I am doing the right thing or screwing something else up - I don't know.
And ... my experience .... if visits to your site drop and errors rise and nothing gets posted - go and check the sequences table because if values there have been nuked, registered visitors cannot post new stories!!!
Only you won't know it until you wonder where your visitors have gone....
And no, I run 4.7.2 and some 4.7.3 and I don't get that error.
Casper Labuschagne +27827054416 www.krooninfo.co.za www.boerboel.co.za Visit http://www.ubuntu.com for a highly recommended open source alternative to Windows!