Bug 300860

Summary:	can't clear cache - wrong capitalisation
Product:	[Frameworks and Libraries] Akonadi	Reporter:	kavol <kavol>
Component:	akonadiconsole	Assignee:	kdepim bugs <kdepim-bugs>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	NOR
Version:	unspecified
Target Milestone:	---
Platform:	unspecified
OS:	Linux
Latest Commit:	http://commits.kde.org/kdepim/e054e1f641fd1f425bd10ad99b89ea18162b9c72	Version Fixed In:	4.8.4

Description kavol 2012-05-30 09:39:48 UTC

I can't see some older messages in KMail and in Akonadiconsole browser. I've tried to use "Synchronise folder recursively" function but it did not help. Then I've tried to clear the cache, but this has failed.

Reproducible: Always

Steps to Reproduce:
1. run akonadiconsole
2. go to browser tab, rightclick on some collection
3. choose Clear Akonadi Cache
Actual Results:  
an error window appears, saying:

Table 'akonadi.pimitemtable' doesn't exist QMYSQL: Unable to execute query

Expected Results:  
no error, cache cleared, problems magically fixed

going to db browser/db console I can see there is "PimItemTable" not "pimitemtable"

I've also found that there were some changes to capitalisation in bug #220007 however it seems this wasn't fixed in all places ...

Comment 1 Allen Winter 2012-05-30 15:13:08 UTC

Git commit 81346a78bef038a4d38c5073e9d71e3b77777a9d by Allen Winter.
Committed on 30/05/2012 at 17:11.
Pushed by winterz into branch 'master'.

in clearCache(),
"DELETE FROM PimItemTable..." not
"DELETE FROM pimitemtable"
FIXED-IN: 4.8.4
MERGE: 4.8

M  +1    -1    akonadiconsole/browserwidget.cpp

http://commits.kde.org/kdepim/81346a78bef038a4d38c5073e9d71e3b77777a9d

Comment 2 Allen Winter 2012-05-30 15:13:45 UTC

Git commit e054e1f641fd1f425bd10ad99b89ea18162b9c72 by Allen Winter.
Committed on 30/05/2012 at 17:11.
Pushed by winterz into branch 'KDE/4.8'.

in clearCache(),
"DELETE FROM PimItemTable..." not
"DELETE FROM pimitemtable"
FIXED-IN: 4.8.4
MERGE: 4.8
(cherry picked from commit 81346a78bef038a4d38c5073e9d71e3b77777a9d)

M  +1    -1    akonadiconsole/browserwidget.cpp

http://commits.kde.org/kdepim/e054e1f641fd1f425bd10ad99b89ea18162b9c72