FUDforum: FUDforum Installation Issues » Will not show Category

Home » FUDforum » FUDforum Installation Issues » Will not show Category

Show: Today's Messages :: Polls :: Message Navigator

Re: Will not show Category [message #5315 is a reply to message #5314]

Tue, 27 August 2002 12:56

esm2002

Messages: 339
Registered: May 2002
Location: Atlanta Georgia

Karma:

Senior Member

Quote:

ALTER TABLE DROP hidden;
ALTER TABLE DROP hidden;
ALTER TABLE fud2_group_members ADD up_VISIBLE ENUM ('Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE fud2_groups CHANGE p_VIEW p_READ ENUM ('I', 'Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE fud2_group_members CHANGE up_VIEW up_READ ENUM ('Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE DROP style;
ALTER TABLE DROP creation_date;
UPDATE fud2_group_members SET user_id=2147483647 WHERE user_id=4294967295;
UPDATE fud2_group_cache SET user_id=2147483647 WHERE user_id=4294967295;
ALTER TABLE fud2_thread ADD INDEX(is_sticky,orderexpiry);
CREATE TABLE fud2_mlist ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, forum_id INT NOT NULL, name VARCHAR(255) NOT NULL, mlist_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'N', allow_frm_post ENUM('Y', 'N') NOT NULL DEFAULT 'N', frm_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'Y', allow_mlist_attch ENUM('Y', 'N') NOT NULL DEFAULT 'Y', allow_mlist_html ENUM('Y', 'N') NOT NULL DEFAULT 'N', complex_reply_match ENUM('Y', 'N') NOT NULL DEFAULT 'N', subject_regex_haystack TEXT, subject_regex_needle TEXT, body_regex_haystack TEXT, body_regex_needle TEXT, index(forum_id) ) ;
CREATE TABLE fud2_nntp ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, forum_id INT NOT NULL, nntp_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'N', allow_frm_post ENUM('Y', 'N') NOT NULL DEFAULT 'N', frm_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'Y', allow_nntp_attch ENUM('Y', 'N') NOT NULL DEFAULT 'Y', complex_reply_match ENUM('Y', 'N') NOT NULL DEFAULT 'N', server VARCHAR(255) NOT NULL, newsgroup VARCHAR(255) NOT NULL, port INT NOT NULL, timeout INT NOT NULL, auth ENUM('NONE', 'ORIGINAL', 'SIMPLE') NOT NULL DEFAULT 'NONE', login VARCHAR(255), pass VARCHAR(255), index(forum_id) ) ;

Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."

Report message to a moderator

[Message index]

		Will not show Category By: esm2002 on Mon, 12 August 2002 23:30
		Re: Will not show Category By: Ilia on Tue, 13 August 2002 13:37
		Re: Will not show Category By: esm2002 on Tue, 13 August 2002 19:23
		Re: Will not show Category By: Ilia on Tue, 13 August 2002 19:46
		Re: Will not show Category By: esm2002 on Thu, 15 August 2002 21:11
		Re: Will not show Category By: Ilia on Thu, 15 August 2002 21:42
		Re: Will not show Category By: esm2002 on Thu, 15 August 2002 22:57
		Re: Will not show Category By: Ilia on Thu, 15 August 2002 23:57
		Re: Will not show Category By: esm2002 on Fri, 16 August 2002 00:16
		Re: Will not show Category By: Ilia on Mon, 19 August 2002 02:53
		Re: Will not show Category By: esm2002 on Mon, 19 August 2002 11:32
		Re: Will not show Category By: Ilia on Mon, 19 August 2002 16:21
		Re: Will not show Category By: esm2002 on Tue, 20 August 2002 04:00
		Re: Will not show Category By: Ilia on Tue, 20 August 2002 12:23
		Re: Will not show Category By: esm2002 on Tue, 20 August 2002 21:41
		Re: Will not show Category By: esm2002 on Thu, 22 August 2002 16:01
		Re: Will not show Category By: Ilia on Thu, 22 August 2002 16:16
		Re: Will not show Category By: esm2002 on Thu, 22 August 2002 17:26
		Re: Will not show Category By: esm2002 on Mon, 26 August 2002 15:23
		Re: Will not show Category By: Ilia on Mon, 26 August 2002 15:46
		Re: Will not show Category By: esm2002 on Mon, 26 August 2002 17:03
		Re: Will not show Category By: Ilia on Tue, 27 August 2002 12:43
		Re: Will not show Category By: esm2002 on Tue, 27 August 2002 12:56
		Re: Will not show Category By: Ilia on Tue, 27 August 2002 13:13
		Re: Will not show Category By: esm2002 on Tue, 27 August 2002 13:39
		Re: Will not show Category By: Ilia on Tue, 27 August 2002 13:48
		Re: Will not show Category By: esm2002 on Tue, 27 August 2002 17:00
		Re: Will not show Category By: esm2002 on Wed, 28 August 2002 01:16
		Re: Will not show Category By: Ilia on Wed, 28 August 2002 03:21
		Re: Will not show Category By: esm2002 on Wed, 28 August 2002 11:57
		Re: Will not show Category By: Ilia on Wed, 28 August 2002 12:49
		Re: Will not show Category By: Ilia on Wed, 28 August 2002 14:49
		Re: Will not show Category By: esm2002 on Wed, 28 August 2002 16:07
		Re: Will not show Category By: Ilia on Wed, 28 August 2002 16:49
		Re: Will not show Category By: esm2002 on Wed, 28 August 2002 21:54
		Re: Will not show Category By: esm2002 on Wed, 16 October 2002 22:24
		Re: Will not show Category By: Ilia on Thu, 17 October 2002 21:31
		Re: Will not show Category By: esm2002 on Wed, 16 October 2002 02:07

Previous Topic:	Error msg
Next Topic:	Registering new users is very slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 11:15:33 GMT 2024

Total time taken to generate the page: 0.04352 seconds