Problem with indexing - Invalid datetime format

Permalink
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
View Replies:
Dutchwave replied on at Permalink Reply
Dutchwave
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.