Welcome to Geeklog Saturday, September 19 2020 @ 09:07 am EDT

Geeklog Forums

sql problem?


Status: offline

Bloggins

Forum User
Newbie
Registered: 13/08/05
Posts: 11
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:


PHP 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)
}


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?
 Quote

Status: offline

Bloggins

Forum User
Newbie
Registered: 13/08/05
Posts: 11
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.... Frown
 Quote

All times are EDT. The time is now 09:07 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content