Exception when importing csv.

Permalink Browser Info Environment
Got the following when importing stores.
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.



Type: Pre-Sale
Status: Resolved
View Replies:
JohntheFish replied on at Permalink Reply
Just got a similar database issue when adding a location manually
An exception occurred while executing 'INSERT INTO bthwstorelocation VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [null, "Prost Brewing Co", "2540 19th Street", "Denver", "Colorado", "United States", "80202", "", "", "", "", "", "", "", "0", "0", "0"]: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'latitude' at row 1
JohntheFish replied on at Permalink Reply
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.
edbeeny replied on at Permalink Reply
I have rewritten the csv import, this will be included in the next release.

concrete5 Environment Information

8.0.3, with install patch

Browser User-Agent String

Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.