Mantis_Config_Table ERROR: Unknown column 'access'.

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
xanadu1215
Posts: 5
Joined: 22 Mar 2006, 21:27
Location: Wakefield, Ma
Contact:

Mantis_Config_Table ERROR: Unknown column 'access'.

Post by xanadu1215 »

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
indiix2
Posts: 1
Joined: 29 Aug 2006, 15:38

Did you resolve this, i have same issue

Post by indiix2 »

Was there any resolution to this. I have upgraded from v.19.2 on debian to 1.1 on the same system but i keep getting this error message.
Post Reply