ERROR: operator does not exist: smallint = boolean

[janekska]

I am getting this error after migration:

App 555161 stderr: Completed 500 Internal Server Error in 936ms (ActiveRecord: 27.2ms)
App 555161 stderr:
App 555161 stderr: ActiveRecord::StatementInvalid (PG::UndefinedFunction: ERROR: operator does not exist: smallint = boolean
App 555161 stderr: LINE 1: ...) AND (members.user_id = 2 OR (projects.is_public = TRUE AND...

migration:
From Redmine 3.3.3 to 4.2.1 (MySql to MySql) by using common Redmine migration. Checked working.
Then from MySQL to Postgres - then this error.
Note: the same error was when tried another approach: first migrate from v.3.3.3. MySQL to Postgres then update Redmine.

What could be wrong?

brgds & looking forward

[AnatolyFromPerion]

Hello,
project.is_public probably was of type tinyint before migration.
This script cannot distinguish between tinyint column used as "boolean" and the same column used as a number.
Hence, the column is converted to smallest PG's numeric type, which is smallint

I think, custom SQL script should be run to convert project.is_public column from smallint to boolean