Login Form

#132 – Syntax Error 1064

Posted in ‘BF Survey’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Monday, 17 February 2014 19:48 AEDT
werner@doubleudesign.co.za
Joomla! version: (3.2.2)

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

URL:

http://www.themindspa.co.za/index.php?option=com_bfsurvey_plus&view=onepage&catid=20
Monday, 17 February 2014 20:37 AEDT
werner@doubleudesign.co.za
Problem sorted - without knowing it I used a reserved SQL DB table name - changed it and seems to be working now
Tuesday, 18 February 2014 08:40 AEDT 5'
Tim
Everything Bundle, BF Quiz Plus 3 Years, BF Survey 12 Months
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.
Go to top