PhpDivingLog: Import-Error 1064

[cool.runnings]

When I import Data from Diving Log 4.0 to my MySql-Database I get the following Error:

Code: Select all

SQL-Befehl:

#
# Data for table 'City'
#
INSERT INTO City
 'Diez', 0, '', , '2009-03-1109:54:37' ) ;

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '2009-03-1109:54:37')' at line 1 

I guess that it is the fiel UUID. When I replace
'Diez', 0, '', , '2009-03-1109:54:37' ) ;
with
'Diez', 0, '','' , '2009-03-1109:54:37' ) ;
everything works.

But I don't know whether the failure is in the Diving Log Export or in the MySqlImport.

[cool.runnings]

I found the reason for the failure

viewtopic.php?f=10&t=834&p=3796&hilit=uuid#p3796

[divinglog]

Hi

I've fixed this bug in an update, please download this zip file and extract it into the Diving Log program folder: divelog_eng.zip

This should fix the problem.

Kind regards,
Sven