Opened 22 months ago

Closed 22 months ago

#1488027 closed Bugs (worksforme)

pgsql error in contactgroup_id constraint violation not null

Reported by: sak Owned by:
Priority: 5 Milestone: 0.6-beta
Component: Addressbook Version: 0.5.3
Severity: normal Keywords: pgsql contactgroup_id violation not null
Cc:

Description

this is the error I get when creating a new contact group in 0.5.3:

[Sun Aug 07 22:04:07 2011] [error] [client 190.16.148.57] MDB2 Error: null value violates not-null constraint (-29): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_pgsql_77a6479707dc5fa1002705f0a9435969f64d48853 (NULL, '315')]
[Native message: ERROR: null value in column "contactgroup_id" violates not-null constraint]

note that in pgsql you do *not* pass NULL if you want the DB to use the automatic id (ie. use the sequence)

Change History (1)

comment:1 Changed 22 months ago by alec

  • Milestone changed from later to 0.6-beta
  • Resolution set to worksforme
  • Status changed from new to closed

Enable sql_debug and check the real queries. The query for group create should look diffrent. Works for me. Try to disable all plugins. Try with svn-trunk version.

Note: See TracTickets for help on using tickets.