There a number of columns that are set as NOT NULL and do
not have DEFAULT values. In cases like this then every query
should supply a value for that column when records are inserted
otherwise you will get failed queries in a PostgreSQL (and MySQL
in strict SQL mode).

You can either revamp the .install file to add defaults or make sure
that all inserts include values for fields that are NOT NULL.

See http://drupal.org/node/159330
http://drupal.org/node/159327
http://drupal.org/node/159329

The example in question I get an error for right away is for
importing an OpenX manager at admin/settings/openx-manager/import

Comments

brmassa’s picture

brmassa commented
Status: Active » Fixed

Jeff,

thanks. i knew that and despite the "duid" and "username"/"password", which were correctly wrong (i inserted them when i was testing a new feature i did but i forgot to remove them later)

feel free to reopen it in order to report similar bugs.

regards,

massa

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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