Geeklog Forums

I have just finished installing GL1.4.1 & the forum plugin by Blaine (2.7_1.4.1).
Everything seems to be working correctly, except I cannot get the forums to show on any of the centerblocks. I have tried checking, unchecking, & rechecking the radio buttons for both enable centerblock & homepage only.
I checked the errorlog for the site & there doesn't appear to be any problems even with the lib_common.php debuggin on.
I placed lib-portalparts.php in /system along with lib-comment.php, lib-database.php, & almost all the other lib files.
./layout/theme/functions.php was replaced by the functions.php file in the tarball.
I appended the CSS information from the forum.css to the style.css
.codeblock , .quotemain, and the 3 div definitions .php, .html, and .css
I wasn't sure if the 3 divs needed to be added, but they do not appear to make any difference if removed.
any help would be appriciated.
thanks

If you did not have lib-portalparts.php in the correc place, you would not have been able to install the forum plugin.
Verify that you have
- Setup atleast one forum category and forum
- Users have access to the forum
- Added atleast 1 new topic to the forum
- Enabled the centerblock to show via the admin->forums admin settings
- User has access to the forums (assuming you are admin, then you definitely should)

---

Geeklog components by PortalParts -- www.portalparts.com

From the statistics page:
Categories: 4
Forums:17
Topics:3
Posts:3

From the settings page:
Do you need to be registered to view posts No
Do you need to be registered to create posts No
Enable Centerblock: Yes
Homepage Only: Yes
I can work with the forums through the menu link, it just refuses to appear as a centerblock on the homepage

Does the forum version that appears in the plugin edtitor listing show as version 2.7?

---

Geeklog components by PortalParts -- www.portalparts.com

The forum version shows 2.7 but the Geeklog version shows 1.4 not 1.4.1 like the others

OK, I tracked down the problem to retrieving the forum information from the database:
in functions.inc lines 1219-1224 it sets up the SQL:
SQL: SELECT a.id, a.forum, a.name, a.date, a.lastupdated, a.last_reply_rec, a.subject, a.comment, a.uid, a.name, a.pid, a.replies, a.views, b.forum_name FROM gl_forum_topic a LEFT JOIN gl_forum_forums b ON a.forum=b.forum_id WHERE pid=0 AND b.grp_id IN (2,4,7,11,5,13,12,10,8,1,14,3,17,6,9,19,18,20,21,15) AND b.no_newposts = 0 ORDER BY lastupdated DESC LIMIT 5

which dies as:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL: SELECT a.id, a.forum, a.name, a.date, a.lastupdated, a.last_reply_rec, a.su' at line 1

I am running the database on MySQL version 5 (unless godaddy is lying to me)

a test of:
SELECT a. * FROM gl_forum_topic a
results in :
#1051 - Unknown table 'a'

testing:
SELECT a. * FROM gl_forum_topic AS a
does work.

So that bit of uglyness seems to be fixed - going to have to go looking for other places that's listed

That's okay. The Geeklog version displayed is the minimum version that the plugin requires.

bye, Dirk