NOT NULL columns and default values
jaydub - September 21, 2008 - 18:02
| Project: | OpenX Manager |
| Version: | 6.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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
#1
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
#2
Automatically closed -- issue fixed for two weeks with no activity.