Re: MDB2 Error: null value violates not-null constraint
Nikolaus Rath <[email protected]> Sun, 28 Nov 2010 14:29:19 -0500
| Newsgroups | gmane.comp.horde.ansel |
|---|---|
| Message-ID | <[email protected]> |
Jan Schneider <[email protected]> writes: > Zitat von Nikolaus Rath <[email protected]>: > >> Hello, >> >> I am using Ansel 1.1+debian0-1 with Horde 3.3.6+debian0-2 on PostgreSQL. >> I created the Ansel tables using scripts/sql/ansel.pgsql.sql.gz. >> >> When I try to upload an image to a gallery, I get the following error: >> >> # There was a problem saving the photo: MDB2 Error: null value >> violates not-null constraint > > Have some ansel tables with the postfix _seq been created? If not, > your DB user doesn't have sufficient permission to create new tables. Yes, psql \d lists: List of relations Schema | Name | Type | Owner --------+---------------------------+----------+---------- public | ansel_faces | table | horde public | ansel_faces_index | table | horde public | ansel_galleries_tags | table | horde public | ansel_image_attributes | table | horde public | ansel_images | table | horde public | ansel_images_seq | sequence | horde public | ansel_images_tags | table | horde public | ansel_shares | table | horde public | ansel_shares_groups | table | horde public | ansel_shares_seq | sequence | horde public | ansel_shares_users | table | horde public | ansel_tags | table | horde Best, -Nikolaus -- »Time flies like an arrow, fruit flies like a Banana.« PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C -- ansel mailing list - Join the hunt: http://horde.org/bounties/#ansel Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [email protected]