after using the fields for the "DB Viewer" I have a problem with the data viewer. I think it's because of using a space in one label "Informationen anfordern". I've deleted the input, but the error is still there:
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 '`ListData`.`anfordern` ASC LIMIT 30' at line 1 SQL=SELECT `ListData`.`id` AS `ListData.id`, `ListData`.`uniq_id` AS `ListData.uniq_id`, `ListData`.`user_id` AS `ListData.user_id`, `ListData`.`created` AS `ListData.created`, `ListData`.`modified` AS `ListData.modified`, `ListData`.`einrichtung` AS `ListData.einrichtung`, `ListData`.`anrede` AS `ListData.anrede`, `ListData`.`vorname` AS `ListData.vorname`, `ListData`.`name` AS `ListData.name`, `ListData`.`strasse` AS `ListData.strasse`, `ListData`.`ort` AS `ListData.ort`, `ListData`.`email` AS `ListData.email`, `ListData`.`telefon` AS `ListData.telefon`, `ListData`.`Informationen` AS `ListData.Informationen`, `ListData`.`Kommentar` AS `ListData.Kommentar` FROM `b7i9k_chronoforms_cf5_Kontaktformular` AS `ListData` ORDER BY `ListData`.`informationen` `ListData`.`anfordern` ASC LIMIT 30
Any idea how I can solve the problem?
With best regards,
Susan
You need also to delete the column in the database table - if it exists at all. And then Click the Delete Cache icon in the Forms Manager toolbar to update ChronoForms temporary records.
I think that should fix it.
Bob
