| Column 'last_view' specified twice [message #29994] |
Sat, 28 January 2006 06:49  |
 |
naudefj
Messages: 3771
Registered: December 2004
Karma: 28
|
Senior Member
Administrator
Core Developer |
|
|
I get quite a lot of these messages in my error log:
(/var/www/vhosts/mysite.com/httpdocs/forum/index.php:76
/var/www/vhosts/mysite.com/httpdocs/forum/index.php:1087
/var/www/vhosts/mysite.com/httpdocs/forum/theme/mytheme/markread.php:38
/var/www/vhosts/mysite.com/httpdocs/forum/index.php:1181
) 1110: Column 'last_view' specified twice
Query: INSERT INTO fud26_read (user_id, thread_id, msg_id, last_view) SELECT 79743, id, last_post_id, 1138197336 FROM fud26_thread WHERE forum_id=29 AND last_post_date > 1133002228 ON DUPLICATE KEY UPDATE last_view=VALUES(last_view), msg_id=VALUES(msg_id)
_GET: array ( 'SQ' => 'cd2bc7c246cb450f9306bc482d175913', 'rid' => '79743', 't' => 'markread', 'id' => '29', )
Server Version: 4.1.12
[Referring Page] http://www.mysite.com/forum/f/29/79743/
Best regards.
Frank
|
|
|
|
| Re: Column 'last_view' specified twice [message #30015 is a reply to message #29994] |
Sun, 29 January 2006 18:16  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I suspect this is a bug with the MySQL version that you have, the exact query you've pasted runs properly in MySQL 4.1.14 and there is definately nothing invalid about that query's structure. If you find yourself unable to upgrade, go into the forum's settings and disable MySQL 4.1 optimizations, this will avoid the code path that causes the error.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]