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:




and in the log:
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?

well I found most of the issues, first I found that somehow white spaces are being introduced into some of the core files and plugins that I uploaded, I'm not sure how yet because I'm using gftp to upload from a linux box. I fixed dozens of them but there has to be some I missed.

I also went through .sql files for forum and discovered that some changes and additions to tables, forum, topic, and I think one other so I made the changes manually I added in particular the last_post_rec column. I've been populating the topics and posts columns that were set at zero during creation and then set "$CONF_FORUM['debug'] = false;" in config.php of the forums. forum and messenger now works but if I set "$CONF_FORUM['debug'] = true;" I get errors like white space problem, there the "Warning: Cannot modify header information - headers already sent by (output started at /home/content/html/obfuscated/plugins/forum/debug.php:41) in /home/content/html/lib-common.php on line 6781"
both files do not have white space. nor do any of the include files called.

So I am at a loss....