https://www.icyphoenix.com/viewtopic.php?f=35&t=6824&p=46895#p46895
-----------------------------------
BIG BOSS
Wed 30 Dec, 2009 18:37

SQL Error : 1054 Unknown Column 'p.post_text' In 'field List'
-----------------------------------
Strange thing happening after upgrading from 1.2.0.27 to 1.3.0.53, it seems to be working fine in IE8, but when opening the site with FF 3.5.6 it gives this error:

Error general
Could not obtain topics information

DEBUG MODE

SQL Error : 1054 Unknown column 'p.post_text' in 'field list'

SELECT t.*, p.poster_id, p.post_username, p.post_text, p.enable_bbcode, p.enable_html, p.enable_smilies, u.username, u.user_active, u.user_color, lp.poster_id AS lp_poster_id, lu.username AS lp_username, lp.post_username AS lp_post_username, lp.post_time AS lp_post_time FROM ip_topics AS t, ip_posts AS p, ip_users AS u, ip_posts AS lp, ip_users lu WHERE t.forum_id IN (1, 3, 4, 5, 6, 7, 12) AND p.post_id = t.topic_first_post_id AND u.user_id = p.poster_id AND lp.post_id = t.topic_last_post_id AND lu.user_id = lp.poster_id AND t.topic_calendar_time < 1262671200 AND (t.topic_calendar_time + t.topic_calendar_duration) >= 1262066400 AND t.topic_status <> 2 ORDER BY t.topic_calendar_time, t.topic_calendar_duration DESC, t.topic_last_post_id DESC

Line : 408
File : functions_calendar.php

Any help will be greatly appreciated.


