[horde] Oci8 error after uptade

[Jan Schneider]

Zitat von Ico Izquierdo <ico at cc.upv.es>:

> Hi all,
>
> I just updated all packages to Horde Groupware Webmail Edition 5.2.14.
> Data base backend is Oracle.
> The installation has only active imp, turba, ingo and kronolith  
> applications, and with the last one there is a problem.
> When I click on Calendar (Agenda in Spanish) the application shows a  
> red pop-up with an Exception (and side menu shows "Loading..." with  
> no action).
> Error message:
>
>    exception 'Horde_Db_Exception' with message 'QUERY FAILED:
>    ORA-01400: no se puede realizar una inserción NULL en
>    ("HORDEN"."RAMPAGE_TYPES"."TYPE_NAME") at offset 46 INSERT INTO
>    rampage_types (type_name) VALUES ('')' in
>    /usr/share/pear/Horde/Db/Adapter/Oci8.php:315
>    Stack trace:
>    #0 /usr/share/pear/Horde/Db/Adapter/Oci8.php(354):
>    Horde_Db_Adapter_Oci8->execute('INSERT INTO ram...', NULL, NULL)
>    #1
>    /var/www/vhosts/servidor.upv.es/horde/content/lib/Types/Manager.php(79):
>    Horde_Db_Adapter_Oci8->insert('INSERT INTO ram...')
>    #2
>    /var/www/vhosts/servidor.upv.es/horde/content/lib/Objects/Manager.php(75):
>    Content_Types_Manager->ensureTypes(NULL)
>    #3
>    /var/www/vhosts/servidor.upv.es/horde/content/lib/Tagger.php(251):
>    Content_Objects_Manager->exists('A8mzyMqs_CkXoK1...', NULL)
>    #4 /usr/share/pear/Horde/Core/Tagger.php(167):
>    Content_Tagger->getTags(Array)
>    #5
>     
> /var/www/vhosts/servidor.upv.es/horde/kronolith/lib/Calendar/Internal.php(174):
>    Horde_Core_Tagger->getTags('A8mzyMqs_CkXoK1...', 'calendar')
>    #6
>     
> /var/www/vhosts/servidor.upv.es/horde/kronolith/lib/Ajax/Application/Handler.php(45):
>    Kronolith_Calendar_Internal->toHash()
>    #7 [internal function]:
>    Kronolith_Ajax_Application_Handler->listCalendars()
>    #8 /usr/share/pear/Horde/Core/Ajax/Application.php(175):
>    call_user_func(Array)
>    #9 /var/www/vhosts/servidor.upv.es/horde/services/ajax.php(61):
>    Horde_Core_Ajax_Application->doAction()
>    #10 {main}
>    Next exception 'Content_Exception' with message 'QUERY FAILED:
>    ORA-01400: no se puede realizar una inserción NULL en
>    ("HORDEN"."RAMPAGE_TYPES"."TYPE_NAME") at offset 46 INSERT INTO
>    rampage_types (type_name) VALUES ('')' in
>    /horde/content/lib/Types/Manager.php:82
>    Stack trace:
>    #0
>    /var/www/vhosts/servidor.upv.es/horde/content/lib/Objects/Manager.php(75):
>    Content_Types_Manager->ensureTypes(NULL)
>    #1
>    /var/www/vhosts/servidor.upv.es/horde/content/lib/Tagger.php(251):
>    Content_Objects_Manager->exists('A8mzyMqs_CkXoK1...', NULL)
>    #2 /usr/share/pear/Horde/Core/Tagger.php(167):
>    Content_Tagger->getTags(Array)
>    #3
>     
> /var/www/vhosts/servidor.upv.es/horde/kronolith/lib/Calendar/Internal.php(174):
>    Horde_Core_Tagger->getTags('A8mzyMqs_CkXoK1...', 'calendar')
>    #4
>     
> /var/www/vhosts/servidor.upv.es/horde/kronolith/lib/Ajax/Application/Handler.php(45):
>    Kronolith_Calendar_Internal->toHash()
>    #5 [internal function]:
>    Kronolith_Ajax_Application_Handler->listCalendars()
>    #6 /usr/share/pear/Horde/Core/Ajax/Application.php(175):
>    call_user_func(Array)
>    #7 /var/www/vhosts/servidor.upv.es/horde/services/ajax.php(61):
>    Horde_Core_Ajax_Application->doAction()
>    #8 {main}
>
> Few minutes later, when I try another time the same action, it works ok.
> Could you tell me what is happening?

There is something going wrong already earlier in the code, namely in  
the constructor of Horde_Core_Tagger where $this->_type_ids is  
propagated. Either you have some broken values saved in your cache  
backend (check the kronolith.tagger.type_ids key), or the  
Content_Types_Manager class is returning incorrect (or incomplete)  
type ids.

-- 
Jan Schneider
The Horde Project
http://www.horde.org/