[Kmymoney-devel] [kmymoney4] [Bug 301104] Crash Kmymoney after connection to mysql

[Phil R]

https://bugs.kde.org/show_bug.cgi?id=301104

Phil R <ppslim+kde at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ppslim+kde at gmail.com

--- Comment #5 from Phil R <ppslim+kde at 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.