[horde] Oci8 error after uptade

[Michael J Rubinsky]

Quoting Jan Schneider <jan at horde.org>:

> 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.


FWIW, I, too, saw this recently when I created a new install against  
an Oracle backend to test something else. I plan to look into it again  
when I have the time.

> -- 
> Jan Schneider
> The Horde Project
> http://www.horde.org/
>
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5751 bytes
Desc: S/MIME Signature
URL: <https://lists.horde.org/archives/horde/attachments/20160512/5b938d3e/attachment.bin>