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

Home » FUDforum Development » Bug Reports » 2.7.3: SQL-Error "Column 'last_view' specified twice"
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
2.7.3: SQL-Error "Column 'last_view' specified twice" [message #28823] Fri, 11 November 2005 22:14 Go to next message
Xonk is currently offline  Xonk   Germany
Messages: 67
Registered: March 2004
Karma: 0
Member
Hi,

since 2.7.3 I get the following error, when clicking the link for 'unread messages' in the topic-view.
When I click the link 'unread messages' on the homepage of the forum, there's no error.

Column 'last_view' specified twice
Query: INSERT INTO fud26_read (user_id, thread_id, msg_id, last_view) SELECT 122, id, last_post_id, 1131532584 FROM fud26_thread WHERE forum_id=7 AND last_post_date > 1118927419 ON DUPLICATE KEY UPDATE last_view=VALUES(last_view), msg_id=VALUES(msg_id)
_GET: array ( 'SQ' => 'f7517b1e3970136bbd6135b737507a6d', 'S' => '3008f6129438744495f5f1e0db5da6d2', 't' => 'markread', 'id' => '7', )
Server Version: 4.1.13-standard

[Updated on: Fri, 11 November 2005 22:14]

Report message to a moderator

Re: 2.7.3: SQL-Error "Column 'last_view' specified twice" [message #28831 is a reply to message #28823] Sat, 12 November 2005 05:33 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
I suspect this is MySQL related as it works fine on my MySQL 4.1.14

FUDforum Core Developer
Re: 2.7.3: SQL-Error "Column 'last_view' specified twice" [message #28835 is a reply to message #28831] Sat, 12 November 2005 10:19 Go to previous messageGo to next message
Xonk is currently offline  Xonk   Germany
Messages: 67
Registered: March 2004
Karma: 0
Member
Ilia wrote on Sat, 12 November 2005 00:33

I suspect this is MySQL related as it works fine on my MySQL 4.1.14

Hm ... that's bad, because I can't update the Server myself.
I didn't noticed this in 2.7.2; was on this function a modification made in 2.7.3? Then I could go back to 2.7.2 perhaps.
Re: 2.7.3: SQL-Error "Column 'last_view' specified twice" [message #28838 is a reply to message #28835] Sat, 12 November 2005 15:05 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
Yes, the change was introduced in version 2.7.3. You can keep on using 2.7.3, simply disable MySQL 4.1 optimization in your admin control panel.

FUDforum Core Developer
Re: 2.7.3: SQL-Error "Column 'last_view' specified twice" [message #28859 is a reply to message #28838] Sun, 13 November 2005 18:52 Go to previous message
Xonk is currently offline  Xonk   Germany
Messages: 67
Registered: March 2004
Karma: 0
Member
Great; changed the flag and no more error-messages now!
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: XML error
Next Topic: russian and russian - 1251 PDF bug
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 09 17:30:22 GMT 2024

Total time taken to generate the page: 0.02250 seconds