nathand,

I was not able to reproduce your problem.
Did you exactly follow the steps described at:
http://www.mantisbt.org/docs/master-1.2.x/en/administration_guide.html#ADMIN.INSTALL.UPGRADE

Additional information listed below may also be useful:

• Exact version of PHP
• Relevant customizations (e.g. changes in config_inc.php, etc)
• Installed plugins or custom functions ?
• Was the MantisBT source code modified in any way ?

Postgresql support is known-broken in the 1.2.x releases - due to adodb.

We have replaced the db layer in our 2.x branches to allow us to fix support for postgres/mssql. For now, I would suggest staying on the working 1.2.10 release.

Paul

i have same problem with 1.2.15 but one solution
try :

create or replace function bool_to_smallint (boolean)
returns integer
strict
language sql as '
select case
when $1 then 1
else 0
end;
';

create cast (boolean as integer)
with function bool_to_smallint(boolean)
as implicit;

There were several cases of type mismatch (int vs boolean) in 1.2.x - these should now be fixed in master branch.

Please try to reproduce the problem using a nightly build, and feel free to reopen this issue if the error still occurs.