Posted on: 01/17/04 09:15am
By: karelj
I click on install in the admin section and I am told there is an error and to check my logs. here is the error from the log
Sat 17 Jan 2004 08:55:18 AM EST - Attempting to install the forum Plugin
Sat 17 Jan 2004 08:55:18 AM EST - 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;
Sat 17 Jan 2004 08:55:18 AM EST - 1064: You have an error in your SQL syntax near '(
cat_order smallint(4) NOT NULL default '0',
cat_name varchar(255) NOT NU' at line 1. SQL in question:
Sat 17 Jan 2004 08:55:18 AM EST - Error Creating table
Sat 17 Jan 2004 08:55:18 AM EST - Attempting to unregister the Forum plugin from Geeklog
Sat 17 Jan 2004 08:55:18 AM EST - Removing Table
Sat 17 Jan 2004 08:55:18 AM EST - Removing Table
Sat 17 Jan 2004 08:55:18 AM EST - Removing Table
Sat 17 Jan 2004 08:55:18 AM EST - Removing Table
Sat 17 Jan 2004 08:55:18 AM EST - Removing Table
Sat 17 Jan 2004 08:55:18 AM EST - Removing Table
Sat 17 Jan 2004 08:55:18 AM EST - Removing Table
Sat 17 Jan 2004 08:55:18 AM EST - Removing Table
Sat 17 Jan 2004 08:55:18 AM EST - Removing Table
Sat 17 Jan 2004 08:55:18 AM EST - Removing Table
Sat 17 Jan 2004 08:55:18 AM EST - Removing forum Admin Group
Sat 17 Jan 2004 08:55:18 AM EST - Removing root users from admin of forum
Sat 17 Jan 2004 08:55:18 AM EST - Removing forum.edit feature and rights to it
Sat 17 Jan 2004 08:55:18 AM EST - DELETE FROM gl_access WHERE acc_ft_id =
Sat 17 Jan 2004 08:55:18 AM EST - Removing forum.user feature and rights to it
Sat 17 Jan 2004 08:55:18 AM EST - DELETE FROM gl_access WHERE acc_ft_id =
Sat 17 Jan 2004 08:55:18 AM EST - Removing Forum - Block Definition
Sat 17 Jan 2004 08:55:18 AM EST - ...success
Re:Error attempting to install Forum
Posted on: 01/17/04 01:09pm
By: Blaine
It appears to be missing the tablename in the SQL "Create Table ... "
Any chance you modified the plugins/forum/config.php file?
What version is this and from where?
Re:Error attempting to install Forum
Posted on: 01/17/04 02:47pm
By: karelj
No.. I did not modify the file....but I will untar the original tarball again and copy a fresh config file over.
This is forum_2.2RC1_, grabbed it from the link provided here
Re:Error attempting to install Forum
Posted on: 01/17/04 03:14pm
By: karelj
Just reinstalled everything.. same error message as before...
Re:Error attempting to install Forum
Posted on: 01/17/04 04:57pm
By: Blaine
It's not reading the plugins config.php file and you may have the PHP errorlevel set such that you are not getting an error message about not being able to read it.
Verify that you have all the plugin files in the correct directories.
The plugins/forum/config.php is where the table names are defined. This file is read in from the install.php -- thats now in the public/admin/plugins/forum directory
Try adding this statement below to the plugin install.php file you are executing to enable full error reporting. Add it after the require_once statements
error_reporting(E_ALL);
Re:Error attempting to install Forum
Posted on: 01/17/04 05:37pm
By: karelj
I get the same error in the log files, but the install.php page now has the following sequence of errors...
Notice: Undefined index: gf_settings in /var/www/html/animal/geeklog/site/admin/plugins/forum/install.php on line 74
Notice: Undefined variable: retval in /var/www/html/animal/geeklog/site/lib-common.php on line 3295
Notice: Undefined variable: retval in /var/www/html/animal/geeklog/site/lib-common.php on line 3407
Re:Error attempting to install Forum
Posted on: 01/17/04 06:41pm
By: Blaine
I'd suggest you add some debugging lines to find out why $_TABLES['gf_categories'] and probally the other forum table names are not being picked up.
$_TABLES is a global array that stores the names for all the geeklog tables. In the plugin_install_forum() add a line to print this array out and to see if the forum tables are defined. If they are not then back track to find out why. The install.php reads in the plugins config.php at the top of the script.
Add this to print out the $_TABLES array after the config.php is read in and possibly inside the install_forum()
print_r($_TABLES);
This will echo out the complete array - there will be a number of records. Look for records that reference the tables as defined in the forum plugin config.php
This is a local config or setup issue as I've not changed the local archive on this site for months and there are no install issues with it.
Re:Error attempting to install Forum
Posted on: 01/18/04 01:43am
By: karelj
Okay.. hopefully I understood you correctly and I put the line in the correct place.
I put it in the install.php file right after
require_once('../../../lib-common.php');
require_once($_CONF['path'] . 'plugins/forum/config.php');
require_once($_CONF['path'] . 'plugins/forum/functions.inc');
error_reporting(E_ALL);
Here is the output..
Array ( [access] => gl_access [article_images] => gl_article_images [blocks] => gl_blocks [commentcodes] => gl_commentcodes [commentmodes] => gl_commentmodes [comments] => gl_comments [cookiecodes] => gl_cookiecodes [dateformats] => gl_dateformats [events] => gl_events [eventsubmission] => gl_eventsubmission [featurecodes] => gl_featurecodes [features] => gl_features [frontpagecodes] => gl_frontpagecodes [group_assignments] => gl_group_assignments [groups] => gl_groups [links] => gl_links [linksubmission] => gl_linksubmission [maillist] => gl_maillist [personal_events] => gl_personal_events [plugins] => gl_plugins [pollanswers] => gl_pollanswers [pollquestions] => gl_pollquestions [pollvoters] => gl_pollvoters [postmodes] => gl_postmodes [sessions] => gl_sessions [sortcodes] => gl_sortcodes [speedlimit] => gl_speedlimit [statuscodes] => gl_statuscodes [stories] => gl_stories [storysubmission] => gl_storysubmission [topics] => gl_topics [tzcodes] => gl_tzcodes [usercomment] => gl_usercomment [userindex] => gl_userindex [userinfo] => gl_userinfo [userprefs] => gl_userprefs [users] => gl_users [vars] => gl_vars [staticpage] => gl_staticpage [commentspeedlimit] => gl_commentspeedlimit [submitspeedlimit] => gl_submitspeedlimit [userevent] => gl_userevent [weather] => gl_weather [weather_cache] => gl_weather_cache [weather_forecast] => gl_weather_forecast [weather_us_states] => gl_weather_us_states [weather_scratch] => gl_weather_scratch [weather_user] => gl_weather_user )
Notice: Undefined index: gf_settings in /var/www/html/animal/geeklog/site/admin/plugins/forum/install.php on line 75
Could this be an issue with the setup of MySql,PhpMysql on my server???
The weather and static page plugins work... I dunno.. where am I messing up??