Exception when importing csv.
Permalink Browser Info Environment
Got the following when importing stores.
I suspect this results from a 'strict' database rather than a 5.7 to 8.0.3 difference. When a database is strict, null or empty string do not map to an integer.
See:
https://dev.mysql.com/doc/refman/5.6/en/sql-mode.html#sql-mode-stric...
An exception occurred while executing 'INSERT INTO bthwstorelocation(name, address, city, state, country, zip, phone, email, url, urltext, extra, gID) values ( 'PROST BREWING COMPANY','2540 19th Street','Denver','CO','80202','United States','(415)794-0360','ME@YOU.COM','YAHOO.COM','GOOGLE','MORE','' )': SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'gID' at row 1
I suspect this results from a 'strict' database rather than a 5.7 to 8.0.3 difference. When a database is strict, null or empty string do not map to an integer.
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
See:
https://dev.mysql.com/doc/refman/5.6/en/sql-mode.html#sql-mode-stric...
Type: | Pre-Sale |
---|---|
Status: | Resolved |
Just got a similar database issue when adding a location manually
The second exception appears to be related to geolocation not completing (google api key settings). With API key settings correct, the second exception does not happen and I can enter locations manually.
The first issue on csv import still whoopses.
The first issue on csv import still whoopses.
I have rewritten the csv import, this will be included in the next release.