FUDforum: Bug Reports » 2.7.3: SQL-Error "Column 'last

Home » FUDforum Development » Bug Reports » 2.7.3: SQL-Error "Column 'last_view' specified twice"

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

2.7.3: SQL-Error "Column 'last_view' specified twice" [message #28823]

Fri, 11 November 2005 22:14

Xonk

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

Ilia

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

Report message to a moderator

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

Xonk

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.

Report message to a moderator