file upload sql error- file extension
Development and Programming
When I attempt to click on File Upload Preferences in the CP I get the following 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 ” at line 1 Query: SELECT * FROM exp_mh_file WHERE upload_id=
EDIT: Correction… when I click on Create New Upload Destination from within File Upload Preferences.
Please advise.
Thank you,
Rick
It looks like a third party extension throwing the error- Mark’s file extension, guessing based on the table name. Try disabling all extensions- should eliminate the error.
To figure out why and how to fix it, you’d want to contact the author or check the extensions forum. If you like, I can shift this one over there and tweak the title.
ah… I see the table name. Sorry… I was in such a hurry I didn’t even pay much attention. I just posted for help. I usually don’t do that. Again, I apologize.
Thank you,
Rick
We’re here to help, so posting was a good thing! Think I will go ahead and shift down to ‘extensions’- I’m pretty sure there’s a known way around this, but I don’t recall what it is. Disable extensions, create the new field, re-enable. Something along those lines. But I don’t have it installed to test, so can’t swear.
Should be fixable, though.