[kronolith] Fatal error after PHP update

[Michael Menge]

Hi,

I found the error:

Yast Online Update from SLES 9 overwrites all php modules, if there is a 
Update for PHP. By overiting the php-pear module the pear DB libs got 
somehow mixed up.


Michael Menge wrote:
> Michael Menge wrote:
>> Jan Schneider wrote:
>>> Zitat von Michael Menge <Michael.Menge at zdv.uni-tuebingen.de>:
>>>
>>>> hi,
>>>>
>>>> I am running Horde 3.1.1 and Kronolith 2.1.1 on a SLES-9
>>>>
>>>> At the moment i am recieving a Fatal error after every log in, not only
>>>> for First-user login.
>>>>
>>>> Fatal error: Call to a member function on a non-object in
>>>> /zdv-system/data/htdocs/horde-3.1.1_test/kronolith-h3-2.1.1/lib/Driver/sql.php 
>>>>
>>>> on line 291
>>>>
>>>> Some Infos to the History of the Problem
>>>>
>>>> I was running 3.1.1 and Kronolith 2.1 an suspressed the PHP Warning
>>>> from the First-Login-Bug by setting the Log-level to error.
>>>>
>>>> Then i updatet Kronolit to 2.1.1 all seemed fine until i updated for
>>>> php4-4.3.4-43.50 to php4-4.3.4-43.53 (the last versionnumbers are from
>>>> SUSE) after this i got the Fatal error.
>>>>
>>>> Patching the sql.php with the error, but then i don't seen any
>>>> calenders can't create any.
>>>
>>> Try a recent FRAMEWORK_3 snapshot of Kronolith.
>>>
>>> Jan.
>>>
>>
>> Same effect as if i patch the kronolithe 2.1.1
>>
>> Ich don't have any calendars, cant create any, and therfore dont see 
>> and can't create any events
>>
>> i used kronolith-FRAMEWORK_3-2006-05-08.tar.gz
>> the old events are still in kronolith_events on the postgress 
>> SQL-database running on the same server
>>
>>
> 
> 
> I found several entries in my horde logs
> 
> May 09 16:22:37 HORDE [error] [kronolith] DB Error: insufficient data 
> supplied: SELECT c.datatree_id, c.datatree_name FROM horde_datatree c
>  LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = 
> c.datatree_id WHERE c.group_uid = ? AND ((a1.attribute_name = ? AND 
> a1.attribut
> e_value = ?) OR (a1.attribute_name = ? AND a1.attribute_key = ? AND CASE 
> WHEN CAST(a1.attribute_value AS VARCHAR) ~ '^-\?[0-9]+$' THEN (CAS
> T(a1.attribute_value AS INTEGER) \& ?) <> 0 ELSE FALSE END) OR 
> (a1.attribute_name = ? AND CASE WHEN CAST(a1.attribute_value AS VARCHAR) 
> ~ '
> ^-\?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEGER) \& ?) <> 0 ELSE 
> FALSE END) OR (a1.attribute_name = ? AND CASE WHEN CAST(a1.attribute
> _value AS VARCHAR) ~ '^-\?[0-9]+$' THEN (CAST(a1.attribute_value AS 
> INTEGER) \& ?) <> 0 ELSE FALSE END) OR (a1.attribute_name = ? AND a1.at
> tribute_key IN (?) AND CASE WHEN CAST(a1.attribute_value AS VARCHAR) ~ 
> '^-\?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEGER) \& ?) <> 0 E
> LSE FALSE END))   GROUP BY c.datatree_id, c.datatree_name, 
> c.datatree_order ORDER BY c.datatree_order, c.datatree_name, 
> c.datatree_id [on l
> ine 1111 of 
> "/zdv-system/data/htdocs/horde-3.1.1_test/lib/Horde/DataTree/sql.php"]
> May 09 16:22:37 HORDE [error] [kronolith] DB Error: insufficient data 
> supplied: SELECT c.datatree_id, c.datatree_name FROM horde_datatree c
>  LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = 
> c.datatree_id WHERE c.group_uid = ? AND ((a1.attribute_name = ? AND 
> a1.attribut
> e_value = ?) OR (a1.attribute_name = ? AND a1.attribute_key = ? AND CASE 
> WHEN CAST(a1.attribute_value AS VARCHAR) ~ '^-\?[0-9]+$' THEN (CAS
> T(a1.attribute_value AS INTEGER) \& ?) <> 0 ELSE FALSE END) OR 
> (a1.attribute_name = ? AND CASE WHEN CAST(a1.attribute_value AS VARCHAR) 
> ~ '
> ^-\?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEGER) \& ?) <> 0 ELSE 
> FALSE END) OR (a1.attribute_name = ? AND CASE WHEN CAST(a1.attribute
> _value AS VARCHAR) ~ '^-\?[0-9]+$' THEN (CAST(a1.attribute_value AS 
> INTEGER) \& ?) <> 0 ELSE FALSE END) OR (a1.attribute_name = ? AND a1.at
> tribute_key IN (?) AND CASE WHEN CAST(a1.attribute_value AS VARCHAR) ~ 
> '^-\?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEGER) \& ?) <> 0 E
> LSE FALSE END))   GROUP BY c.datatree_id, c.datatree_name, 
> c.datatree_order ORDER BY c.datatree_order, c.datatree_name, 
> c.datatree_id [on l
> ine 727 of 
> "/zdv-system/data/htdocs/horde-3.1.1_test/kronolith-FRAMEWORK_3/lib/Kronolith.php"] 
> 
> 
> 


-- 
--------------------------------------------------------------------------------
M.Menge                                 Tel.: (49) 7071/29-70316
Universitaet Tuebingen                  Fax.: (49) 7071/29-5912
Zentrum fuer Datenverarbeitung          mail: menge at zdv.uni-tuebingen.de
Waechterstrasse 76
72074 Tuebingen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5287 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.horde.org/archives/kronolith/attachments/20060510/3134c4d8/smime.bin