[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [kmymoney4] [Bug 301104] Crash Kmymoney after connection to mysql
From:       Phil R <ppslim+kde () gmail ! com>
Date:       2013-12-31 0:59:45
Message-ID: bug-301104-17878-IUemKE7EZu () http ! bugs ! kde ! org/
[Download RAW message or body]

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

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

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

--- Comment #5 from Phil R <ppslim+kde@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 watching all bug changes.
[prev in list] [next in list] [prev in thread] [next in thread]