Login Form

#445 – sql syntax error when creating new question

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.
Wednesday, 05 November 2014 22:47 AEDT
omnidk
Joomla! version: 2.5.27

Hi, when I go to create a new question I'm getting the following error:



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 'DER BY a.ordering ASC' at line 4 SQL=SELECT a.bfsurvey_question_id AS value, a.title AS text FROM po5_bfsurvey_questions AS a WHERE a.parent=0 and a.bfsurvey_question_id<>0 AND a.enabled=1 AND a.bfsurvey_category_id = ORDER BY a.ordering ASC
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 'DER BY a.parent, a.ordering' at line 4 SQL=SELECT a.bfsurvey_question_id AS value, a.title AS text FROM po5_bfsurvey_questions AS a WHERE a.bfsurvey_question_id<>0 AND a.enabled=1 AND a.bfsurvey_category_id = ORDER BY a.parent, a.ordering
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 'DER BY a.parent, a.ordering' at line 4 SQL=SELECT a.bfsurvey_question_id AS value, a.title AS text FROM po5_bfsurvey_questions AS a WHERE a.bfsurvey_question_id<>0 AND a.enabled=1 AND a.bfsurvey_category_id = ORDER BY a.parent, a.ordering


On localhost and production server. Any ideas? Cheers!
 
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