I am importing the file I exported from J3 to get the Books data from J3 to J4. (All other tables worked fine.) I confirmed that the file contains the correct integer value (without quotes) for USERID, but I keep getting the SQL error 1366. I am using the beta version 4 of A-book.
This issue may not affect users who stayed with v4.* of Mysql or MariaDB. I've moved up a version at the same time.
I found a request for help on StackOverFlow that looks as though it matches our situation.
https://stackoverflow.com/questions/41473485/cant-get-rid-of-error-number-1366-incorrect-integer-value
New versions of MariaDB and Mysql are less tolerant of the NULL value.
This suggests that either:
- IMPORT form does not return the integer value of the USERID, but instead returns NULL.
- IMPORT form puts NULL in the file instead of the existing value
- BOOK table definition for USERID does not allow NULL values.
The StackOverFlow recommendation is to change the BOOK table definition to allow NULL values for INTEGER columns.