https://bugs.kde.org/show_bug.cgi?id=301104
Phil R <ppslim+...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ppslim+...@gmail.com
--- Comment #5 from Phil R <ppslim+...@gmail.com> ---
I experienced this and a lot more on Windows.
The SQL used to populate this table does not seem to be correct.
Query as taken from the Generate Database SQL screen.
INSERT INTO kmmFileInfo (version, created, lastModified, baseCurrency,
institutions, accounts, payees, transactions, splits, securities, prices,
currencies, schedules, reports, kvps, dateRangeStart, dateRangeEnd,
hiInstitutionId, hiPayeeId, hiAccountId, hiTransactionId, hiScheduleId,
hiSecurityId, hiReportId, encryptData, updateInProgress, budgets, hiBudgetId,
logonUser, logonAt, fixLevel) VALUES (6, 2013-12-31, 2013-12-31, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', NULL, NULL, NULL, NULL, 4)
Exact error when run manually from MySQL Workbench:
1 row(s) affected, 2 warning(s): 1265 Data truncated for column 'created' at
row 1 1265 Data truncated for column 'lastModified' at row 1
Wrapping the dates for these columns in quotes fixed this. This also allowed me
to get past this error whilst trying to open the database.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
KMyMoney-devel mailing list
KMyMoney-devel@kde.org
https://mail.kde.org/mailman/listinfo/kmymoney-devel
