[Kmymoney-devel] KMyMoney suddenly not entering transactions

[Eric Bonney]

So I was able to get a working copy from one of the older versions stored
on Dropbox. Here is the output of my session that I just did after entering
about 4 or 5 transactions with no problem, but then once I try to enter the
schedules it crashes.

eric at DELL-XPS-8700:~$ kmymoney
Bus::open: Can not get ibus-daemon's address.
IBusInputContext::createInputContext: no connection to ibus-daemon
kmymoney(4143)/kdecore (K*TimeZone*): KSystemTimeZones: ktimezoned
initialize() D-Bus call failed:  "The name org.kde.kded was not provided by
any .service files"

7:2015/08/14 10-17-57:aqbanking(4143):started
KMyMoney kbanking plugin loaded
KMyMoney reconciliation report plugin loaded
KMyMoney csvimport plugin loaded
KMyMoney printcheck plugin loaded
QFSFileEngine::open: No file name specified
KMyMoney ofximport plugin loaded
KMyMoney csvexport plugin loaded
KMyMoney iCalendar plugin loaded
request balance for A000180 at 2015-08-14
request balance for A000207 at 2015-08-14
request balance for A000188 at 2015-08-14
request balance for A000180 at 2015-08-13
request balance for A000188 at 2015-08-13
request balance for A000207 at 2015-08-13
QPainter::begin: Widget painting can only begin as a result of a paintEvent
QPainter::translate: Painter not active
QPainter::setClipRect: Painter not active
Error in function void MyMoneyStorageSql::writeKeyValuePairs(const
QString&, const QVariantList&, const QList<QMap<QString, QString> >&) :
writing KVP
Driver = QSQLITE, Host = localhost, User = eric, Database =
/home/eric/Eric/Dropbox/KMyMoney/EABonney.sqlite
Driver Error:
Database Error No -1:
Text:
Error type 0
Executed: INSERT INTO kmmKeyValuePairs (kvpType, kvpId, kvpKey, kvpData)
VALUES (?, ?, ?, ?);
Query error No 11: database disk image is malformed Unable to fetch row
Error type 1
void MyMoneyStorageSql::cancelCommitUnit(const QString&) - void
MyMoneyStorageSql::writeKeyValuePairs(const QString&, const QVariantList&,
const QList<QMap<QString, QString> >&) s/be void
MyMoneyStorageSql::modifyAccountList(const QList<MyMoneyAccount>&)
Unable to store transaction within engine: Error in function void
MyMoneyStorageSql::writeKeyValuePairs(const QString&, const QVariantList&,
const QList<QMap<QString, QString> >&) : writing KVP
Driver = QSQLITE, Host = localhost, User = eric, Database =
/home/eric/Eric/Dropbox/KMyMoney/EABonney.sqlite
Driver Error:
Database Error No -1:
Text:
Error type 0
Executed: INSERT INTO kmmKeyValuePairs (kvpType, kvpId, kvpKey, kvpData)
VALUES (?, ?, ?, ?);
Query error No 11: database disk image is malformed Unable to fetch row
Error type 1

So is this saying something is messed up with my schedules? When I look at
them they appear to be just fine, but I get the same error no matter which
schedule I choose to try and enter.

Thanks,
Eric

On Wed, Aug 12, 2015 at 11:32 AM, Eric Bonney <eric at ericbonney.com> wrote:

> Hi Jack:
>
> I ran KMM from the command line and it appears that the database has
> somehow become corrupted. So the next question is, how do I repair the
> database if at all? I can try to resave it back to the default storage type
> but it appears to just hang and not actually do anything when I try this.
> This is the message that is output when I try to save as:
>
> Object::connect: No such signal
> org::freedesktop::UPower::DeviceAdded(QDBusObjectPath)
> Object::connect: No such signal
> org::freedesktop::UPower::DeviceRemoved(QDBusObjectPath)
>
> Then KMM just hangs and does not appear to ever do anything else.
>
> Any other suggestions?
>
> Thanks again for all the help!
>
> Eric
>
> On Tue, Aug 11, 2015 at 3:50 PM, Jack <ostroffjh at frontier.com> wrote:
>
>> On 2015.08.11 15:16, Eric Bonney wrote:
>>
>>> Just recently I discovered that I am unable to enter new transactions
>>> into
>>> my KMyMoney file. I am using the SQlite storage option and running 4.7.2.
>>>
>>> I haven't entered anything in a week or so, but today I was catching up
>>> my
>>> checkbook and it wouldn't let me enter anything. After filling out the
>>> transaction details and clicking ok, KMM looks like it saves it, but I
>>> never see it entered into my ledger and my account balance is never
>>> updated.
>>>
>>> I have resorted to entering all new transactions with my Android app for
>>> the time being. I have not yet had time to try and save my file to back
>>> to
>>> the traditional KMM file format yet but I may give this a shot tomorrow
>>> night if I get time or if someone else doesn't have any other ideas.
>>>
>>> I installed the package from Clay's PPA if that makes any difference.
>>>
>>
>> My first suggestion would be to run from command line to see if there are
>> any messages output to console.  I would also check for any SQLite
>> messages.  Separately, you could try saving to a .kmy file or even creating
>> a new one just for testing, to see if the problem persists.  If not, the
>> problem is somehow related to using the database back end.
>>
>> Jack
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20150814/6aaa6b67/attachment.html>