[horde] Unserialize errors.

[Chris Bowlby]

 Hi All,

  I've run into a major issue where some data in the database causes
nearly 100 unserialize errors to crop up, the applications that are
showing up within the list are kronolith, nag, mnemo and ingo. I have
tested the removal of all data in the database but even as soon as the
"default" data get's submitted to the database, and I logout/login again I
see the same group of errors (although a much smaller list).

 I've done some general tracing, and I believe that it's horde's
unserialize/serialize libs that are causing the problems, and the more
data (not even data related to the user who is logged in) that is in the
database, the more errors I see on the screen (I appologize for the
length but the differences in ther offset errors might help out some):

Notice: unserialize() failed at offset 9 of 38 bytes in
/usr/local/www/danac.org.ve/horde/kronolith/lib/base.php on line 77

Warning: Invalid argument supplied for foreach() in
/usr/local/www/danac.org.ve/horde/kronolith/lib/base.php on line 98

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 58 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 62 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 63 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 58 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 44 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 96 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 9 of 38 bytes in
/usr/local/www/danac.org.ve/horde/mnemo/lib/base.php on line 55

Warning: Invalid argument supplied for foreach() in
/usr/local/www/danac.org.ve/horde/mnemo/lib/base.php on line 66

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 58 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line268

Notice: unserialize() failed at offset 5of 59 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on li268
ce: unserialize() failed at offse 5 of 0 byte
sr/localwww/danac.orgve/hordelib/Seralize.ph on li 268

Notice: unsee() faied at offset 5 of 60 bytes in
/usr/local/www/anac.org.ve/horde/lib/Serializp on lne 268
Notic: unsrialze() failed at offsof 62 bytesin
/us/loca/www/anac.og.ve/hrde/liSialize.p on line 268

Notice: unserialize() failed at offset 5 of 63 bytes n
/usr/local/www/danac.org.ve/horib/Seralizepnine 268

Notice: unseralize( failedat offet 5 o 60 btes n
/usr/local/www/da.org.ve/hordib/Serialize.php on line 268

Notc: unserialize() failed at offset 5 of 59 bytes in
/usr/local/www/d.org.ve/hrde/lib/Serialize.php on line 268

Notice: unerialize() failed at offset 5 of 61 bytes in
//loca/www/anac.rg.ve/horde/li/alize.phpon lie 268
Notice unserilize( faild oset 5 of 61 bytes in
/usocal/www/danac.org.ve/horde/lib/Serialize.php on lie 268

Notice: unserialize() failed at offset of 1 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 28

Notice: unserialize() fai at ofset  of 61
/usr/loal/www/danac.og.ve/hrde/libSerializephp online 28

Notic: unserilizfailed  offset 5 of 60 bytes in
/usr/local/ww/anac.org.ve/horde/lib/Serialize.php on line 268

Notice: unseialize() faile at offset 5 of 59 bytes in
/usr/local/www/daac.org.ve/horde/lib/Serialize.php on line268

Notice: unserialize() failed a offset 5 of 60 bytes in
/usr/local/www/danacog.ve/horde/lib/Serilize.php on line 268

Notice: unserialize() failed at ofet 5 of 59 bytes in
/usr/local/www/danac.orghl/Serialze.phpon lie 268

otice: nserilize() ailed t offst 5 of61 byts in
/ucal/www/anac.rg.ve/hordib/Serialize.php on lie268

Notice: unserialize() failed at offset 5 of 60 bytes in
/usr/local/www/dc.og.ve/hrde/li/Serialize.php o line268

ot erialize) faild at ofset 5 of 58 btes in
/us/local/ww/da.org.ve/horde/lib/Srialize.php on line 268

Notice: unserialize( ailed at offset 5 of 61 bytes in
/uocl/www/danac.org.ve/horde/lib/Serializephp on line 268

Notice: unserialize() failedt offset 5 of 6 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.phpon line 268

Notice: unserialize() fail at ofset 5 of 61 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on ine 268

Notice: uerialize() failed at offset5 of 60 bytes in
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on l268ice:
unsrializ() failed at offset5 of 5 byte
u/local/www/danac.org.v/hord/lib/erialze.pp on ine 2
Notice: unserialize() filed at offset 5 of 60 bytes in
/usr/local/ww/anac.org.ve/horde/lib/Serializ.php on line 268

Notice: unserialize() faile at offset 5 of 59 bytes in
/usr/local/www/daac.org.ve/e/lib/erialie.phpon lin 268

otice:unserilize()failed at offset 5  bytes i
/usr/local/www/danac.orgvhorde/lib/Sralize.php on line 268

Notice: unserialize() failed at offset 5 of 44 bytesin
/usr/localdanacorg.v/horde/libSeriaize.pp i268

Notce: userialze() filed atoffset  of 61 bytesin
/ur/loca/www/g.ve/ord/Serialze.php on line 268

Notice unseriaize(i offset 5 of 61 bytes in
/usrlocal/ww/danc.org/horde/lib/Serialize.php on lne 268

Notice: unserialize() failed at offse 9 of 38 bytes in
/usr/loc/danac.rg.ve/orde/ag/lib/ase.ph on line 60

Waringalid argumnt supplied for foreach) in
/us/locw/dan.org.ve/horde/nag/lib/base.php on line 71

Notice: unserialize() failedat offset 5 of 59 bytes in
/ulocal/www/danac.r.ve/horde/lib/Serialize.php on line 268

Notice: unserialize() failed at ofet 5 of 8 bytes in
/usr/local/www/danac.org.v/orde/lib/Serialize.php on line 268

Notice: unserialize() failoffst 5 of 60s in
/us/localwww/danac.org.ve/hode/lib/Srialh on line 26

Notce: useriaize() ailedat oet 5 of 60 bytes in
/usr/local/wwwdanac.org.ve/horde/lib/Serialize.php on line 68

Notice: unseriali() failed at offset 5 of 59 bytes in
/usr/local/www/dan.org.ve/horde/lib/Serialize.php on line 268

ce: unseralize() failed at offset 5 of 59 bytes in
/usr/local/www/danac.org./horde/lib/Serialize.phpe 268

Noice: unsrial led t offst 5 of60 byts in
/ur/loca/www/dnac.or.ve/hode/lib/Seriaize.php n 8

ice:unserialize() failed at ofset 5 f 60 ys in
/usrlocal/www/dana.org.v/horde/ib/Seralize.hp online2tice
unserialize()iled at offset 5 of 62 bytes in
/sr/loal/ww/d.g.ve/hore/lib/Serializ.php o line 28tic: unsrialize()failed
at offset 5 of tes in /sr/locl/www/danac.org.ve/hrde/lib/eriephp on line
268otice: unserialize() failed at offset 5 of 60 bytes in
/usr/ocal/www/danac.org.ve/horde/lib/Serializpp on line 268

Notice: unserialize() failed at offset 5 of 59 bytes in
/usr/ocal/www/danac.org.ve/hde/lib/Serialize.php o ine 268

Notice: unserialize() failed at offset 5 of 61 bytes in
/usr/localwwdanac.org.ve/horde/lib/Serialize.php on lin 68

Notice: unserialize() failed at offset 5 of 61 bytes
/usr/local/www/danc.org.ve/horde/lib/Serialize.php on line 268
Ntice: unserialize() failed at offse5 of 61 bytes in
/usr/local/www/danac.or/horde/ib/Serialize.php on line 28

Notic: unae() faild at ff 61 ytes n
/us/loca/www/anac.rg.ve/orde/lb/Serialize.php n l268

Notice: unserialize() failedat off 60
b/usr/local/www/danac.org.ve/hordelib/Srialie.php n line 68

Notice: unserial failed at ffset  o59 bytes in
/usr/localwww/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unserialize()faid at offset 5 of 60 bytsin
/usr/local/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice:ulize) faild at offse 5 of59 bye
/usr/lcal/wwwdanacorg.vehorde/lib/erialie.php online 68

Notice: uns) fale 5 of 61 bytes in
/usr/loal/www/danac.org.ve/horde/lib/Serialize.php on line 268

Notice: unselize() ailed at offset 5 of 60 bytes
in/sr/local/www/danac.org.ve/horde/lib/Serialize.php on line 26ce:
unserializeiled at ffset  of 58bytes n
/us/lww/danac.orgve/hordelib/Srialie.phpon line268

Nticenserialize() failed at ffset 5 of 61 bytes in
/usr/local/www/aac.org.ve/horde/lib/Serialize.php on l 268

Notice: unserialize() failed atoffset 5 of 61 bytes in
/usr/loal/www/danac.org.ve/horde/lib/Sehp on ine 26

Notice:unserialize( faild at t 5 o 61 bytes in
/us/localwww/dc/horde/lib/Serialize.php26

Notie: unerialze() filed atoffset 5 of 60
bytesusr/loca/www/dnac.or.ve/hode/lib/Serializpn line Notice: unseriaize()
failed at offset 5 of 59 byte in
/usr/local/ww/anac.org.ve/horde/lib/Serilze.phn ine 268

Notice: unserialize() failed at offset 5 of 0 bytes in
/usrocal/www/danac.org.ve/horde/liSeriaie.php on line 268

Notice: unserialize() failed at offset 5 of 59 bytes in
sr/local/www/danac..ve/horde/lib/erializepp on line 268

Notice: unserialize() filed at offset 5 of 61 bytes in
/usr/cawww/danac.org.ve/horde/lib/Serialize.ph n line 268

Notice: unserialize() failed at offset 5 of 44 b in
/usr/lcal/ww/danac.org.ve/horde/lib/Serilze.php on line 268

Notice: unserialize() faied at offs of 61 bytes in
/usrocal/www/danac.org.ve/horelib/Serialize.php on line 268

Notice: nserialize() fa at offset  of 61 byt in
/usr/local/www/danac.org.ve/hordelb/Serialize.php on line 268


If I hose the database down and recreate an empty table set, login with
admin I get about 7 lines of errors (4 unserialize errors and 3 other
errors for kronolith, nag and mnemo - the filter one disappears).

Something that popped into my head, if horde is spitting out errors for
each row of data in the database, even when it's not owned by that user,
is horde just doing a select of ALL data out of the horde_prefs table and
then sitting in a for loop to determine database that is related to the
user?? would it not be more efficient, and less problematic to have it
select the data just related to the user? you've got a perfect key for it
:> the pref_uid value will do... :>

 Chris Bowlby,
 -----------------------------------------------------
 Manager of Information and Technology.
 excalibur at hub.org
 www.hub.org
 1-902-542-3657
 -----------------------------------------------------