[geeklog-modules] Forum installation breaks easily when not using gl_ DB prefix

Blaine Lang langmail at sympatico.ca
Sat Feb 22 15:50:23 EST 2003 

One should always breath before posting ....  ok .. so I've waited an hour
now...
>> for the love of God, please post the updated code as an article on
geeklog.net
Done - See http://www.geeklog.net/article.php?story=20030207110049368

Was posted on Feb 08th right after it was first uploaded. Within the first
few days there was a furry of activity in this thread and I was replying to
all questions. I noted the issue I had in the archive and that that everyone
should download from geeklogplugins.

The archive had been distributed to about 5 download sites within the first
day and I was not going to be updating or tracking all of them. I was
posting updates in this article on geeklog.net for those site admin's to
monitor and keeping my site and geeklogplugins updated.

Nuff said .... btw, I have some great canadian cheese for that Iowa Wine

----- Original Message -----
From: "Tony Bibbs" <tony at tonybibbs.com>
To: <geeklog-modules at lists.geeklog.net>
Sent: Saturday, February 22, 2003 1:49 PM
Subject: Re: [geeklog-modules] Forum installation breaks easily when not
using gl_ DB prefix


> 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                  |
>
> +-------------------+--------------------------------------------------+
>
> _______________________________________________
> geeklog-modules mailing list
> geeklog-modules at lists.geeklog.net
> http://lists.geeklog.net/listinfo/geeklog-modules

More information about the geeklog-modules mailing list