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.

Errors in SQL-Export using Nightly Build 10.3.0.5813

Program4fun's profile image Program4fun posted 2 months ago in General Permalink

Today I have updated to the latest NightlyBuild version 10.3.0.5813 and I got errors during export tables from one database to another.

I have reproduces this with previous version and I found out that the problem came in the last changes.

With 10.3.0.5812 the export runs without problems.

See the picture for details.

Best regards Program4fun

1 attachment(s):
  • Heidi-Export-Differences
ansgar's profile image ansgar posted 2 months ago Permalink

That screen shows harmless changes I suppose. You should post the errors instead.

Program4fun's profile image Program4fun posted 2 months ago Permalink

/ SQL Fehler (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-00-00 00:00:00, Versandt TINYINT(1) NOT NULL DEFAULT 0, Warenempfaenger' at line 11 /

The unquoted 0000-00-00 00:00:00 is the problem.

<code> Datum TIMESTAMP NOT NULL DEFAULT 0000-00-00 00:00:00, </code> SQL-Error 1064

<code> Datum TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', </code> OK

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.
Code modification/commit 6f314a2 from Ansgar Becker <anse@heidisql.com>, 2 months ago, revision 5817
Detect static date/time values as text type, not expression. See https://www.heidisql.com/forum.php?t=35370
ansgar's profile image ansgar posted 2 months ago Permalink

Should be fixed in the next build.

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