[kmail2] [Bug 312460] Kmail can not show correct number of unread mails

[Christian Mollekopf]

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.