View Issue Details

IDProjectCategoryView StatusLast Update
0008667mantisbtinstallationpublic2007-12-20 01:37
Reporternomikon Assigned Tovboctor  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionduplicate 
PlatformIntelOSFreeBSDOS Version6.2
Product Version1.1.0rc3 
Summary0008667: Unable to create table in PostgreSQL because the integer default on boolean column
Description

I'm testing the latest 1.1.0rc3 version with PostgreSQL 8.1.10 and I get the same error while creating that table:

Schema CreateTableSQL ( mantis_bug_table )
...
ERROR: column "sticky" is of type boolean but default expression is of type integer HINT: You will need to rewrite or cast the expression.

Is there anyone having some success installing Mantis with PostgreSQL?

Regards, NK.

Steps To Reproduce

To make a new install of 1.1.0rc3 on a PostgreSQL database. The installer crash on "Schema CreateTableSQL ( mantis_bug_table )" with that known error message.

TagsNo tags attached.

Relationships

duplicate of 0008675 closedgrangeway Incorrect use of boolean in postgres 8.2.4 
has duplicate 0008551 closedgiallu MANTIS - problems with file upload 

Activities

There are no notes attached to this issue.