[Akonadi] [Bug 305543] "Paramter count mismatch" during akonadi start-up due to broken SQL query

Maciej Mrozowski reavertm at gmail.com
Wed Nov 27 00:59:51 GMT 2013


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

--- Comment #5 from Maciej Mrozowski <reavertm at gmail.com> ---
Btw, it seems related code is below:

void FetchHelper::updateItemAccessTime()
{
  Transaction transaction( mConnection->storageBackend() );
  QueryBuilder qb( PimItem::tableName(), QueryBuilder::Update );
  qb.setColumnValue( PimItem::atimeColumn(), QDateTime::currentDateTime() );
  ItemQueryHelper::scopeToQuery( mScope, mConnection, qb );

  if ( !qb.exec() )
    qWarning() << "Unable to update item access time";
  else
    transaction.commit();
}

>From quick look it's fine. But sorry for silly question, but how is it possible
that it generates "WHERE ( CollectionPimItemRelation.Collection_id = :1 AND (
CollectionPimItemRelation.PimItem_id = PimItemTable.id ) )" ?
Thanks to "scopeToQuery"?
(if so, way to go.. no wonder nobody is brave enough to write proper no-SQL
backend for akonadi cache yet if it's so difficult to follow what exactly is
going on now...)

-- 
You are receiving this mail because:
You are the assignee for the bug.



More information about the Kdepim-bugs mailing list