Problem with indexing - Invalid datetime format

Permalink January 03, 2019 at 3:19 PM

An exception occurred while executing 'UPDATE CollectionSearchIndexAttributes SET ak_plaats = ? WHERE cID = ?' with params ["\nHonselersdijk\n", "1871"]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: ' Honselersdijk ' for column 'ak_plaats' at row 1

I've updated the system from 8.4.1 to 8.4.3, now this exception is given when adding a page that uses the ak_plaats attribute (express attribute) and when I'm trying to Index the Search Engine..

I've deselected the attribute to be indexed (both attribute and express). But no luck.
ak_plaats is an integer, not a datetime format. So I don't get where it goes wrong?

Dutchwave replied on Jan 3, 2019 at 4:07 pm Permalink Reply

Within the database I changed the type from integer to longtext for ak_plaats, and this seems to have fixed it.
Doesn't really feel like the correct way, I'm open for better suggestions.