PhpDivingLog: Import-Error 1064

3rd party extensions (phpDivingLog, dive computer downloader,...)
Post Reply
cool.runnings
Posts: 2
Joined: Wed Mar 11, 2009 10:07

PhpDivingLog: Import-Error 1064

Post by cool.runnings » Wed Mar 11, 2009 10:12

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
Posts: 2
Joined: Wed Mar 11, 2009 10:07

Re: PhpDivingLog: Import-Error 1064

Post by cool.runnings » Wed Mar 11, 2009 11:20

I found the reason for the failure

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

divinglog
Site Admin
Posts: 4934
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: PhpDivingLog: Import-Error 1064

Post by divinglog » Wed Mar 11, 2009 20:09

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

Post Reply