I've been getting a debug error: 1054 Unknown column 't.topi

[stevie_350z]

when I click on "recent topics" on the main page...

 

could not obtain main information.

 

DEBUG MODE

 

SQL Error : 1054 Unknown column 't.topic_first_post_id' in 'on clause'

 

SELECT t.*, p.poster_id, p.post_username AS last_poster_name, p.post_id, p.post_time, f.forum_name, f.forum_id, u.username AS last_poster, u.user_id AS last_poster_id, u2.username AS first_poster, u2.user_id AS first_poster_id, p2.post_username AS first_poster_name FROM phpbb_topics t, phpbb_posts p LEFT OUTER JOIN phpbb_posts p2 ON p2.post_id = t.topic_first_post_id LEFT OUTER JOIN phpbb_forums f ON p.forum_id = f.forum_id LEFT OUTER JOIN phpbb_users u ON p.poster_id = u.user_id LEFT OUTER JOIN phpbb_users u2 ON u2.user_id = t.topic_poster WHERE t.forum_id NOT IN (14,42,43,44,55,58) AND p.post_id = t.topic_last_post_id AND FROM_UNIXTIME(p.post_time,'%Y%m%d') - FROM_UNIXTIME(unix_timestamp(NOW()),'%Y%m%d') = 0 ORDER BY t.topic_last_post_id DESC LIMIT 0, 10

 

Line : 135

File : recent.php

[lomoto]

when I click on "recent topics" on the main page...

 

could not obtain main information.

 

DEBUG MODE

 

SQL Error : 1054 Unknown column 't.topic_first_post_id' in 'on clause'

 

SELECT t.*, p.poster_id, p.post_username AS last_poster_name, p.post_id, p.post_time, f.forum_name, f.forum_id, u.username AS last_poster, u.user_id AS last_poster_id, u2.username AS first_poster, u2.user_id AS first_poster_id, p2.post_username AS first_poster_name FROM phpbb_topics t, phpbb_posts p LEFT OUTER JOIN phpbb_posts p2 ON p2.post_id = t.topic_first_post_id LEFT OUTER JOIN phpbb_forums f ON p.forum_id = f.forum_id LEFT OUTER JOIN phpbb_users u ON p.poster_id = u.user_id LEFT OUTER JOIN phpbb_users u2 ON u2.user_id = t.topic_poster WHERE t.forum_id NOT IN (14,42,43,44,55,58) AND p.post_id = t.topic_last_post_id AND FROM_UNIXTIME(p.post_time,'%Y%m%d') - FROM_UNIXTIME(unix_timestamp(NOW()),'%Y%m%d') = 0 ORDER BY t.topic_last_post_id DESC LIMIT 0, 10

 

Line : 135

File : recent.php

 

Dont worry Stevie everyone does , A glich yet to be fixed

[Chesterfield]

 

Sadly no known cure just yet - or at least my knowledge of sql needs improving.

 

Its to do with the coding of the recent topics modification being done for sql4 and the board now residing on sql5, the modification has yet to be rewriten to work corectly with sql5. Once it is, the error will be fixed.

 

I suppose the simplest way is to remove the recent topics link full stop until a working one can be added - probably better to have no link rather than a link that doesnt work.

 

Sorry guys