Closed (fixed)
Project:
Job Posting
Version:
6.x-1.10
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
14 Feb 2009 at 14:01 UTC
Updated:
3 Mar 2009 at 18:00 UTC
when installing on postgres, you get an error when the country table is being built, saying that you're violating a "NOT NULL" constraint for "cid".
The solution is to change job_posting.install.
change:
db_query("INSERT INTO {job_posting_country} (cid, name) VALUES
to
db_query("INSERT INTO {job_posting_country} (name) VALUES
and then remove the NULL on each country list, so:
(NULL, 'Afghanistan'),
becomes
('Afghanistan'),
I eyeballed it and this fix should work on MySQL as well.
Comments
Comment #1
gmarus commentedThanks for the bug report. Being unfamiliar with the nuances of postgres SQL I'm grateful for the input and will test your suggestions on mysql before rolling it into the next release.
Comment #2
gmarus commentedfix committed to HEAD, 5.x-dev and 6.x-dev