FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » SQL Error: Unique key violated for forum_read and forum_notify
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
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 Go to previous messageGo to previous message
awadallah is currently offline  awadallah   United States
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
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: V2.7.0RC1 - thread not displayed in forum list or navigator
Next Topic: locking/unlocking files crashed the server...
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Oct 20 05:29:16 GMT 2024

Total time taken to generate the page: 0.06140 seconds