I am just about complete an upgrade from 1.3.7 to 1.7.1, I'm having problems with the forum and messenger. The error I get is:
Text Formatted Code
An SQL error has occurred. Please see error.log for details. @ /home/content/03/6935003/html/obfuscated/system/databases/mysql.class.php line 260
array(3) {
["sql"]=>
string(243) "SELECT * FROM gl_forum_forums AS f LEFT JOIN gl_forum_topic AS t ON f.last_post_rec=t.id WHERE forum_cat='1' AND grp_id IN (2,31,4,7,19,18,16,17,28,29,30,15,11,5,13,12,32,33,22,10,8,1,21,14,3,26,6,9,27) AND is_hidden=0 ORDER BY forum_order ASC"
["ignore_errors"]=>
int(0)
["result"]=>
bool(false)
}
Fri 05 Nov 2010 05:51:13 MST - 1054: Unknown column 'f.last_post_rec' in 'on clause'. SQL in question: SELECT * FROM gl_forum_forums AS f LEFT JOIN gl_forum_topic AS t ON f.last_post_rec=t.id WHERE forum_cat='1' AND grp_id IN (2,31,4,7,19,18,16,17,28,29,30,15,11,5,13,12,32,33,22,10,8,1,21,14,3,26,6,9,27) AND is_hidden=0 ORDER BY forum_order ASC
I also followed inst found here http://www.geeklog.net/forum/viewtopic.php?showtopic=90991 with no luck, any suggestions?