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!