MantisBT 2.24.2 - APPLICATION ERROR #401

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
Arkady04
Posts: 3
Joined: 20 Aug 2020, 13:55

MantisBT 2.24.2 - APPLICATION ERROR #401

Post by Arkady04 »

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 ?
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: MantisBT 2.24.2 - APPLICATION ERROR #401

Post by atrol »

Arkady04 wrote: 20 Aug 2020, 14:03 I migrated the databse with pgloader to PostGreSQL(no errror)
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
Please use Search before posting and read the Manual
Arkady04
Posts: 3
Joined: 20 Aug 2020, 13:55

Re: MantisBT 2.24.2 - APPLICATION ERROR #401

Post by Arkady04 »

Hello,

During migration bollean from mysSQL was transfored in numeric to PostGrel

So, update numeric with true or false is a little bit complex :lol:

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 :)
Post Reply