Author: stokes » Sat Nov 21, 2009 11:38 pm
Ok, good news and bad news. I got the old site updated and it works fine with the 2.0.23 version of PHPBB. I took the backup and restored it with big dump. When I go to the new site where I restored the DB, I get this error..
Could not obtain topics information
DEBUG MODE
SQL Error : 1054 Unknown column 't.topic_calendar_time' in 'where clause'
SELECT t.*, p.poster_id, p.post_username, p.enable_bbcode, p.enable_html, p.enable_smilies, u.username, pt.post_text, pt.bbcode_uid, 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 phpbb_topics AS t, phpbb_posts AS p, phpbb_posts_text AS pt, phpbb_users AS u, phpbb_posts AS lp, phpbb_users lu WHERE t.forum_id IN (1) AND p.post_id = t.topic_first_post_id AND pt.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 <1259388000>= 1258783200 AND t.topic_status <> 2 ORDER BY t.topic_calendar_time, t.topic_calendar_duration DESC, t.topic_last_post_id DESC
Line : 398
File : functions_calendar.php
It then thows me to the old site to log in. Any Ideas?