[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

Previous message: [geeklog-modules] Forum installation breaks easily when not using gl_ DB prefix
Next message: [geeklog-modules] Forum installation breaks easily when not using gl_ DB prefix
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

Previous message: [geeklog-modules] Forum installation breaks easily when not using gl_ DB prefix
Next message: [geeklog-modules] Forum installation breaks easily when not using gl_ DB prefix
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the geeklog-modules mailing list