303147 - [PostgreSQL] Submitting a bug in the UNCONFIRMED state gives an error

Status: RESOLVED FIXED

(Bugzilla :: Database, defect)

Description

[Emmanuel Seyman]

When voting in activated and the UNCONFIRMED state is used, developers of a
product have a choice between the NEW and UNCONFIRMED states when submitting a bug.
Using PgSQL, submitting a bug in the UNCONFIRMED state gives:

DBD::Pg::st execute failed: ERREUR:  Une valeur NULL dans la colonne
«everconfirmed» viole la contrainte NOT NULL
 [for Statement "INSERT INTO bugs
(version,rep_platform,bug_severity,priority,op_sys,assigned_to,bug_status,bug_file_loc,short_desc,target_milestone,product_id,component_id,
reporter, delta_ts, estimated_time, remaining_time, deadline) VALUES
('other','PC','normal','P2','Linux','1','UNCONFIRMED','','totot','---','1','1',1,
'2005-08-02 23:28:43.600838+02', 0, 0, NULL)"] at Bugzilla/DB.pm line 81
	Bugzilla::DB::SendSQL('INSERT INTO bugs
(version,rep_platform,bug_severity,priority,...') called at
/var/www/html/bugzilla-2.20/post_bug.cgi line 386

Comment 1

[Frédéric Buclin]

I confirm the bug. I tested on pg-tip with a user account which has no privs.
This means that all users without canconfirm/editbugs privs cannot submit new bugs.

mkanat, this makes sense to fix this bug for 2.20rc2 or we will have a plenty of
dupes.

Comment 2

[Frédéric Buclin]

Attachment: patch, v1

everconfirmed should always be defined. Updating the schema to DEFAULT => '0'
is not a good idea as some products do not use votes; and then the bug is
confirmed by default.

Comment 3

[Max Kanat-Alexander]

Actually, Pg bugs are never blockers, since Pg support is "experimental" in 2.20.

However, I'll certainly still take it for 2.20rc2. :-)

Comment 4

[Max Kanat-Alexander]

Comment on attachment 191417 [details] [diff] [review]
patch, v1

OK, works, looks good to me. :-)

Comment 5

[Frédéric Buclin]

tip:

Checking in post_bug.cgi;
/cvsroot/mozilla/webtools/bugzilla/post_bug.cgi,v  <--  post_bug.cgi
new revision: 1.120; previous revision: 1.119
done


2.20rc1:

Checking in post_bug.cgi;
/cvsroot/mozilla/webtools/bugzilla/post_bug.cgi,v  <--  post_bug.cgi
new revision: 1.118.2.1; previous revision: 1.118
done