[kmail2] [Bug 312460] Kmail can not show correct number of unread mails
Christian Mollekopf
mollekopf at kolabsys.com
Thu Sep 26 13:10:55 BST 2013
https://bugs.kde.org/show_bug.cgi?id=312460
--- Comment #47 from Christian Mollekopf <mollekopf at kolabsys.com> ---
(In reply to comment #40)
> 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.
I don't think this problem is related but it sounds like a genuine bug. Could
you please open a separate bugreport including your patch?
Thanks
--
You are receiving this mail because:
You are the assignee for the bug.
More information about the Kdepim-bugs
mailing list