6.0.0-alpha12
6/8/25

[#13796] Wrong SQL-Statement for turba_objects.object_category
Summary Wrong SQL-Statement for turba_objects.object_category
Queue Turba
Queue Version 4.2.4
Type Bug
State Duplicate
Priority 2. Medium
Owners
Requester cne (at) ruhrverband (dot) de
Created 01/12/2015 (3800 days ago)
Due
Updated 01/12/2015 (3800 days ago)
Assigned
Resolved 01/12/2015 (3800 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
01/12/2015 12:45:19 PM Jan Schneider Comment #2
State ⇒ Duplicate
Reply to this comment
01/12/2015 12:21:18 PM cne (at) ruhrverband (dot) de Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Wrong SQL-Statement for turba_objects.object_category
Queue ⇒ Turba
Milestone ⇒
Patch ⇒ No
Reply to this comment
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.

Saved Queries