my Local host install works fine. I uploaded all files to the subdomain, exported my local database with data (mysql 4 compatibility from mysql 5) then imported the data to the subdomain on the server. It's a test to see if I can fully design the site then upload all including database to my server. This may be a database compatibility problem (my error), my local host mysql version is 5.0.15 and the host version is 4.1.10a. All seems to work except when I log in/log out I get this message and can't move further:

Warning: Duplicate entry '0' for key 1 query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Duplicate entry '0' for key 1\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'access denied', '<em>logout</em> denied access.', 1, '<a href=\\"/?q=logout\\" class=\\"active\\">view</a>', '/?q=logout&destination=logout', 'http://subdomain.com/?q=logout', 'ip address here', 1142978935) in folderpath/includes/database.mysql.inc on line 120.', 2, '', '/?q=logout&destination=logout', 'http://subdomain.com/?q=logout', 'ip address here', 1142978935) in folderpath/includes/database.mysql.inc on line 120

Maybe I exported the mysql v 5 version improperly to import into mysql 4 schema. any suggestions?

Comments

ragsman’s picture

no one? I noticed I can delete watchdog entries and cache from the database, and it works fine, but once I log on or log out after that this error starts happening again.

Thanks

Blaster’s picture

I have the same problem on my site. My host still has MySQL 3.23 but in another post I read it should work too on that.

It might be because I imported the data to a lower MySQL version? I have to test this when I get home tonight.

edit: I can confirm that this is the case. Something goes wrong with the export/import even though I exported from MySQL 5 with 323 compatibility.

Shmee’s picture

I moved my site from MySQL 5.0 to 4.1 and I get these errors as well. Any help would be great.

-Shmee

Shmee’s picture

Edit the database.4.1.mysql file that comes with a base install of drupal to not include the default values for the tables. Execute that file, then create a SQL dump of your current site that just has inserts to fill the tables you created with the first file.

This got my site up and running, I hope it helps.

natureday’s picture

I had the same problem on mine. Except I found out it was a problem with my dreamweaver.
You guys should check the folder that the index is pointing to.
Anna
anna@natureday.com