[support] Watchdog error messages

[Kobus Myburgh]

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 at krooninfo.co.za 8/7/2006 5:49:50 PM >>>
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!
-- 
[ Drupal support list | http://lists.drupal.org/ ]