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

Home » FUDforum Development » Bug Reports » SQL bug in FUDforum 2.7.4
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
SQL bug in FUDforum 2.7.4 [message #32227] Thu, 15 June 2006 02:49 Go to next message
Serega is currently offline  Serega   Russian Federation
Messages: 26
Registered: June 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 03:26]

Report message to a moderator

Re: SQL bug in FUDforum 2.7.4 [message #32259 is a reply to message #32227] Sun, 18 June 2006 10:47 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
This is a bug in the MySQL version that you are using, you need to disable MySQL 4.1 optimizations in the admin control panel.

FUDforum Core Developer
Re: SQL bug in FUDforum 2.7.4 [message #32287 is a reply to message #32259] Mon, 19 June 2006 00:01 Go to previous message
Serega is currently offline  Serega   Russian Federation
Messages: 26
Registered: June 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Yes, its working!
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Tue Sep 17 10:48:52 EDT 2019

Total time taken to generate the page: 0.00596 seconds