Welcome to Geeklog, Anonymous Saturday, August 31 2024 @ 11:03 pm EDT
Geeklog Forums
sql problem?
Status: offline
Bloggins
Forum User
Newbie
Registered: 08/13/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:
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?
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 260array(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?
8
10
Quote
Status: offline
Bloggins
Forum User
Newbie
Registered: 08/13/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....
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 Frown](https://www.geeklog.net/forum/image_set/pixel.gif)
9
8
Quote
All times are EDT. The time is now 11:03 pm.
- 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