Postgres - Error when creating an album
akc42 - December 7, 2008 - 09:14
| Project: | album photos |
| Version: | 6.x-1.4-beta2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
I get the following just after creating a new album.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "id" violates not-null constraint in /home/alan/dev/cf.ou/includes/database.pgsql.inc on line 138.
* user warning: query: INSERT INTO x_album_ac (id, nid, updateid) VALUES (null, 22, 1) in /home/alan/dev/cf.ou/sites/all/modules/photos_access/photos_access.module on line 208.
I presume this is some difference between the way that Mysql and Postgres handle automatic creation of id's in sequence - but not sure what.
#1
You need change count and fid columns - disable not null for it. After that all work's fine.