[Phpgroupware-developers] Error with email and Exchange Public Folders

[Jean-Eric Cuendet]

Hi,
I have a big SQL error when accessing the main email page since I set
"Cache data wherever possible".
The file is 550Kb long... so if someone is interested, please ask.
Thanks
-jec

The error is like that:

Database error: Invalid SQL: insert into phpgw_preferences
(preference_owner,preference_value) values
('4','a:9:{s:6:"common";a:13:{s:9:"maxmatchs";s:2:"15";s:5:"theme";s:7:"
default";s:9:"tz_offset";N;s:10:"dateformat";s:5:"d-m-Y";s:10:"timeforma
t";s:2:"24";s:12:"template_set";s:9:"idsociety";s:13:"navbar_format";s:1
4:"icons_and_text";s:15:"timezone_offset";s:1:"1";s:7:"country";s:2:"CH"
;s:17:"show_currentusers";s:4:"True";s:11:"default_app";s:8:"calendar";s
:8:"currency";s:3:"CHF";s:4:"lang";s:2:"en";}s:8:"calendar";a:9:{s:10:"w
eekstarts";s:6:"Monday";s:13:"workdaystarts";i:9;s:11:"workdayends";i:17
;s:15:"defaultcalendar";s:4:"year";s:13:"defaultfilter";s:3:"all";s:21:"
mainscreen_showevents";s:4:"True";s:8:"interval";i:60;s:13:"weekdaystart
s";s:6:"Monday";s:14:"display_status";s:4:"True";}s:11:"addressbook";a:4
:{s:7:"company";s:16:"addressbook_True";s:8:"lastname";s:16:"addressbook
_True";s:9:"firstname";s:16:"addressbook_True";s:16:"default_category";N
;}s:5:"notes";a:2:{s:10:"notes_font";s:34:"Verdana,Arial,Helvetica,sans-
serif";s:15:"notes_font

<... snip - snip...>

{s:11:"folder_long";s:5:"Tasks";s:12:"folder_short";s:5:"Tasks";}i:2873;
a:2:{s:11:"folder_long";s:5:"Trash";s:12:"folder_short";s:5:"Trash";}i:2
874;a:2:{s:11:"folder_long";s:9:"\Infected";s:12:"folder_short";s:9:"\In
fected";}}s:20:"match_cached_account";a:2:{s:24:"mailsvr_account_usernam
e";s:3:"jec";s:15:"mailsvr_callstr";s:26:"{mailsrv.linkvest.com:143}";}}
s:12:"portal_order";a:4:{i:0;i:5;i:1;i:15;i:2;i:11;i:3;i:9;}s:12:"squirr
elmail";a:8:{s:19:"mainscreen_showmail";s:4:"True";s:10:"highlight0";s:3
9:"Administrator,4444aa,Administrator,from";s:13:"move_to_trash";s:4:"tr
ue";s:12:"trash_folder";s:5:"Trash";s:12:"move_to_sent";s:4:"true";s:11:
"sent_folder";s:4:"Sent";s:12:"unseennotify";N;s:10:"unseentype";N;}}')
PostgreSQL Error: 1 (ERROR: parser: parse error at or near "s" )

File: /opt/phpgroupware/phpgwapi/inc/class.preferences.inc.php
Line: 191

Session halted.

----------------------------------------------------------
Jean-Eric Cuendet
Linkvest SA
Av des Baumettes 19, 1020 Renens Switzerland
Tel +41 21 632 9043  Fax +41 21 632 9090
E-mail: address@hidden
http://www.linkvest.com
----------------------------------------------------------