SQL bug in FUDforum 2.7.4 [message #32227] |
Thu, 15 June 2006 06:49 |
Serega
Messages: 26 Registered: June 2006
Karma: 0
|
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
|
|
|
Re: SQL bug in FUDforum 2.7.4 [message #32259 is a reply to message #32227] |
Sun, 18 June 2006 14:47 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
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
|
|
|
|