[geeklog-modules] Forum installation breaks easily when not using gl_ DB prefix
Tony Bibbs
tony at tonybibbs.com
Sat Feb 22 12:20:56 EST 2003
Well, can I recommend posts to geeklog-announce, geeklog-modules and a
notice on geeklog.net on releases? All three are perfect avenues for
this sort of communication. While I frequent geeklog.net, posts move
off the frontpage quickly. Had it been emailed to the lists I would
have caught this.
Is there any database changes? I already struggled through this to get
this far and I have a half-started conversion script. I just as well
assume stay on this outdated version until I get the conversion done.
Please tell me there are no DB changes ;-)
Oh, while you are adding that mod, can you allow it so links to
downloads can be provided instead of the actual file? Looking forward
to your update to that...
--Tony
Blaine Lang wrote:
> 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;";
>># --------------------------------------------------------
>>
>>?>
>>
>
> _______________________________________________
> 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 |
+-------------------+--------------------------------------------------+
More information about the geeklog-modules
mailing list