[geeklog-modules] Forum installation breaks easily when not using gl_ DB prefix
Blaine Lang
langmail at sympatico.ca
Sat Feb 22 11:52:59 EST 2003
You have an old version buddy ... Fixed 2 weeks ago.
You should download from geeklogplugins
http://sourceforge.net/project/showfiles.php?group_id=34911
I don't have access to update geeklog.net and wasn't going to add yet
another version.
I had posted updates on the site indicating this was where it should be
downloaded from or my site.
Currently working on a mod for the filemgmt plugin to allow admins to
replace files.
Blaine
----- Original Message -----
From: "Tony Bibbs" <tony at tonybibbs.com>
To: <geeklog-modules at lists.geeklog.net>
Sent: Saturday, February 22, 2003 11:48 AM
Subject: Re: [geeklog-modules] Forum installation breaks easily when not
using gl_ DB prefix
> Here is the sql file to fix the error.
>
> Tony Bibbs wrote:
> > This has probably already been reported but if you don't use the gl_
> > table prefix then the forum will not install for you. gl_ is clearly
> > hardcoded in mysql_install_2.0.php
> >
> > --Tony
> >
> > _______________________________________________
> > geeklog-modules mailing list
> > geeklog-modules at lists.geeklog.net
> > http://lists.geeklog.net/listinfo/geeklog-modules
>
>
> --
> +-------------------+--------------------------------------------------+
> |Tony Bibbs |[R]egardless of what you may think of our penal |
> |tony at tonybibbs.com |system, the fact is that every man in jail is one |
> | |less potential fisherman to clutter up your |
> | |favorite pool or pond. --Ed Zern |
>
> +-------------------+--------------------------------------------------+
>
----------------------------------------------------------------------------
----
> <?php
> # Geeklog Forum Plugin Version 2.0 SQL Install Code
> # Blaine Lang Feb 5/2002
> # Contact: geeklog at langfamily.ca
> #
>
> #
> # Table structure for table `gl_forum_categories`
> #
>
> $_SQL[] = "CREATE TABLE {$_TABLES['gf_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;";
> # --------------------------------------------------------
>
> #
> # Table structure for table `gl_forum_forums`
> #
>
> $_SQL[] = "CREATE TABLE {$_TABLES['gf_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;";
> # --------------------------------------------------------
>
> #
> # Table structure for table `gl_forum_topic`
> #
>
> $_SQL[] = "CREATE TABLE {$_TABLES['gf_topic']} (
> id mediumint(8) NOT NULL auto_increment,
> pid mediumint(8) NOT NULL default '0',
> cat int(3) 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',
> topicimg varchar(100) NOT NULL default '',
> sticky tinyint(1) NOT NULL default '0',
> test tinyint(1) NOT NULL default '1',
> moved tinyint(1) NOT NULL default '0',
> locked tinyint(1) NOT NULL default '0',
> forum int(3) NOT NULL default '0',
> PRIMARY KEY (id),
> KEY forum_idx (forum)
> ) TYPE=MyISAM;";
> # --------------------------------------------------------
>
> #
> # Table structure for table `gl_forum_log`
> #
>
> $_SQL[] = "CREATE TABLE {$_TABLES['gf_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;";
> # --------------------------------------------------------
>
> #
> # Table structure for table `gl_forum_moderators`
> #
>
> $_SQL[] = "CREATE TABLE {$_TABLES['gf_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;";
> # --------------------------------------------------------
>
> #
> # Table structure for table `gl_forum_settings`
> #
>
> $_SQL[] = "CREATE TABLE {$_TABLES['gf_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',
> img_width int(4) NOT NULL default '50',
> 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 '',
> 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;";
> # --------------------------------------------------------
>
> #
> # Table structure for table `gl_forum_userprefs`
> #
>
> $_SQL[] = "CREATE TABLE {$_TABLES['gf_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',
> 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;";
> # --------------------------------------------------------
>
> #
> # Table structure for table `gl_forum_watch`
> #
>
> $_SQL[] = "CREATE TABLE {$_TABLES['gf_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;";
> # --------------------------------------------------------
>
> # Table structure for table `gl_forum_banned_ip`
> #
> $_SQL[] = "CREATE TABLE {$_TABLES['gf_banned_ip']} (
> host_ip varchar(255) default NULL,
> KEY index1 (host_ip)
> ) TYPE=MyISAM;";
> # --------------------------------------------------------
>
> ?>
>
More information about the geeklog-modules
mailing list