[ egroupware-Bugs-1433518 ] FelaMiMail cache SQL error on PostgreSQL

Bugs item #1433518, was opened at 2006-02-17 12:20
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=554338&aid=1433518&group_id=78745

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: felamimail
Group: 1.2 RC5, no more RC1-4 please !!!
Status: Open
Resolution: None
Priority: 5
Submitted By: Aleksander Adamowski (the_olo)
Assigned to: Lars Kneschke (lkneschke)
Summary: FelaMiMail cache SQL error on PostgreSQL

Initial Comment:
I’m using eGroupWare 1.2 RC6 with PostgreSQL 8.0.7 on
Fedora Core 4.

The users are authenticated in LDAP, but accounts and
contacts are stored in the SQL database.

I’ve discovered a problem in FelaMiMail’s cache module
(or possibly its database schema - a field is too short):

Database error: Invalid SQL: INSERT INTO
egw_felamimail_cache
(fmail_date,fmail_subject,fmail_sender_name,fmail_sender_address,fmail_to_name,fmail_to_address,fmail_size,fmail_attachments,fmail_accountid,fmail_hostname,fmail_foldername,fmail_accountname,fmail_uid)
VALUES (1079713146,’[ANNOUNCE] uniqueidentifier
datatype for 7.2.X’,‘Dmitry G. Mastrukov
=?koi8-r?Q?=E4=CD=C9=D4=D2=C9=CA_?=
=?koi8-r?Q?=E7=C5=CE=CE=C1=C4=D8=C5=D7=C9=DE_?=
=?koi8-r?Q?=ED=C1=D3=D4=D2=C0=CB=CF=D7?=’,‘dmitry@taurussoft.org’,‘psql-announce
mailing
list’,‘pgsql-announce@postgresql.org’,2792,‘false’,1422,‘localhost’,‘INBOX.Announce’,‘olomaillists’,123)
pgsql Error: -1 (ERROR: value too long for type
character varying(120))

File:
/var/www/html/egroupware/felamimail/inc/class.socaching.inc.php
Line: 66
Function: egw_db::insert / socaching::addToCache /
bocaching::addToCache / bofelamimail::updateCache /
bofelamimail::getHeaders / uifelamimail::viewMainScreen
/ ExecMethod()

Session halted.


You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=554338&aid=1433518&group_id=78745


This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642


eGroupWare-tracker mailing list
eGroupWare-tracker@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-tracker