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

Home » FUDforum Development » Bug Reports » Error trying to mark messages read
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Error trying to mark messages read [message #18566 is a reply to message #18565] Thu, 27 May 2004 17:35 Go to previous messageGo to previous message
darkness is currently offline  darkness   United States
Messages: 7
Registered: May 2004
Karma:
Junior Member
This query seems to work in pgsql:

fcn_fudforums=# UPDATE fud26_1_read SET user_id=4, thread_id=t.id, msg_id=t.last_post_id, last_view=1085673943 FROM (SELECT id, last_post_id FROM fud26_1_thread WHERE forum_id=4) t WHERE user_id=4;
ERROR:  Cannot insert a duplicate key into unique index fud26_1_read_i_tu
fcn_fudforums=# UPDATE fud26_1_read SET user_id=4, thread_id=t.id, msg_id=t.last_post_id, last_view=1085673943 FROM (SELECT id, last_post_id FROM fud26_1_thread WHERE forum_id=4) t WHERE user_id=4 AND thread_id=t.id;
UPDATE 6


Is this a change I should make in my users.inc.t?


darky
--
[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: 2.6.2 Find User link broken
Next Topic: 3 phantom visitors
Goto Forum:
  

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

Current Time: Thu Nov 07 14:26:10 GMT 2024

Total time taken to generate the page: 0.04485 seconds