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

Damir Islamov damir at trefle.ru
Tue Jul 9 16:49:53 BST 2013


https://bugs.kde.org/show_bug.cgi?id=312460

Damir Islamov <damir at trefle.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |damir at trefle.ru

--- Comment #40 from Damir Islamov <damir at 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.



More information about the Kdepim-bugs mailing list