Page 1 of 1

SQL queries errors, Mantis 2.14 and PG 9.6

Posted: Jul 10, 2019 9:17 pm
by levithanh0209
We migrated from an old server running Mantis 1.19 and Postgres 8.5, to a new machine running Mantis 2.14 and Postgres 9.6. The MantisBT app is working, mostly. In certain areas we are running into trouble. One is the management of Custom Fields. When we click on update, an SQL error is raised, see code snippet below.

What catches my eye is the error text regarding a value of TRUE for an integer. However, the error message does not indicate which column is involved. Columns type, access_level_r, access_level_rw, length_min, length_max and filter_by are all integer.

I would greatly appreciate some advice/insight. Is this, for example, an isolated error or something due to the use of Postgres and therefore impacting many parts of the application.

NOTE: I see now that this type of thing has come up before. See issue 10742, I hope there are others in the community that can help me move this forward.

Code: Select all

Database query failed. Error received from database was #-1: ERROR: invalid input syntax for integer: "TRUE" for the query: 
UPDATE mantis_custom_field_table 
SET name=$1, type=$2, possible_values=$3, default_value=$4, valid_regexp=$5, access_level_r=$6, access_level_rw=$7, length_min=$8, length_max=$9, display_report=$10, display_update=$11, display_resolved=$12, display_closed=$13, require_report=$14, require_update=$15, require_resolved=$16, require_closed=$17, filter_by=$18 
WHERE id = $19.

Re: SQL queries errors, Mantis 2.14 and PG 9.6

Posted: Jul 15, 2019 6:36 am
by cas
Try updating to 2.21 and if the issue persists, re-open the existing bug.