editgroups.cgi uses INSERT IGNORE to rederive user permissions from regexps. INSERT IGNORE is not ANSI SQL and Postgres bails out on it. Note: There is one more occurence in checksetup.pl, but since it's in the MySQL specific upgrade code which will never be used on any other DB than MySQL, we don't need to bother.
Yeah, it probably just needs to be changed to a SELECT/INSERT pair. That's what I did with another INSERT IGNORE in checksetup.
Status: NEW → ASSIGNED
Target Milestone: --- → Bugzilla 2.20
Comment on attachment 178181 [details] [diff] [review] V1 OK, this looks generally correct. That @present should really just be a $present, and you can use selectrow_array with the $sth, like $dbh->selectrow_array($sth, ...); It seems like there ought to be some way to re-write this whole block with something that uses the DB's regex operator... ah well.
Attachment #178181 - Flags: review?(mkanat) → review+
Checking in editgroups.cgi; /cvsroot/mozilla/webtools/bugzilla/editgroups.cgi,v <-- editgroups.cgi new revision: 1.51; previous revision: 1.50 done
Status: ASSIGNED → RESOLVED
Last Resolved: 14 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.