I went thru the upgrades from 1.0.6 to 1.1.0 and that error appears after I upgrade to 1.1.0. I will stick with the 1.0.8 upgrade for now.

**Using PHP 5.1.6 and PostgreSQL 8.3.7 on CentOS 4.5

Are you using /admin/install.php to upgrade your database schema after you install the 1.1.x version?

Yes. I copied my config_inc.php from my mantis folder (v1.0.6) into the mantis-release folder (v1.1.0) and then ran mantis-release/admin/install.php, followed the instructions from http://www.mantisbt.org/manual/manual.installation.upgrading.php

Sorry, I had missed that you were using PgSQL earlier. There are known problems with handling Postgres in 1.1.x; these should all be fixed in the development releases for 1.2.0. If you could try test upgrading a copy of your database to 1.2.x, that would be greatly appreciated to help make sure we are not missing anything.

You can either clone the Git repository from http://git.mantisbt.org, or you can find the most recent nightly builds on http://www.mantisbt.org/builds/

Thanks

Okay. I installed 1.1.7 and then upgraded to the nightly build on 4/23/09. The only thing that didn't work right away, from the little that I've tested, is the "Manage Tags" link. I get the following error:

APPLICATION ERROR 0000401
Database query failed. Error received from database was #-1: ERROR: argument of WHERE must be type boolean, not type integer for the query: SELECT count(*)
FROM mantis_tag_table
WHERE 1.

I got it to work by making the following changes in manage_tags_page.php:
(changes are marked by the +)

Determine number of tags in tag table

$t_total_tag_count = 0;
$t_result = '';

+if ($t_where == '1'){

• $t_query = "SELECT count(*)
• FROM $t_tag_table";
  +}else{
  $tquery = "SELECT count(*)
  FROM $t_tag_table
  WHERE $t_where";
  +}

Retrive Tags from tag table

+if ($t_where == 1){

• $t_query = "SELECT *
• FROM $t_tag_table
• ORDER BY name";
  +}else{
  $t_query = "SELECT *
  FROM $t_tag_table
  WHERE " . $t_where .
  ' ORDER BY name';
  +}

Hope that helps.

I also had to up the memory_limit in the php.ini file. I have it set at 12M, up from 8M.

Marking this issue as resolved because the PgSQL issues in 1.1.x are not fixable. I've opened issue 0010446 to track the problem with manage_tags_page.php, which should be fixed shortly.