1064 You have an error in your SQL syntax;

Question

I want to make a database search form where i can choose from predefined values (radio/dropdown).
in the submit actions i have the read data:

bit everytime i get on submit the 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 'FROM `chronoforms_data_dbmm-input` AS `dbmmdata`' at line 1

i turned on debugging wherever it was possible, but i cannot find any SQL statement or where the error might be.
any ideas? im lost...

Joomla 3.9.26
Chronoforms 6.1.4
MySQL 5.7.28
PHP 7.4.14

Cheers,
Marcus

mholinka · Accepted Answer

I want to make a database search form where i can choose from predefined values (radio/dropdown).
in the submit actions i have the read data:

bit everytime i get on submit the 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 'FROM `chronoforms_data_dbmm-input` AS `dbmmdata`' at line 1

i turned on debugging wherever it was possible, but i cannot find any SQL statement or where the error might be.
any ideas? im lost...

Joomla 3.9.26
Chronoforms 6.1.4
MySQL 5.7.28
PHP 7.4.14

Cheers,
Marcus

Forums

1064 You have an error in your SQL syntax;