Sqlite mysql migration Invalid datetime format

ℹ️ Support
1

Nextcloud version (eg, 12.0.2): 12.0.3
Operating system and version (eg, Ubuntu 17.04): Debian 8.9
Apache or nginx version (eg, Apache 2.4.25): Apache/2.4.10 (Debian)
PHP version (eg, 7.1): 7.1.11

The issue you are facing:

Converting from sqlite to MariaDB-10.2.13 I get error messages stating:

SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘2017-11-24T17:23:36+00:00’ for column ‘duedate’ at row 1

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Run conversion command

sudo -u www-data php occ db:convert-type --port=“port” --password={pwd} --clear-schema --all-apps mysql {username} {IP} {database name}

  1. after several task ok, we get this error:

Clearing schema in new database
Creating schema in new database
oc_accounts
146/146 [============================] 100%oc_activity
26/26 [============================] 100%oc_activity_mq
0 [>---------------------------]oc_addressbookchanges
774/774 [============================] 100%oc_addressbooks
21/21 [============================] 100%oc_admin_sections
7/7 [============================] 100%oc_admin_settings
19/19 [============================] 100%oc_appconfig
277/277 [============================] 100%oc_authtoken
14/14 [============================] 100%oc_bruteforce_attempts
81/81 [============================] 100%oc_calendarchanges
466/466 [============================] 100%oc_calendarobjects
76/76 [============================] 100%oc_calendarobjects_props
228/228 [============================] 100%oc_calendars
22/22 [============================] 100%oc_calendarsubscriptions
0 [>---------------------------]oc_cards
47/47 [============================] 100%oc_cards_properties
234/234 [============================] 100%oc_comments
0 [>---------------------------]oc_comments_read_markers
0 [>---------------------------]oc_credentials
15/15 [============================] 100%oc_dashboard_announcements
0 [>---------------------------]oc_dashboard_files
0 [>---------------------------]oc_dashboard_settings
0 [>---------------------------]oc_dav_shares
1/1 [============================] 100%oc_deck_assigned_labels
5/5 [============================] 100%oc_deck_assigned_users
22/22 [============================] 100%oc_deck_attachment
0 [>---------------------------]oc_deck_board_acl
5/5 [============================] 100%oc_deck_boards
4/4 [============================] 100%oc_deck_cards
5/30 [====>-----------------------] 16%

[Doctrine\DBAL\Exception\DriverException]
An exception occurred while executing ‘INSERT INTO oc_deck_cards (id, title, description, stack_id, type, last_modified, created_at, owner, order, archived, duedate, notified) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“5”, “Formazione”, null, “2”, “plain”, “1510334546”, “1510334516”, “236AED7D-C56D-41A1-98AF-ED6E3C354F92”, “999”, “0”, “2017-11-24T17:23:36+00:00”, “0”]:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘2017-11-24T17:23:36+00:00’ for column ‘duedate’ at row 1

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘2017-11-24T17:23:36+00:00’ for column ‘duedate’ at row 1

[PDOException]
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘2017-11-24T17:23:36+00:00’ for column ‘duedate’ at row 1

2

SOLVED

We used Deck for few days so we do not have many deck borad/Stack configured so we Annotated and Delete every Due Date, run conversion without errors, re-inserted task Due Date. We found a bug on inserting Due Date was fixed:


so, we understand it was only a conversion issue.