[support] Watchdog error messages

[Casper Labuschagne]

On Mon, 07 Aug 2006 16:13:03 +0200, Kobus Myburgh  
<ITBJDM at 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!