Bug 172940

Summary:	Errors in statistics plugin
Product:	[Unmaintained] kopete	Reporter:	Stas Ashirov <stas.ashirov>
Component:	Statistics plugin	Assignee:	Kopete Developers <kopete-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal	CC:	bugs.kde.org, kojot350, sebastian.radish
Priority:	NOR
Version First Reported In:	0.60.1
Target Milestone:	---
Platform:	unspecified
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Stas Ashirov 2008-10-16 12:19:33 UTC

Version:           0.60.1 (using 4.1.2 (KDE 4.1.2), 4.1.2-2.fc9 Fedora)
Compiler:          gcc
OS:                Linux (i686) release 2.6.26.5-45.fc9.i686

$ cat ~/.xsession-errors | grep kopete
kopete(2892)/libkopete Kopete::PluginManager::loadPluginInternal: Unable to find a plugin named ' "" '!
kopete(2892)/kopete (statistics): error " " on query: "SELECT name FROM sqlite_master WHERE type='table'"
kopete(2892)/kopete (statistics): error " " on query: "CREATE TABLE contactstatus (id INTEGER PRIMARY KEY,metacontactid TEXT,status TEXT,datetimebegin INTEGER,datetimeend INTEGER);"
kopete(2892)/kopete (statistics): error " " on query: "CREATE TABLE commonstats (id INTEGER PRIMARY KEY,metacontactid TEXT,statname TEXT,statvalue1 TEXT,statvalue2 TEXT);"
kopete(2892)/kopete (statistics): error " " on query: "CREATE TABLE statsgroup(id INTEGER PRIMARY KEY,datetimebegin INTEGER,datetimeend INTEGER,caption TEXT);"

Comment 1 Paweł Prażak 2008-10-16 17:28:15 UTC

Can you provide more details, like what is expected behaviour, and what's wrong, how it affects application, etc. Does it only "print" error or there is something else wrong? Thanks.

Comment 2 Stas Ashirov 2008-10-17 09:24:42 UTC

Only don't work statistics plugin. Everything else work fine.

Comment 3 Rettich 2008-10-24 15:38:08 UTC

I have the same problem here.
Everything works fine expect the statistics plugin. Looks like the plugin is unable to get or save to the SQLite database.

Maybe some interessting versions:
openSuse 11.0 - i586
Qt: 4.4.3
KDE: 4.1.2 (KDE 4.1.2) "release 46.1"
Kopete: 0.60.3

Comment 4 Rettich 2008-10-25 17:07:32 UTC

If done some researching:

First: It doesn't help to delete the existing database. Kopete creates a new one but fails to create the tables.
Second: I compliled kopete from the the 4.1 branche from svn and replaced ONLY the statistics plugin. Still same effect.
Third: I open the database on my own and look and the existing enteries. The last entry is from: Mon, 14 Jul 2008 18:07:26 GMT. So the problem came with one of the openSuse updates near this date.

Comment 5 Pino Toscano 2008-11-05 00:52:24 UTC

*** Bug 174123 has been marked as a duplicate of this bug. ***

Comment 6 Nicolas L. 2008-11-07 19:44:32 UTC

SVN commit 881307 by nlecureuil:

Fix statistic plugin logic
BUG:172940
CCMAIL:lior.com@gmail.com


 M  +2 -2      statisticsdb.cpp  


WebSVN link: http://websvn.kde.org/?view=rev&revision=881307