Error: 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 'values = '' WHERE id = 17' at line 2 SQL=UPDATE `p71ft_bfsurveyplus_20` SET values = '' WHERE id = 17

I've unpublished all but one question and still we get the above error - please advise. Also the questions are all mandatory, yet I can submit without answering all the questions

Hi Werner,
I'm glad you've solved the problem. For the benefit of others reading this, there are a number of mySQL reserved words that you should avoid using for your db field name.
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

With regards to being able to submit form without answering mandatory questions, have you installed and published the BF Validate Plus plugin?
http://tamlynsoftware.com/download/free-downloads/free-downloads-joomla-3-extensions.html

regards

Tim

Follow us on twitter http://twitter.com/tamlynsoftware

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.