Welcome to Geeklog Sunday, December 05 2021 @ 02:56 am EST

Geeklog Forums

Forum Plugin Installation Whoas!


Sand Man

Anonymous
I'm running Geeklog 1.3.9r2 (a fresh installation) on Aapche2, Mysql 4.1, PHP 4.3. I'm trying to install the forum plugin 2.3.2. When I install the plugin, it tells me the installation was successful; howerver, it does not add the forum menu under the Admins Only section and I also get an error message when I try to go to the forum: "An SQL error has occured. Please see error.log for details."

Here is what is in my error.log:

PHP Formatted Code

9:31:37 PM - Attempting to install the forum Plugin
1/13/2005 9:31:37 PM - executing CREATE TABLE gl_forum_categories (
  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;
1/13/2005 9:31:37 PM - executing CREATE TABLE gl_forum_forums (
  forum_order int(4) NOT NULL default '0',
  forum_name varchar(255) NOT NULL default '0',
  forum_dscp text NOT NULL,
  forum_id int(4) NOT NULL auto_increment,
  forum_cat int(3) NOT NULL default '0',
  grp_id mediumint(8) NOT NULL default '2',
  PRIMARY KEY  (forum_id),
  KEY forum_cat (forum_cat),
  KEY forum_id (forum_id)
) TYPE=MyISAM;
1/13/2005 9:31:37 PM - executing CREATE TABLE gl_forum_topic (
  id mediumint(8) NOT NULL auto_increment,
  forum int(3) NOT NULL default '0',
  pid mediumint(8) NOT NULL default '0',
  uid mediumint(8) NOT NULL default '0',
  name varchar(50) default NULL,
  date varchar(12) default NULL,
  lastupdated varchar(12) default NULL,
  email varchar(50) default NULL,
  website varchar(100) NOT NULL default '',
  subject varchar(100) NOT NULL default '',
  comment longtext,
  postmode varchar(10) NOT NULL default '',
  replies bigint(10) NOT NULL default '0',
  views bigint(10) NOT NULL default '0',
  ip varchar(255) default NULL,
  mood varchar(100) default 'indifferent',
  sticky tinyint(1) NOT NULL default '0',
  moved tinyint(1) NOT NULL default '0',
  locked tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY `forum_idx` (`forum`),
  KEY `idxtopicuid` (`uid`),
  KEY `idxtopicpid` (`pid`),
  KEY `idxdate` (`date`),
  KEY `idxlastdate` (`lastupdated`)
) TYPE=MyISAM;
1/13/2005 9:31:37 PM - executing CREATE TABLE gl_forum_log (
  uid mediumint(8) NOT NULL default '0',
  forum mediumint(3) NOT NULL default '0',
  topic mediumint(3) NOT NULL default '0',
  time varchar(40) NOT NULL default '0',
  KEY uid_forum (uid,forum),
  KEY uid_topic (uid,topic),
  KEY forum (forum)
) TYPE=MyISAM;
1/13/2005 9:31:37 PM - executing CREATE TABLE gl_forum_moderators (
  mod_id int(11) NOT NULL auto_increment,
  mod_username varchar(30) default NULL,
  mod_forum varchar(30) default NULL,
  mod_delete tinyint(1) NOT NULL default '0',
  mod_ban tinyint(1) NOT NULL default '0',
  mod_edit tinyint(1) NOT NULL default '0',
  mod_move tinyint(1) NOT NULL default '0',
  mod_stick tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (mod_id)
) TYPE=MyISAM;
1/13/2005 9:31:37 PM - executing CREATE TABLE gl_forum_settings (
  slogan varchar(255) NOT NULL default '',
  registrationrequired tinyint(1) unsigned NOT NULL default '0',
  registerpost tinyint(1) unsigned NOT NULL default '0',
  allowhtml tinyint(1) unsigned NOT NULL default '1',
  glfilter tinyint(1) unsigned NOT NULL default '0',
  censor tinyint(1) unsigned NOT NULL default '1',
  showmood tinyint(1) unsigned NOT NULL default '1',
  allowsmilies tinyint(1) unsigned NOT NULL default '1',
  allowavatar tinyint(1) unsigned NOT NULL default '1',
  allow_notify tinyint(1) unsigned NOT NULL default '1',
  showiframe tinyint(1) unsigned NOT NULL default '1',
  msgauto tinyint(1) NOT NULL default '1',
  xtrausersettings tinyint(1) unsigned NOT NULL default '0',
  viewtopicnumchars int(4) NOT NULL default '20',
  topicsperpage int(4) NOT NULL default '10',
  postsperpage int(4) NOT NULL default '10',
  imgset varchar(30) NOT NULL default '',
  cb_enable tinyint(1) NOT NULL default '0',
  cb_homepage tinyint(1) NOT NULL default '0',
  cb_where tinyint(1) NOT NULL default '0',
  level1 int(5) NOT NULL default '1',
  level2 int(5) NOT NULL default '15',
  level3 int(5) NOT NULL default '35',
  level4 int(5) NOT NULL default '70',
  level5 int(5) NOT NULL default '120',
  level1name varchar(40) NOT NULL default 'Newbie',
  level2name varchar(40) NOT NULL default 'Junior',
  level3name varchar(40) NOT NULL default 'Chatty',
  level4name varchar(40) NOT NULL default 'Regular Member',
  level5name varchar(40) NOT NULL default 'Active Member'
) TYPE=MyISAM;
1/13/2005 9:31:37 PM - executing CREATE TABLE gl_forum_userprefs (
  uid mediumint(8) NOT NULL default '0',
  topicsperpage int(3) NOT NULL default '5',
  postsperpage int(3) NOT NULL default '5',
  popularlimit int(3) NOT NULL default '10',
  messagesperpage int(3) NOT NULL default '20',
  searchlines int(3) NOT NULL default '20',
  viewanonposts tinyint(1) NOT NULL default '1',
  enablenotify tinyint(1) NOT NULL default '1',
  alwaysnotify tinyint(1) NOT NULL default '0',
  membersperpage int(3) NOT NULL default '20',
  showiframe tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;
1/13/2005 9:31:37 PM - executing CREATE TABLE gl_forum_watch (
  id mediumint(8) NOT NULL auto_increment,
  forum_id mediumint(8) NOT NULL default '0',
  topic_id mediumint(8) NOT NULL default '0',
  uid mediumint(8) NOT NULL default '0',
  date_added date NOT NULL default '0000-00-00',
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY forum_id (forum_id),
  KEY topic_id (topic_id)
) TYPE=MyISAM;
1/13/2005 9:31:37 PM - executing CREATE TABLE gl_forum_banned_ip (
  host_ip varchar(255) default NULL,
  KEY index1 (host_ip)
) TYPE=MyISAM;
1/13/2005 9:31:37 PM - executing CREATE TABLE gl_forum_userinfo (
  `uid` mediumint(8) NOT NULL default '0',
  `location` varchar(128) NOT NULL default '',
  `aim` varchar(128) NOT NULL default '',
  `icq` varchar(128) NOT NULL default '',
  `yim` varchar(128) NOT NULL default '',
  `msnm` varchar(128) NOT NULL default '',
  `interests` varchar(255) NOT NULL default '',
  `occupation` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`uid`)
) TYPE=MyISAM COMMENT='Forum Extra User Profile Information';
1/13/2005 9:31:37 PM - Success - Created  table
1/13/2005 9:31:37 PM - Inserting default data into gf_settings table
1/13/2005 9:31:37 PM - Success - inserting data into gf_settings table
1/13/2005 9:31:37 PM - Inserting default data into blocks table
1/13/2005 9:31:37 PM - Success - inserting data into blocks table
1/13/2005 9:31:37 PM - Attempting to create forum admin group
1/13/2005 9:31:37 PM - ...success
1/13/2005 9:31:37 PM - About to save group_id to vars table for use during uninstall
1/13/2005 9:31:37 PM - ...success
1/13/2005 9:31:37 PM - Adding forum.edit feature
1/13/2005 9:31:37 PM - Success
1/13/2005 9:31:37 PM - Adding forum.edit feature to admin group
1/13/2005 9:31:37 PM - Success
1/13/2005 9:31:37 PM - Adding forum.user feature
1/13/2005 9:31:37 PM - Success
1/13/2005 9:31:37 PM - Adding forum.user feature to admin group
1/13/2005 9:31:37 PM - Success
1/13/2005 9:31:37 PM - Attempting to give all users in Root group access to forum admin group
1/13/2005 9:31:37 PM - Registering forum plugin with Geeklog
1/13/2005 9:31:37 PM - Succesfully installed the forum Plugin!
1/13/2005 9:42:38 PM - 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 '' at line 1. SQL in question: SELECT * FROM  

 

Any help would be greatly appreciated.

Thanks,
Sand Man
 Quote

ted

Anonymous
Quote by Sand Man: I'm running Geeklog 1.3.9r2 (a fresh installation)
dunno about the other stuff, but why would you install an old version of Geeklog rather than 1.3.11, the latest and greatest version?
 Quote

Sand Man

Anonymous
Becasue I like the Axonz v3.4 Red theme and they do not make that for 1.3.10 or 1.3.11--or at least i haven't seen any for it.
 Quote

Status: offline

samstone

Forum User
Full Member
Registered: 29/09/02
Posts: 820
All you need is adding the missing files from another theme to your theme.
 Quote

All times are EST. The time is now 02:56 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