[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

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 ]

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 |

+-------------------+--------------------------------------------------+

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