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
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


Monday, 17 February 2014 20:37 AEDT
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'
BF Quiz Plus 3 Years
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.

With regards to being able to submit form without answering mandatory questions, have you installed and published the BF Validate Plus plugin?


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