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

Blaine Lang langmail at sympatico.ca
Sat Feb 22 12:27:13 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 ]

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

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