Hi Ilia,
I did not remove them from the new 2.5.2 forum those fields, these fields do not exist in 2.5.2.
I can not go to the admin part because I can not login, I have to register So is there some tool around that can do the consistency check??
Here is a sql dump from 2.5.2, note res and res_id are not there,
also note that the field: forum_id is 0 in most cases in the table _forum my id's start at 1 and go up, 0 does not exist (maybe this is the fault then??):
CREATE TABLE fud25_groups (
id int(10) unsigned NOT NULL auto_increment,
name char(255) NOT NULL default '',
inherit_id int(10) unsigned NOT NULL default '0',
joinmode enum('NONE','PUBLIC','MODERATED') NOT NULL default 'NONE',
forum_id int(10) unsigned NOT NULL default '0',
p_VISIBLE enum('I','Y','N') NOT NULL default 'N',
p_READ enum('I','Y','N') NOT NULL default 'N',
p_POST enum('I','Y','N') NOT NULL default 'N',
p_REPLY enum('I','Y','N') NOT NULL default 'N',
p_EDIT enum('I','Y','N') NOT NULL default 'N',
p_DEL enum('I','Y','N') NOT NULL default 'N',
p_STICKY enum('I','Y','N') NOT NULL default 'N',
p_POLL enum('I','Y','N') NOT NULL default 'N',
p_FILE enum('I','Y','N') NOT NULL default 'N',
p_VOTE enum('I','Y','N') NOT NULL default 'N',
p_RATE enum('I','Y','N') NOT NULL default 'N',
p_SPLIT enum('I','Y','N') NOT NULL default 'N',
p_LOCK enum('I','Y','N') NOT NULL default 'N',
p_MOVE enum('I','Y','N') NOT NULL default 'N',
p_SML enum('I','Y','N') NOT NULL default 'N',
p_IMG enum('I','Y','N') NOT NULL default 'N',
PRIMARY KEY (id),
KEY forum_id (forum_id),
KEY inherit_id (inherit_id)
) TYPE=MyISAM;
#
# Dumping data for table `fud25_groups`
#
INSERT INTO fud25_groups VALUES (3, 'TestForum', 0, 'NONE', 1, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
INSERT INTO fud25_groups VALUES (1, 'Global Anonymous Access', 0, 'NONE', 0, 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO fud25_groups VALUES (2, 'Global Registered Access', 0, 'NONE', 0, 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'Y');
And here the sql from 2.3.8 so you see res and res_id are in this version:
INSERT INTO fud25_groups (id, name, inherit_id, joinmode, res, res_id, p_VISIBLE, p_READ, p_POST, p_REPLY, p_EDIT, p_DEL, p_STICKY, p_POLL, p_FILE, p_VOTE, p_RATE, p_SPLIT, p_LOCK, p_MOVE, p_SML, p_IMG) VALUES ( '3', 'TestForum', '0', 'NONE', 'forum', '1', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
|