| SQL Error: Unique key violated for forum_read and forum_notify [message #27842] |
Wed, 28 September 2005 10:53  |
awadallah
Messages: 11
Registered: September 2005
Location: Palo Alto, CA
Karma:
|
Junior Member |
|
|
Its a very weird error that only happens when a users trys to post to same topic more than once, sometimes I get the following error for thread_notify:
(/egypt_chat/index.php:200
/egypt_chat/theme/default/post.php:1081
/egypt_chat/theme/default/post.php:3861
/egypt_chat/index.php:1171
) 2000: Unknown MySQL error
Query: INSERT INTO fud26_thread_notify (user_id, thread_id) VALUES (2, 12)
_GET: array ( 't' => 'post', )
_POST: array ( 'msg_subject' => 'Re: التليفزيون', 'msg_icon' ...
Server Version: 4.1.12
and some other times I get the following error for thread_read:
(/egypt_chat/index.php:200
/egypt_chat/index.php:1046
/egypt_chat/theme/default/msg.php:1050
/egypt_chat/index.php:1171
) 2000: Unknown MySQL error
Query: INSERT INTO fud26_forum_read (forum_id, user_id, last_view) VALUES (10, 2, 1127896274)
_GET: array ( 't' => 'msg', 'th' => '12', 'rid' => '2', 'S' ..
Server Version: 4.1.12
or:
(/egypt_chat/index.php:200
/egypt_chat/index.php:1046
/egypt_chat/theme/default/post.php:3867
/egypt_chat/index.php:1171
) 2000: Unknown MySQL error
Query: INSERT INTO fud26_forum_read (forum_id, user_id, last_view) VALUES (10, 2, 1127899088)
_GET: array ( 't' => 'post', )
_POST: array ( 'spell_chk_subject_3' ...
Server Version: 4.1.12
its clear the the forum_id, user_id will be violated in both of these cases (since they are repeat visits) which leads mysql server to return an error.
what is the solution ? I had this problem with 2.6, I upgraded to 2.7.2 and still have this problem. Everything else seems to be working fine, user registration, posting a brand new topic, etc.
thanks,
-- amr
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]