1. I had to specify a search path
2. In the creation of the table mantis_user_pref_table I modified the column redirect_delay to be INTEGER instead of BOOLEAN since it is recast later anyway and never used as a boolean to begin with.
redirect_delay INTEGER DEFAULT 0 NOT NULL,
3. I commented out:
--ALTER TABLE public."mantis_user_pref_table" ALTER COLUMN redirect_delay TYPE INTEGER;
4. I commented out: --category_migrate; (WHAT IS THIS?)
5. I commented out: --DROP INDEX idx_config; (It gave me an error that the index did not exist, so I didn;t drop it)
Now I am having problems with boolean conversions. I tried to add a new administrator, and get the following error:
Code: Select all
Database query failed. Error received from database was #-1: ERROR: column "enabled" is of type boolean but expression is of type integer
LINE 3: enabled, access_level, login_count, cookie_string, ...
^
HINT: You will need to rewrite or cast the expression. for the query: INSERT INTO mantis_user_table
( username, email, password, date_created, last_visit,
enabled, access_level, login_count, cookie_string, realname )
VALUES
( '<user_name>', '<user_name@company.com>', '<password??>', '2008-07-24 12:36:34', '2008-07-24 12:36:34',
1, 90, 0, '<cookie_string>', '<user>')I also get the following error when trying to go to view_all_bugs page:
Code: Select all
Database query failed. Error received from database was #-1: ERROR: operator does not exist: boolean = integer
LINE 3: WHERE 1<>1 AND ( obsolete = 0 )
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. for the query: SELECT *
FROM mantis_project_version_table
WHERE 1<>1 AND ( obsolete = 0 )
ORDER BY date_order DESC