https://bugs.kde.org/show_bug.cgi?id=312460
Damir Islamov <da...@trefle.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |da...@trefle.ru
--- Comment #40 from Damir Islamov <da...@trefle.ru> ---
It seems that I found the reason at least for postgresql backend.
There are a lot of errors in akonadiserver.error log like
cannot execute "SELECT id, name FROM FlagTable WHERE ( name = ( :0 ) )" query
where :0 is '\SEEN'
Indeed
akonadi=> SELECT id, name FROM FlagTable WHERE ( name = ( '\SEEN' ) );
returns
bytea
ERROR: incorrect syntax for bytea type.
However '\\SEEN' works fine
akonadi=> SELECT id, name FROM FlagTable WHERE ( name = ( '\\SEEN' ) );
id | name
----+--------------
7 | \x5c5345454e
Attribute 'standard_conforming_strings' was set 'on' in postgresql.conf
I found a hack in changing type of FlagTable.name column to text type.
So there are tow way to fix the bug:
1. change type of the FlagTable.name column
2. Escape all '\' characters by additional backslash in queries.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs
