Mantis_Config_Table ERROR: Unknown column 'access'.
Posted: 23 Mar 2006, 22:20
I've got this far in the upgrade.
But I now receive the error: ERROR: Unknown column 'access' in 'mantis_config_table'
I checked the table and that column is not present.
I deleted the table and rebuilt it with
CREATE TABLE mantis_config_table (
config_id VARCHAR(64) NOT NULL,
project_id INTEGER NOT NULL DEFAULT 0,
user_id INTEGER NOT NULL DEFAULT 0,
access_reqd INTEGER DEFAULT 0,
type INTEGER DEFAULT 90,
value TEXT NOT NULL,
PRIMARY KEY (config_id, project_id, user_id)
)TYPE=MyISAM;
ALTER TABLE mantis_config_table ADD INDEX idx_config (config_id);
along with
INSERT INTO mantis_config_table ( value, type, access_reqd, config_id, project_id, user_id ) VALUES ('51', 1, 90, 'database_version', 20, 0 );
I'm using Navicat (which is a great tool).
I can't seem to get around this problem though. Any suggestions?
Ver 1.0.1.
Right now I'm at 1.0.0rc5. I'd like to go to 1.0.1 though but I can't get the 'Upper Mng' go ahead until this question has been addressed.
Thanks
Stephanie Beach
But I now receive the error: ERROR: Unknown column 'access' in 'mantis_config_table'
I checked the table and that column is not present.
I deleted the table and rebuilt it with
CREATE TABLE mantis_config_table (
config_id VARCHAR(64) NOT NULL,
project_id INTEGER NOT NULL DEFAULT 0,
user_id INTEGER NOT NULL DEFAULT 0,
access_reqd INTEGER DEFAULT 0,
type INTEGER DEFAULT 90,
value TEXT NOT NULL,
PRIMARY KEY (config_id, project_id, user_id)
)TYPE=MyISAM;
ALTER TABLE mantis_config_table ADD INDEX idx_config (config_id);
along with
INSERT INTO mantis_config_table ( value, type, access_reqd, config_id, project_id, user_id ) VALUES ('51', 1, 90, 'database_version', 20, 0 );
I'm using Navicat (which is a great tool).
I can't seem to get around this problem though. Any suggestions?
Ver 1.0.1.
Right now I'm at 1.0.0rc5. I'd like to go to 1.0.1 though but I can't get the 'Upper Mng' go ahead until this question has been addressed.
Thanks
Stephanie Beach