[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 

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

More information about the geeklog-modules mailing list