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

gmarus’s picture

Thanks 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.

gmarus’s picture

Status: Active » Fixed

fix committed to HEAD, 5.x-dev and 6.x-dev

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.