Hi,
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.
This is a site based on 470rc1 (yip, going to upgrade in a day or so - this site has been in development for quite a while), so if no-one can confirm this exact message with 4.7.3, then I won't file a bug report, but if someone using 4.7.3 can confirm this, we probably have a bug.
Regards,
Kobus
ITBJDM@puknet.puk.ac.za 8/7/2006 10:33:29 AM >>>
Hi,
I get these errors on a site that I set up:
user warning: Duplicate entry '0' for key 1 query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'page not found', '<em>node?destination=node</em> not found.', 1, '', '/?q=node?destination=node', '', '155.232.250.35', 1154939472) in /usr/home/signetaf/public_html/includes/database.mysql.inc on line 120.
I have deleted all the files, copied them over to the server from scratch and recreated the database, but still the errors persist. Any ideas would be greatly appreciated.
Regards and thanks,
Kobus
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!
-
Casper Labuschagne -
Kobus Myburgh