Geeklog Forums

Ok....feeling really ambitious about Forum Installs, I decided to go for a third. All went well...forum plugin showed up in the admin plugins on geeklog to install.....BUT
I get the following:

Mon Dec 6 17:13:44 2004 - Attempting to install the forum Plugin
Mon Dec 6 17:13:44 2004 - executing CREATE TABLE (
cat_order smallint(4) NOT NULL default '0',
cat_name varchar(255) NOT NULL default '',
cat_dscp text NOT NULL,
id int(2) NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;
Mon Dec 6 17:13:44 2004 - 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 '(
cat_order smallint(4) NOT NULL default '0',
cat_name varc. SQL in question:
Mon Dec 6 17:13:44 2004 - Error Creating table
Mon Dec 6 17:13:44 2004 - Attempting to unregister the Forum plugin from Geeklog
Mon Dec 6 17:13:44 2004 - Removing Table
Mon Dec 6 17:13:44 2004 - Removing Table
Mon Dec 6 17:13:44 2004 - Removing Table
Mon Dec 6 17:13:44 2004 - Removing Table
Mon Dec 6 17:13:44 2004 - Removing Table
Mon Dec 6 17:13:44 2004 - Removing Table
Mon Dec 6 17:13:44 2004 - Removing Table
Mon Dec 6 17:13:44 2004 - Removing Table
Mon Dec 6 17:13:44 2004 - Removing Table
Mon Dec 6 17:13:44 2004 - Removing Table
Mon Dec 6 17:13:44 2004 - Removing forum Admin Group
Mon Dec 6 17:13:44 2004 - Removing root users from admin of forum
Mon Dec 6 17:13:44 2004 - Removing forum.edit feature and rights to it
Mon Dec 6 17:13:44 2004 - DELETE FROM gl_access WHERE acc_ft_id =
Mon Dec 6 17:13:44 2004 - Removing forum.user feature and rights to it
Mon Dec 6 17:13:44 2004 - DELETE FROM gl_access WHERE acc_ft_id =
Mon Dec 6 17:13:45 2004 - Removing Forum - Block Definition
Mon Dec 6 17:13:45 2004 - ...success

Same problem whether I use my original file or my back up file.

Suggestions?

John

The actual complete SQL statement generating the error is not shown. It may have been stripped out. Place it inside a code block when you post.

Mon Dec 6 17:13:44 2004 - 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 '(
cat_order smallint(4) NOT NULL default '0',
cat_name varc. SQL in question:

---

Geeklog components by PortalParts -- www.portalparts.com

Well...my stupidity again. Guess I really should get some sleep...doing strange things.

For whatever reason, I placed a / at the end of line 83 in config.php (I dont know why..)

Took it out, and all is well....

Thanks again,
John


Proving once again, if it does not work...it's only my fault. Thanks for the Great Program.