FUDforum: Bug Reports » ERROR: Relation "f2" does not exist

Home » FUDforum Development » Bug Reports » ERROR: Relation "f2" does not exist

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

ERROR: Relation "f2" does not exist [message #16581]

Mon, 09 February 2004 10:25

Sebastian_T

Messages: 33
Registered: January 2004
Location: Warsaw, Poland

Karma: 0

Member

I'm not sure, what is it Wink

Some days ago we upgraded from FUD 2.3.8 to 2.6.0 stable. Today I saw an administrative option "Thread change" (? - don't know, how it's in English, I have Polish version of FUD Wink

) with 2 messages waiting. After clicking it shows an error:

Warning: pg_query(): Query failed: ERROR: Relation "f2" does not exist . in /usr/local/apache/htdocs/forum.blizniaki.net/index.php on line 141
(/usr/local/apache/htdocs/forum.blizniaki.net/index.php:141
/usr/local/apache/htdocs/forum.blizniaki.net/index.php:134
/usr/local/apache/htdocs/forum.blizniaki.net/theme/default/thr_exch.php:730
/usr/local/apache/htdocs/forum.blizniaki.net/index.php:1185
) : ERROR: Relation "f2" does not exist
Query: SELECT thx.*, m.subject, f1.name AS sf_name, f2.name AS df_name, u.alias FROM fud23_thr_exchange thx LEFT JOIN fud23_mod mm ON mm.forum_id=f2.id AND mm.user_id=4 INNER JOIN fud23_thread t ON thx.th=t.id INNER JOIN fud23_msg m ON t.root_msg_id=m.id INNER JOIN fud23_forum f1 ON t.forum_id=f1.id INNER JOIN fud23_forum f2 ON thx.frm=f2.id INNER JOIN fud23_users u ON thx.req_by=u.id WHERE 1=1
Server Version:
[Referring Page] http://forum.blizniaki.net/index.php?t=selmsg&unread=1&SQ=3470095c2 2bb0e32ef6b4bab50093a2e&frm_id=0&mark_page_read=1&mr=1

Any ideas? Smile