[Tickets #13796] Wrong SQL-Statement for turba_objects.object_category

[noreply at bugs.horde.org]

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

Ticket-URL: https://bugs.horde.org/ticket/13796
------------------------------------------------------------------------------
  Ticket           | 13796
  Erstellt Von     | cne at ruhrverband.de
  Zusammenfassung  | Wrong SQL-Statement for turba_objects.object_category
  Warteschlange    | Turba
  Version          | 4.2.4
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


cne at ruhrverband.de (2015-01-12 12:21) hat geschrieben:

If I use a local adressbook (localsql) and want to save/update/insert  
a category from horde,
there is a syntax-error at the postgresql-server because of this:

UPDATE turba_objects SET owner_id = 'IDblabla', [...], object_category  
= , [...] WHERE object_id = [..]

... it should be

UPDATE turba_objects SET owner_id = 'IDblabla', [...], object_category  
= '', [...] WHERE object_id = [..]

... or something like  object_category = 'my category', ...

This is my turba/config/attributes.php:

$attributes['category'] = array(
     'label' => _("Category"),
     'type' => 'category',
     'params' => array(),
     'required' => false
);

but .. 'type' => 'category' is not supported?

  * type - One of the following:
  *   - spacer            - header
  *   - description       - html
  *   - number            - int
  *   - intlist           - text
  *   - longtext          - countedtext
  *   - address           - file
  *   - boolean           - link
  *   - email             - emailconfirm
  *   - password          - passwordconfirm
  *   - enum              - multienum
  *   - radio             - set
  *   - date              - time
  *   - monthyear         - monthdayyear
  *   - colorpicker       - sorter
  *   - creditcard        - invalid
  *   - stringlist        - addresslink

pls. update default or expand supported types. I think it is useful to  
take the horde categories in the address book.