[kdepim-users] Problems with postgresql akonadi after upgrade

[Daniel Vrátil]

On Tuesday 15 of October 2013 09:44:26 Shridhar Daithankar wrote:
> On Monday, October 14, 2013 10:25:09 PM vectro at vectro.org wrote:
> > Hi all,
> > 
> > After upgrading to KDE 4.11.2, kmail no longer works. I can't update any
> > folders (including sending mail). The message I get from kmail is "Unable
> > to append item flags" (when sending) or "Unable to add item flags" (for
> > other operations). However, in all cases, Akonadi prints something like
> > this on the console:
> > 
> > Error during executing query "INSERT INTO PimItemFlagRelation (PimItem_id,
> > Flag_id) VALUES (:0, :1) RETURNING id" :  "ERROR:  syntax error at or near
> > "("
> > LINE 1: EXECUTE  (121352, 7)
> > 
> >                  ^
> > 
> > QPSQL: Unable to create query"
> > 
> > This seems similar to Bug 323856
> > https://bugs.kde.org/show_bug.cgi?id=323856, although it's hard to say
> > since that one hasn't been diagnosed.
> > 
> > The consequences of this are pretty grave, as it makes kmail nearly
> > useless for me. Any advice on how to proceed?
> 
> Only problem I had with postgresql backend was messages were not marked as
> read. For about 3-4 months, I had to live with all messages being unread.
> 
> And with akonadi 1.10.3, it got fixed. At no point, kmail was unable to
> send/receive email.
> 
> Is it feasible for you to upgrade akonadi?
> 
> I have kmail 4.11.2/akonadi 1.10.3/postgresql 9.3.1 happily working here on
> archlinux.

Note that Qt 4.8.5 is needed to work properly with the configuration above.

> 
> HTH.

-- 
Daniel Vrátil
KDE Desktop Team
Associate Software Engineer, Red Hat, Inc.

GPG Key: 0xC59D614F6F4AE348
Fingerprint: 4EC1 86E3 C54E 0B39 5FDD B5FB C59D 614F 6F4A E348
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20131015/7b7c3054/attachment.sig>
-------------- next part --------------
_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users