Can't open SQLite database after upgrading system to Kubuntu 12.04

[Eric A. Boney]

I just completed a fresh installation of Kubuntu 12.04 this evening. I then added Clay's ppa to my system like normal and installed KMyMoney. I then tried to open my sqlite database file that I had used earlier this morning on my previous 10.04 system and well it won't open now. The same file still works just fine in my Android version of KMM but not in this newest version that was installed with 12.04.

KMyMoney version = 4.6.2

The following is the error that I get anytime I try to open the database:

Error in function const QMap MyMoneyStorageSql::fetchSchedules(const QStringList&, bool) const : reading Schedules Driver = QSQLITE, Host = localhost, User = eric, Database = /home/eric/Dropbox/KMyMoney/EABonney.sqlite Driver Error: Database Error No -1: Text: Error type 0 Executed: SELECT id, name, type, typeString, occurence, occurenceMultiplier, occurenceString, paymentType, paymentTypeString, startDate, endDate, fixed, autoEnter, lastPayment, nextPaymentDue, weekendOption, weekendOptionString FROM kmmSchedules ORDER BY id;; Query error No -1: No query Unable to fetch row Error type 1 in file /build/buildd/kmymoney-4.6.2/kmymoney/mymoney/storage/mymoneystoragesql.cpp line 3362

Anyone got any ideas as to why this is happening now?

Thanks,

-Eric

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

On Friday, June 08, 2012 23:46:53 Eric Bonney wrote:

> I just completed a fresh installation of Kubuntu 12.04 this evening. I then
> added Clay's ppa to my system like normal and installed KMyMoney. I then
> tried to open my sqlite database file that I had used earlier this morning
> on my previous 10.04 system and well it won't open now. The same file still
> works just fine in my Android version of KMM but not in this newest version
> that was installed with 12.04.
>
> KMyMoney version = 4.6.2
>
> The following is the error that I get anytime I try to open the database:
>
> Error in function const QMap MyMoneyStorageSql::fetchSchedules(const
> QStringList&, bool) const : reading Schedules Driver = QSQLITE, Host =
> localhost, User = eric, Database =
> /home/eric/Dropbox/KMyMoney/EABonney.sqlite Driver Error: Database Error No
> -1: Text: Error type 0 Executed: SELECT id, name, type, typeString,
> occurence, occurenceMultiplier, occurenceString, paymentType,
> paymentTypeString, startDate, endDate, fixed, autoEnter, lastPayment,
> nextPaymentDue, weekendOption, weekendOptionString FROM kmmSchedules ORDER
> BY id;; Query error No -1: No query Unable to fetch row Error type 1 in
> file
> /build/buildd/kmymoney-4.6.2/kmymoney/mymoney/storage/mymoneystoragesql.cpp
> line 3362
>
> Anyone got any ideas as to why this is happening now?
>

There was an extra semicolon in the SQL command on line 3346. It was removed
in revision 324612f8, but after the release of 4.6.2. If you want to try
compiling from source, then you could remove it. Otherwise, there would need
to be an update to Claydoh's PPA.

--
Thanks,
Fernando Vilas
fvilas@...


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer