[mantisbt-commits] [mantisbt/mantisbt] ba71cf: Fix PostgreSQL error when adding project/subprojec...

  Branch: refs/heads/master-1.2.x
  Home:   https://github.com/mantisbt/mantisbt
  Commit: ba71cf962a3ee27fb62ea4cc79b827601901165b
      https://github.com/mantisbt/mantisbt/commit/ba71cf962a3ee27fb62ea4cc79b827601901165b
  Author: Damien Regad <damien.regad@...>
  Date:   2012-06-27 (Wed, 27 Jun 2012)

  Changed paths:
    M core/project_api.php
    M core/project_hierarchy_api.php

  Log Message:
  -----------
  Fix PostgreSQL error when adding project/subproject

Release 1.2.11 (see commit b8d4b5039598248d0b0c78619450c51d4dc98df2 and
issue #14288) introduced a regression preventing the user from creating
a new project or adding a subproject.

The error is caused by columns mantis_project_table.inherit_global and
mantis_project_hierarchy_table.inherit_parent, which are defined as
unsigned int in schema.php, but treated as boolean in the code. This is
a problem with PostgreSQL due to strict type checking, but not on MySQL
as type cast is done automatically.

This commit is a workaround for the problem (sending an int to the DB
instead of a bool if using PostgreSQL), as fixing the root cause would
require a schema change which is not possible in 1.2.x.

Fixes #14385