Quote from: sottwell at Mar 19, 2013, 03:42 PMCheck your error logs; not only the one in the Manager but also the one two levels up from the web root (use SFTP or SSH to view these logs).
Manager log shows the following:
[2013-03-19 16:33:35] (ERROR @ /index.php) Error 42S22 executing query: SELECT `fmzForms`.`id` AS `fmzForms_id`, `fmzForms`.`name` AS `fmzForms_name`, `fmzForms`.`method` AS `fmzForms_method`, `fmzForms`.`email` AS `fmzForms_email`, `fmzForms`.`success_message` AS `fmzForms_success_message`, `fmzForms`.`identifier` AS `fmzForms_identifier`, `fmzForms`.`action_button` AS `fmzForms_action_button`, `fmzForms`.`createdon` AS `fmzForms_createdon`, `fmzForms`.`createdby` AS `fmzForms_createdby`, `fmzForms`.`editedon` AS `fmzForms_editedon`, `fmzForms`.`editedby` AS `fmzForms_editedby`, `Fields`.`id` AS `Fields_id`, `Fields`.`form_id` AS `Fields_form_id`, `Fields`.`type` AS `Fields_type`, `Fields`.`settings` AS `Fields_settings`, `Fields`.`order` AS `Fields_order`, `Validation`.`id` AS `Validation_id`, `Validation`.`field_id` AS `Validation_field_id`, `Validation`.`type` AS `Validation_type`, `Validation`.`error_message` AS `Validation_error_message` FROM `modx_formz_forms` AS `fmzForms` LEFT JOIN `modx_formz_forms_fields` `Fields` ON `fmzForms`.`id` = `Fields`.`form_id` LEFT JOIN `modx_formz_forms_validation` `Validation` ON `Fields`.`id` = `Validation`.`field_id` WHERE `fmzForms`.`id` = ? ORDER BY Fields.order ASC, Fields.id ASC, `fmzForms`.`id` ASC - Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'Validation.id' in 'field list'
)
I noticed that when I clicked the "required" and choose a dropdown for the "validation" and then hit Save, the required column for the field says "No". Not sure why it won't save it as "Yes".
☆ A M B ☆
☆ A M B ☆
☆ A M B ☆