[horde] SQL-based cache storage using Postgres

[Jan Schneider]

Zitat von "P.V.Anthony" <pvantony at singnet.com.sg>:

> Hi,
>
> After encountering errors with Postgresql 0.8.12, I upgraded to
> Postgresql 8.2.7.
>
> Still the errors are there when the presistan connection is not enabled.
>
> Decided to activate presistance connections. Hope that is ok.
>
> Now the problem is the SQL-based cache storage setting. After having
> setup cache to use the horde database, horde_cache, the following errors
> appear in horde.log.
>
> ------------- start -----------------------------
> Dec 06 21:30:07 HORDE [error] [imp] DB Error: unknown error: INSERT INTO
> horde_cache (cache_id, cache_timestamp, cache_expiration, cache_data)
> VALUES ('4e152dcfd584070ae5fc65c06f4654f5', 1228570207, 1231162207,
> 'a:4:{i:21;s:395:"O:8:"stdClass":15:{s:7ubject";s@ tesiting at 4:"from@
> 10:"message_id@') [nativecode=ERROR:  invalid byte sequence for encoding
> "UTF8": 0xe01320
> HINT:  This error can also happen if the byte sequence does not match
> the encoding expected by the server, which is controlled by
> "client_encoding".] [pid 23965 on line 226 of
> "/home/webmail/horde-webmail-1.2/lib/Horde/Cache/sql.php"]
> Dec 06 21:30:08 HORDE [error] [imp] DB Error: unknown error: INSERT INTO
> horde_cache (cache_id, cache_timestamp, cache_expiration, cache_data)
> VALUES ('4e152dcfd584070ae5fc65c06f4654f5', 1228570208, 1231162208,
> 'a:21:{i:21;s:888:"O:8:"stdClass":15:{s:7ubject";s@ tesiting at 4:"from@
> 10:"message_id@') [nativecode=ERROR:  invalid byte sequence for encoding
> "UTF8": 0xe01320
> HINT:  This error can also happen if the byte sequence does not match
> the encoding expected by the server, which is controlled by
> "client_encoding".] [pid 23965 on line 226 of
> "/home/webmail/horde-webmail-1.2/lib/Horde/Cache/sql.php"]
> -------------- end ------------------------------
>
> What am I doing wrong? Please advice.
>
> PosgresSQL version 8.2.7
> php 5.2.6
> horde Groupware Webmail 1.2
> Linux Kernel 2.6.23
> Apache 2.2.9
>
> P.V.Anthony
>
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>


Please create a ticket on http://bugs.horde.org/.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/