This module cannot be run on as postgres as it generates errors:
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: null value in column "value" violates not-null constraint v /var/www/petrol/drupal/includes/database.pgsql.inc v vrstici 139.
query: UPDATE drupal_fillpdf_forms SET title = "pogodba_mpo_2012-fields.pdf", destination_path = "&qu
All of these errors are as a result of the fact that postgres, unlike mysql does not tolerate anything. This is a common error, i have reported 3 of this type this month alone.
A quick fix is to do this:
In table : drupal_fillpdf_fields
remove NOT NULL from field value
Real fix should be done in code/db config.
| Comment | File | Size | Author |
|---|---|---|---|
| #6 | fillpdf_1356998-D6.patch | 1.38 KB | liam morland |
| #1 | fillpdf_1356998.patch | 950 bytes | liam morland |
Comments
Comment #1
liam morlandPutr, there is no column "value" in the table "fillpdf_forms", so I think you have identified the wrong query as causing the problem. But I see an insert and an update query that could cause such an error. Please try the attached patch, which ensured that Fill PDF will store the empty string instead of null. Unfortunately, we have not yet switched to Postgres, so I can't do a full test.
Comment #2
wizonesolutionsWould like to see if this patch addressed Putr's issue or otherwise a patch that more conclusively solves this before committing. Leaving at needs review.
Comment #3
Putr commentedI'll test this tomorow on a vannilla install with postgres and report.
Comment #4
Putr commentedI've tested it on a vannilla install. The code also looks ok.
Liams patch fixes the problem.
thank you!
Comment #5
wizonesolutionsFine by me. Committed to 7.x-1.x. Does this need backport to 6.x?
Comment #6
liam morlandSame code, but formatted differently is in D6. Patch attached. Not tested since I have no D6 nor Postgres. Apply after #1430390: Coding standards: remove whitespace.
Comment #7
wizonesolutionsCommitted in cdadc4c. Thanks!