Hi guys,

I'm getting this error with the latest (-dev) version. I'm surprised that MySQL would not tell you of such violation, although you may not have tried with a fresh install.

query: INSERT INTO multivariate_mutation (nid, mutation_id, count) VALUES (8, 1, 0) in /usr/clients/www/drupal/sites/all/modules/multivariate/multivariate.node.inc on line 317.
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: null value in column &quot;success&quot; violates not-null constraint in /usr/clients/www/drupal/includes/database.pgsql.inc on line 187.
CommentFileSizeAuthor
multivariate-mutation_table-6.x.patch911 bytesAlexisWilke

Comments

soyarma’s picture

soyarma commented

I'll look to add this in. It's possible that if you're not running MySQL in strict mode it wouldn't have this error.

soyarma’s picture

soyarma commented
Status: Needs review » Closed (fixed)

This patch is committed into HEAD, and should be in the dev branch in a few hours.

I also altered the install file to set a default of 0 for the success column. I'm going to run through the db setup and see if any other columns should have default values.

AlexisWilke’s picture

AlexisWilke commented

Thank you. 8-)
Alexis