Bug 300860 - can't clear cache - wrong capitalisation
Summary: can't clear cache - wrong capitalisation
Status: RESOLVED FIXED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: akonadiconsole (show other bugs)
Version: unspecified
Platform: unspecified Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-30 09:39 UTC by kavol
Modified: 2012-05-30 15:13 UTC (History)
0 users

See Also:
Latest Commit: http://commits.kde.org/kdepim/e054e1f641fd1f425bd10ad99b89ea18162b9c72
Version Fixed In: 4.8.4

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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