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:
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
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
Hi Marcus,
If you turn the ChronoForms Debugger on then you should be able to see the query that is being created.
Bob
If you turn the ChronoForms Debugger on then you should be able to see the query that is being created.
Bob
Thanks Bob,
i turned it on on every switch i found, but there is NO querey, thats why you see me helpless....
in the very moment i press the submit button, the mentioned error message appears without showing debug info :-(
Cheers,
Marcus
i turned it on on every switch i found, but there is NO querey, thats why you see me helpless....
in the very moment i press the submit button, the mentioned error message appears without showing debug info :-(
Cheers,
Marcus
Hi Marcus,
please check the table name is correct - usually there is a prefix before chronoforms
Bob
please check the table name is correct - usually there is a prefix before chronoforms
Bob
The Table name is "chronoforms_data_dbmm-input" - it was selected from the dropdown "Database table" - no prefix. :-/
Marcus
Marcus
You need to login to be able to post a reply.
