Hello Christian Naumer
On 2012-03-26 10:08, Christian Naumer wrote:
> After the update to 1.3.14 we get these errors in the sogo.log:
>
>
> Mar 26 10:00:51 sogod [1496]: <0x0x229d4b8[GCSFolderManager]>
> ERROR(-[GCSFolderManager folderAtPath:]): executing SQL failed: 'SELECT
> c_folder_id, c_path, c_location, c_quick_location, c_acl_location,
> c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2
> = 'sogo' AND c_path3 = 'Calendar\' AND c_path4 =
> '725B-4C31DB00-235-3C8963C0''
> 2012-03-26 10:00:51.987 sogod[1496] <0x0x37316a8[PostgreSQL72Channel]:
> connection=<0x0x34ea028[PGConnection]: connection=0x0x48a4140>>:
> message: WARNUNG: nicht standardkonforme Verwendung von \' in
> Zeichenkettenkonstante
> ZEILE 1: ...ath1 = 'Users' AND c_path2 = 'sogo' AND c_path3 = 'Calendar\...
> ^
> TIP: Verwenden Sie '', um Quotes in Zeichenketten zu schreiben, oder
> verwenden Sie die Syntax für Escape-Zeichenketten (E'...').
>
> Mar 26 10:00:51 sogod [1496]: <0x0x229d4b8[GCSFolderManager]>
> ERROR(-[GCSFolderManager performSQL:]): cannot execute
> SQL 'SELECT c_folder_id, c_path, c_location, c_quick_location,
> c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 =
> 'Users' AND c_path2 = 'sogo' AND c_path3 = 'Calendar\' AND c_path4 =
> '725B-4C31DB00-235-3C8963C0'':
> <PostgreSQL72Exception: 0x4b58f68> NAME:PostgreSQL72FatalError
> REASON:fatal pgsql error (channel=<0x0x37316a8[PostgreSQL72Channel]:
> connection=<0x0x34ea028[PGConnection]: connection=0x0x48a4140>>):
> FEHLER: Syntaxfehler bei »725«
> ZEILE 1: ...= 'sogo' AND c_path3 = 'Calendar\' AND c_path4 = '725B-4C31D...
>
>
> Mar 26 10:05:33 sogod [1498]: [ERROR] <0x0x3b78638[GSCBufferString]>
> json parser: Object value expected for key: Mail
> Mar 26 10:05:33 sogod [1498]: [ERROR] <0x0x3b78638[GSCBufferString]>
> original string is: {"Mail": {"SortingState": ["date", "0"],
> "ExpandedFolders": "[\\"\\/0\\", \\"\\/0\\/folderINBOX\\"]",
> "DragHandleVertical": "228"}, "Contacts": {"SubscribedFolders":
> ["cn:Contacts\\/C46CD3A9-3700-0001-9272-E050133A1FCB",
> "cn:Contacts\\/2DEE-4BFF7B80-A01-24228440",
> "cn:Contacts\\/20E2-4C528E80-1-3095AC00"]}, "0": {"SortingState":
< cut >
I have never seen backslashes in calendar or address book names.
Where do they come from?
They are responsible for your problems, as they escape the ' signs
following them in e.g. "AND c_path3 = 'Calendar\' AND c_path4 = "
So you loose necessary ones for the SQL syntax to function.
Kind regards,
Christian Mack
--
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
--
[email protected]
https://inverse.ca/sogo/lists
