FUDforum: Bug Reports » Error trying to mark messages read

Home » FUDforum Development » Bug Reports » Error trying to mark messages read

Show: Today's Messages :: Polls :: Message Navigator

Re: Error trying to mark messages read [message #18564 is a reply to message #18561]

Thu, 27 May 2004 17:19

darkness

Messages: 7
Registered: May 2004

Karma:

Junior Member

Ilia wrote on Thu, 27 May 2004 12:53

The sql errors inside usrinfo.php were due to a bug that I've just fixed, here is the patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=2800

The mark-read problem should be fixed by the following patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=2801

Apply those patches, rebuild the theme and the query failures should go away.

Patches applied. Now I get a new error when I perform the same procedure:

Warning: pg_query(): Query failed: ERROR: Cannot insert a duplicate key into unique index fud26_1_read_i_tu in /srv/www/forums.caliginous.net/root/index.php on line 141

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /srv/www/forums.caliginous.net/root/index.php on line 47

Last message in the SQL error log:

(/srv/www/forums.caliginous.net/root/index.php:141
/srv/www/forums.caliginous.net/root/index.php:1103
/srv/www/forums.caliginous.net/root/theme/default/markread.php:47
/srv/www/forums.caliginous.net/root/index.php:1183
) : ERROR: Cannot insert a duplicate key into unique index fud26_1_read_i_tu
Query: 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
Server Version:
[Referring Page] http://forums.caliginous.net/

darky
--

Report message to a moderator

[Message index]

		Error trying to mark messages read By: darkness on Thu, 27 May 2004 15:22
		Re: Error trying to mark messages read By: Ilia on Thu, 27 May 2004 15:52
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 16:10
		Re: Error trying to mark messages read By: Ilia on Thu, 27 May 2004 16:53
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 17:19
		Re: Error trying to mark messages read By: Ilia on Thu, 27 May 2004 17:29
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 17:35
		Re: Error trying to mark messages read By: Ilia on Thu, 27 May 2004 17:37
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 17:44
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 16:39
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 16:53

Previous Topic:	2.6.2 Find User link broken
Next Topic:	3 phantom visitors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 07 12:26:51 GMT 2024

Total time taken to generate the page: 0.07203 seconds