Seeing error on import: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value

[charlesroper]

I've only just installed and started using LinkAce so please forgive me if this is user error.

I am trying to import an html file I have exported and I am seeing this error:

SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2021-03-28 01:15:34' for column 'created_at' at row 1 (Connection: mysql, SQL: insert into `links` (`user_id`, `url`, `title`, `description`, `icon`, `is_private`, `created_at`, `updated_at`) values (1, https://realpython.com/asteroids-game-python/?__s=n9623gk1tnlu6rbjgl5n, Build an Asteroids Game With Python and Pygame – Real Python, In this tutorial, you'll build a clone of the Asteroids game in Python using Pygame. Step by step, you'll add images, input handling, game logic, sounds, and text to your program., link, 1, 2021-03-28 01:15:34, 2024-02-21 22:19:38)) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 22007): SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2021-03-28 01:15:34' for column 'created_at' at row 1 (Connection: mysql, SQL: insert into `links` (`user_id`, `url`, `title`, `description`, `icon`, `is_private`, `created_at`, `updated_at`) values (1, https://realpython.com/asteroids-game-python/?__s=n9623gk1tnlu6rbjgl5n, Build an Asteroids Game With Python and Pygame – Real Python, In this tutorial, you'll build a clone of the Asteroids game in Python using Pygame. Step by step, you'll add images, input handling, game logic, sounds, and text to your program., link, 1, 2021-03-28 01:15:34, 2024-02-21 22:19:38)) at /home/roperim/links.roper.im/site/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829)

I see the same if using the CLI:

The line in the html file is this one:

<DT><A HREF="https://realpython.com/asteroids-game-python/?__s=n9623gk1tnlu6rbjgl5n" ADD_DATE="1616894134" LAST_MODIFIED="1707510963" TAGS="Development,Python,Programming,Tutorial,Games" DATA-COVER="https://files.realpython.com/media/Project-based-Make-A-Simple-Asteroids-Clone-with-Pygame_Watermarked.36f4ec74e4ca.jpg" DATA-IMPORTANT="false">Build an Asteroids Game With Python and Pygame – Real Python</A>

That date looks ok to me, so what could be the problem here?

The file I am importing contains 197 links.

Update: I removed that line from the import and the other bookmarks imported fine, so it seem it's something specific to this line only.

Many thanks.

[Kovah]

Hm that's weird. I added the line you sent to the import test file and it ran through smoothly. It may even be a line before messing up some structure.

Anyway, great that it's working now.