[Kmymoney-devel] Error creating custom report

Eric Bonney eric at ericbonney.com
Wed Nov 5 14:54:04 UTC 2014


Thanks for the quick response Cristian!

Ran the quick SQL changes and all is good again.

Thanks,
Eric

On Wed, Nov 5, 2014 at 9:07 AM, Cristian Oneț <onet.cristian at gmail.com>
wrote:

> It's still an open bug [1], but check out the report for a workaround.
>
> Regards,
> Cristian
>
> [1] https://bugs.kde.org/show_bug.cgi?id=339103
>
> 2014-11-05 15:59 GMT+02:00 Eric Bonney <eric at ericbonney.com>:
> > I have finally upgraded to the latest release of KMyMoney, 4.7.1 on my
> > desktop running Kubuntu 14.04. Since doing this I am receiving the
> following
> > error when I try to create a new report from a previously created user
> > report:
> >
> > Cannot add report, reason: "Error in function void
> > MyMoneyStorageSql::writeReport(const MyMoneyReport&, QSqlQuery&) :
> writing
> > Reports
> > Driver = QSQLITE, Host = localhost, User = eric, Database =
> > /home/eric/Dropbox/KMyMoney/EABonney.sqlite
> > Driver Error:
> > Database Error No -1:
> > Text:
> > Error type 0
> > Executed: INSERT INTO kmmReportConfig (name, XML, id) VALUES (?, ?, ?);
> > Query error No 19: UNIQUE constraint failed: kmmReportConfig.id Unable to
> > fetch row
> > Error type 1"
> >
> > This happens every time I try to create a new report with a user defined
> > date range. Anyone else getting this?
> >
> > Eric
> >
> > _______________________________________________
> > KMyMoney-devel mailing list
> > KMyMoney-devel at kde.org
> > https://mail.kde.org/mailman/listinfo/kmymoney-devel
> >
> _______________________________________________
> KMyMoney-devel mailing list
> KMyMoney-devel at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20141105/e1a8fd94/attachment.html>


More information about the KMyMoney-devel mailing list