MySQL upload error

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

MySQL upload error

Post by Mouse51180 »

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: 5
Joined: Sun Mar 23, 2014 21:50

Re: MySQL upload error

Post by mortenfirst »

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: 5764
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: MySQL upload error

Post by divinglog »

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: 5
Joined: Sun Mar 23, 2014 21:50

Re: MySQL upload error

Post by mortenfirst »

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