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