Re: SQL errors running akonadi fsck/vacuum

On Wednesday, March 20, 2019 3:38:32 AM AKDT Daniel Vrátil wrote:
> Hi Joshua,
> 
> On Tuesday, March 19, 2019 5:42:22 PM CET Joshua J. Kugler wrote:
> > I'm trying to run akonadi fsck and vacuum, and am seeing a lot of these in
> > the output:
> > 
> > Found duplicates 1429184580.R736.hosanna
> > org.kde.pim.akonadiserver: DATABASE ERROR:
> > org.kde.pim.akonadiserver:   Error code: "1064"
> > org.kde.pim.akonadiserver:   DB error:  "You have an error in your SQL
> > syntax; check the manual that corresponds to your MySQL server version for
> > the right syntax to use near ') AND PartTable.storage = 1 )' at line 1"
> > org.kde.pim.akonadiserver:   Error text: "You have an error in your SQL
> > syntax; check the manual that corresponds to your MySQL server version for
> > the right syntax to use near ') AND PartTable.storage = 1 )' at line 1
> > QMYSQL: Unable to execute query"
> > org.kde.pim.akonadiserver:   Query: "SELECT PartTable.id,
> > PartTable.pimItemId, PartTable.partTypeId, PartTable.data,
> > PartTable.datasize, PartTable.version, PartTable.storage FROM PartTable
> > WHERE ( PartTable.pimItemId IN (  ) AND PartTable.storage = :0 )"
> 
> 		                 ^
>                                         This here looks like the problem
> 
> Would you mind opening a bug report on bugs.kde.org and attaching this log
> output?
> 
> Thanks,
> Dan

Yes. If I see it again, I will. I ran the fsck again...and didn't see it, so I 
will keep my eyes open. :)

j

-- 
Joshua J. Kugler -- Fairbanks, AK
Blogs: http://jjncj.com/blog/ (Family) -- http://joshuakugler.com (Geek)
Philippians 2:9-11