0010332: Unable to create mantis_bug_table / ERROR: column "sticky" is of type boolean but default expression is of type integer

View Issue Details [ Jump to Notes ] [ Wiki ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0010332

mantisbt

installation

public

2009-04-15 05:18

2011-08-05 02:20

Reporter

ncmichiel

Assigned To

atrol

Priority

normal

Severity

block

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

git trunk

Target Version

Fixed in Version

Summary

0010332: Unable to create mantis_bug_table / ERROR: column "sticky" is of type boolean but default expression is of type integer

Description

Checking Database Server Version
Running pgsql version PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)

BAD
CREATE TABLE mantis_bug_table ( id SERIAL, project_id INTEGER DEFAULT 0 NOT NULL, reporter_id INTEGER DEFAULT 0 NOT NULL, handler_id INTEGER DEFAULT 0 NOT NULL, duplicate_id INTEGER DEFAULT 0 NOT NULL, priority INT2 DEFAULT 30 NOT NULL, severity INT2 DEFAULT 50 NOT NULL, reproducibility INT2 DEFAULT 10 NOT NULL, status INT2 DEFAULT 10 NOT NULL, resolution INT2 DEFAULT 10 NOT NULL, projection INT2 DEFAULT 10 NOT NULL, category VARCHAR(64) DEFAULT '' NOT NULL, date_submitted TIMESTAMP DEFAULT '1970-01-01 00:00:01' NOT NULL, last_updated TIMESTAMP DEFAULT '1970-01-01 00:00:01' NOT NULL, eta INT2 DEFAULT 10 NOT NULL, bug_text_id INTEGER DEFAULT 0 NOT NULL, os VARCHAR(32) DEFAULT '' NOT NULL, os_build VARCHAR(32) DEFAULT '' NOT NULL, platform VARCHAR(32) DEFAULT '' NOT NULL, version VARCHAR(64) DEFAULT '' NOT NULL, fixed_in_version VARCHAR(64) DEFAULT '' NOT NULL, build VARCHAR(32) DEFAULT '' NOT NULL, profile_id INTEGER DEFAULT 0 NOT NULL, view_state INT2 DEFAULT 10 NOT NULL, summary VARCHAR(128) DEFAULT '' NOT NULL, sponsorship_total INTEGER DEFAULT 0 NOT NULL, sticky BOOLEAN DEFAULT 0 NOT NULL, PRIMARY KEY (id) )
ERROR: column "sticky" is of type boolean but default expression is of type integer HINT: You will need to rewrite or cast the expression.

Tags

No tags attached.

Attached Files

Relationships

Notes
(0021544) ncmichiel (reporter) 2009-04-15 05:18 edited on: 2009-04-15 05:28	This is a virgin installation. Related to 0008675 (do not know why that bug is closed ad the problem is still present) Also related to 0007616

(0021566) giallu (developer) 2009-04-15 17:25	many fixes for pgsql support went into the master (1.2) branch. are you able to test it as well?

(0021570) ncmichiel (reporter) 2009-04-16 02:56	I can fire it up on a virtual machine. This would be stuff I do in between work and home, whilst traveling on the train or bus. I don't have access to the Windows server any more, we went with MySQL for that particular case. I'll post any bugs I find in 1.2 trunk.

(0021644) ncmichiel (reporter) 2009-04-23 08:26	I just tested with GIT trunk on postgres. All seems to work fine on postgresql 8.3. I tested on a Mac using MacPorts. I can try to reproduce on Windows XP though I doubt that that will make any difference. All seems to work fine in 1.2.

Issue History
Date Modified	Username	Field	Change
2009-04-15 05:18	ncmichiel	New Issue
2009-04-15 05:18	ncmichiel	Note Added: 0021544
2009-04-15 05:23	ncmichiel	Note Edited: 0021544	View Revisions
2009-04-15 05:27	ncmichiel	Note Edited: 0021544	View Revisions
2009-04-15 05:28	ncmichiel	Note Edited: 0021544	View Revisions
2009-04-15 17:25	giallu	Note Added: 0021566
2009-04-16 02:56	ncmichiel	Note Added: 0021570
2009-04-23 08:26	ncmichiel	Note Added: 0021644
2010-08-22 14:24	atrol	Status	new => resolved
2010-08-22 14:24	atrol	Resolution	open => fixed
2010-08-22 14:24	atrol	Assigned To	=> atrol
2011-08-05 02:20	atrol	Status	resolved => closed

MantisBT 1.2.16dev master-1.2.x-8c2bd07 [^]

Time: 0.0757 seconds.
memory usage: 2,796 KB