MySQL upload error

3rd party extensions (phpDivingLog, dive computer downloader,...)
Post Reply
Mouse51180
Posts: 9
Joined: Thu Aug 01, 2013 15:08

MySQL upload error

Post by Mouse51180 » Wed Jan 07, 2015 02:56

Trying to upload to MySQL and getting the following error:

Code: Select all

SQL query:
OP TABLE IF EXISTS DL_Brevets;

MySQL said: Documentation
#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 'OP TABLE IF EXISTS DL_Brevets' at line 1 
I got this to upload once before...not sure what changed that I am having issue now. Any ideas on what I need to do to adjust this code to work?

mortenfirst
Posts: 3
Joined: Sun Mar 23, 2014 21:50

Re: MySQL upload error

Post by mortenfirst » Thu Jan 15, 2015 13:14

I get this error too. I have tried both with the annoying MariaDB from synology and a plain MySQL install on a Debian server. Same error.

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

Re: MySQL upload error

Post by divinglog » Thu Jan 15, 2015 14:46

I've discussed this with the OP via email. The problem is, the command is normally:

Code: Select all

DROP TABLE IF EXISTS DL_Brevets;
As you can see, the first 2 characters of "DROP" get lost during upload. We have not found the root of the problem, because the characters are clearly in the file. I think it is an encoding problem, so I suggest you try different settings in the export dialog.

mortenfirst
Posts: 3
Joined: Sun Mar 23, 2014 21:50

Re: MySQL upload error

Post by mortenfirst » Tue Jan 20, 2015 09:19

That's right, I've tried to import via the SQL field with the text copied in in phpmyadmin instead of uploading the file. This works.

Post Reply