Hello,
I've migrated MantisBT version 2.20.0 to MantisBT 2.24.2 with a modification of database.
My old server with 2.20.0 is with MariaDB
I migrated the databse with pgloader to PostGreSQL(no errror) in the server hosted MantisBT 2.24.2
When i try to access site, i've got the following message :
APPLICATION ERROR #401
Database query failed. Error received from database was #-1: ERROR: invalid input syntax for integer: "TRUE" for the query: SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=$1 ORDER BY priority DESC.
Maybe there is an incompatibility in one of my table ?
MantisBT 2.24.2 - APPLICATION ERROR #401
Moderators: Developer, Contributor
Re: MantisBT 2.24.2 - APPLICATION ERROR #401
I suppose this migration does not generate exactly the same database schema that is generated when installing a new Mantis on PostGreSQL from scratch.
I would create a second installation from scratch and compare the types of the fields in mantis_plugin_table
Re: MantisBT 2.24.2 - APPLICATION ERROR #401
Hello,
During migration bollean from mysSQL was transfored in numeric to PostGrel
So, update numeric with true or false is a little bit complex
I need to create a script to create intermediary tables, update data with <> 0 for bolean and rename table.
The problem was the same for 8 tables
Once done, all is ok
During migration bollean from mysSQL was transfored in numeric to PostGrel
So, update numeric with true or false is a little bit complex
I need to create a script to create intermediary tables, update data with <> 0 for bolean and rename table.
The problem was the same for 8 tables
Once done, all is ok