[ansel] MDB2 Error: null value violates not-null constraint

[Nikolaus Rath]

Jan Schneider <jan at horde.org> writes:
> Zitat von Nikolaus Rath <Nikolaus at rath.org>:
>
>> 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