[geeklog-modules] Forum installation breaks easily when not using gl_ DB prefix
Tony Bibbs
tony at tonybibbs.com
Sat Feb 22 13:49:40 EST 2003
Fine, I'll go ahead and do the appropriate upgrade but someone, for the
love of God, please post the updated code as an article on geeklog.net.
I'm a bit frustrated because migrating BB systems is tedious shit, I
finally get around to doing it with what I thought was the latest
version just to find out it isn't. Now I know I'm one of a few doing a
migration but I'm sure there are alot of current forum users using what
they *think* is the latest 2.0 version. Which begs another point,
please update the version number on the modules no matter how small a
change may seem. By looking at my version number and the one on the
sf.net download site I'd just assume I already had the latest (which
isn't true).
And to come full circle, glplugs has the same outdated stuff that gl.net
has. Which begs the question, can't we centralize all GL related stuff
to the gl.net site? I'd like to see us move all themes, plugins, etc to
gl.net. Users shouldn't have to go to 8 different places to find stuff.
I am mentioning this because if we are going to install the forum
modules on gl.net and have knuckles do a redesign that is more
marketable then we should look at pull all these other things together.
I don't want to step on toes but I'd rather centralize it to gl.net and
set up a few more GL admins on that site then to have a bunch of
disparate sites loosely affiliated with each other.
Sorry if I sound grumpy...don't take any of this personal.
--Tony
Blaine Lang wrote:
> Very well - your on your one. Yes there were database changes.
>
> Blaine
> ----- Original Message -----
> From: "Tony Bibbs" <tony at tonybibbs.com>
> To: <geeklog-modules at lists.geeklog.net>
> Sent: Saturday, February 22, 2003 12:20 PM
> Subject: Re: [geeklog-modules] Forum installation breaks easily when not
> using gl_ DB prefix
>
>
>
>>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 |
>>
>>+-------------------+--------------------------------------------------+
>>
>>_______________________________________________
>>geeklog-modules mailing list
>>geeklog-modules at lists.geeklog.net
>>http://lists.geeklog.net/listinfo/geeklog-modules
>
>
> _______________________________________________
> 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