FUDforum: Bug Reports » SQL bug in FUDforum 2.7.4

Home » FUDforum Development » Bug Reports » SQL bug in FUDforum 2.7.4

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

SQL bug in FUDforum 2.7.4 [message #32227]

Thu, 15 June 2006 06:49

Serega

Messages: 26
Registered: June 2006

Karma:

Junior Member

System:
FUDforum 2.7.4
MySQL 4.1.12-log

Error:

Quote:

(/var/www/forum/data/index.php:76
/var/www/forum/data/index.php:1097
/var/www/forum/data/theme/default/selmsg.php:880
/var/www/forum/data/index.php:1191
) 1110: Column 'last_view' specified twice
Query: INSERT INTO fud26_read (user_id, thread_id, msg_id, last_view) SELECT 2, id, last_post_id, 1150353997 FROM fud26_thread WHERE forum_id=39 AND last_post_date > 1150301817 ON DUPLICATE KEY UPDATE last_view=VALUES(last_view), msg_id=VALUES(msg_id)
_GET: array ( 't' => 'selmsg', 'unread' => '1', 'S' => '52ecb5e4813b52860104918d29ad9fe4', 'frm_id' => '39', )
Server Version: 4.1.12-log
[Referring Page] http://forum.mediaring.ru/index.php?t=thread&unsub=1&frm_id=39& start=0&S=52ecb5e4813b52860104918d29ad9fe4&SQ=5a5d898952f2494f3eaf3 6092c11cdf0

I can see it, when click at "Show unreadable messages" (link at head of page) AND when forum is empty!

Try and fix.
Thanks!

[Updated on: Thu, 15 June 2006 07:26]

Report message to a moderator

[Message index]

		SQL bug in FUDforum 2.7.4 By: Serega on Thu, 15 June 2006 06:49
		Re: SQL bug in FUDforum 2.7.4 By: Ilia on Sun, 18 June 2006 14:47
		Re: SQL bug in FUDforum 2.7.4 By: Serega on Mon, 19 June 2006 04:01

Previous Topic:	No User CP tab - V2.7.5
Next Topic:	Messages not flagged read in tree-view with 2.7.5

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 10:22:35 GMT 2024

Total time taken to generate the page: 0.05938 seconds