Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

On Import, Error Messages from Whom?

bsmither's profile image bsmither posted 1 month ago in Import/Export Permalink

I am doing a Run SQL File to import, and Heidi (10.1.0.5464) is posting error messages.

Such as: Inserting a zero-length string on a DECIMAL(16,2) DEFAULT NULL column: / SQL Error (1366): Incorrect decimal value: '' for column captured at row 1 /

Inserting a zero-length string on an ENUM('0','1') NOT NULL DEFAULT '0' column: / SQL Error (1265): Data truncated for column 'free_shipping' at row 1 /

Inserting a zero-length string on a DATE DEFAULT NULL column: / SQL Error (1292): Incorrect date value: '' for column ship_date at row 1 /

Source database for SQL file dump: MySQL 5.6.45 Destination database: MariaDB 10.4.12

The question is:

Are these error messages legitimately coming from MariaDB or are they coming from Heidi complaining about something it doesn't like about the statement?

The above may seem like an ignorant question, but I ask just to eliminate any confusion.

These errors may also from the database's SET SQL_MODE state.

ansgar's profile image ansgar posted 1 month ago Permalink

The prefix "SQL Error" says that it's a message from the server (MariaDB), not from the client (HeidiSQL). The cause may be the generator of the sql file you are importing.

Please login to leave a reply, or register at first.