[kronolith] Fatal error after PHP update

[Michael Menge]

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/20060509/725e56d1/smime.bin