Re: SQL Error: Unique key violated for forum_read and forum_notify [message #27860 is a reply to message #27846] |
Wed, 28 September 2005 20:39 |
awadallah
Messages: 11 Registered: September 2005 Location: Palo Alto, CA
Karma:
|
Junior Member |
|
|
MySQL optimization is enabled in fudforum.
The error is a unique key violation error (despitate fact that MySQL error message just says unknown error).
does your code depend on the error code returned ? In that case I would have to contact my hosting provider to figure out why the heck the mysql server is replying back with Unknown error.
But I did try the sql statement directly, and when I change one of the userid or forumid it works fine, so it is just about a unique key violation. I am referring to this statement:
INSERT INTO fud26_thread_notify (user_id, thread_id) VALUES (2, 12)
OR
INSERT INTO fud26_forum_read (forum_id, user_id, last_view) VALUES (10, 2, 1127899088)
Thanks,
-- amr
|
|
|