upload destination mysql error
Development and Programming
I am trying to create a new upload destination on our website and each time I try to set it up I get this error:
MySQL ERROR:
Error Number: 1064
Description: 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 ‘ON DUPLICATE KEY UPDATE id=values(id), key=values(key), val
Query: INSERT INTO exp_mh_file VALUES(”, 2, ‘allow_multiple’, ‘no’) ON DUPLICATE KEY UPDATE id=values(id), key=values(key), value=values(value)
Any idea what the problem is?
That is a problem with Mark Huot’s file extension, as you can see with the exp_mh_file. If you disable that you should be able to create a standard file upload destination.
Going to move this down to extensions for you as well.
c_k– make sure you’re using the latest version of the extension. Are you on 3.1.1?
http://docs.markhuot.com/ee/extensions/file
yes I am using the most updated version..