[Tickets #9638] null value in column rule_id with postgresql

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/9638
------------------------------------------------------------------------------
  Ticket           | 9638
  Erstellt Von     | michael.menge at zdv.uni-tuebingen.de
  Zusammenfassung  | null value in column rule_id with postgresql
  Warteschlange    | Ingo
  Version          | Git master
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


michael.menge at zdv.uni-tuebingen.de (2011-03-09 09:24) hat geschrieben:

Database: postgresql 8.4.2

clicking on Ingo results in the following error

2011-03-09T10:09:54+01:00 DEBUG: 1. require() horde/ingo/index.php:13
2. Ingo_Storage->retrieve() horde/ingo/filters.php:17
3. Ingo_Storage_Sql->_retrieve() horde/ingo/lib/Storage.php:138
4. Ingo_Storage_Filters_Sql->init() horde/ingo/lib/Storage/Sql.php:87
5. Ingo_Storage_Filters_Sql->addRule()  
horde/ingo/lib/Storage/Filters/Sql.php:74
6. Horde::errorHandler() horde/ingo/lib/Storage/Filters/Sql.php:140
2011-03-09T10:09:54+01:00 DEBUG: HORDE [ingo] SQL  (0,0012s)
2011-03-09T10:09:54+01:00 DEBUG: HORDE [ingo] SQL PK and serial  
sequence (0,0892s)
           AND dep.refobjid = 'ingo_rules'::regclass [pid 23310 on  
line 773 of  
"/home/zrssk01/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2011-03-09T10:09:54+01:00 DEBUG: HORDE [ingo] SQL PK and custom  
sequence (0,0602s)
           'ingo_rules'::regclass AND cons.contype = 'p' AND def.adsrc ~*
2011-03-09T10:09:55+01:00 ERR: HORDE [ingo] SQL QUERY FAILED:  
SQLSTATE[23502]: Not null violation: 7 ERROR:  null value in column  
"rule_id" violates not-null constraint
         INSERT INTO ingo_rules (rule_id, rule_owner, rule_name, rule_action,
2011-03-09T10:09:55+01:00 DEBUG: HORDE [ingo] SQL
         INSERT INTO ingo_rules (rule_id, rule_owner, rule_name, rule_action,
2011-03-09T10:09:55+01:00 EMERG: HORDE [ingo] SQLSTATE[23502]: Not  
null violation: 7 ERROR:  null value in column "rule_id" violates  
not-null constraint [pid 23310 on line 146 of  
"/home/zrssk01/horde/ingo/lib/Storage/Filters/Sql.php"]