Have followed the Forms Customization tutorial from the
documents.
I have specifically tied the FC to a user group. When a person from this user group logs in to MODx we're using an Access Policy to hide the Elements and Files tree so we know the user group is functioning.
Forms customization doesn't appear to work at all. Even when we don't assign a user group it never works.
We have cleared the error log, the cache (both in MODx and physically), as well as flushed permissions and flushed sessions.
We do keep getting this error in the error log:
[2012-01-24 18:21:55] (ERROR @ /manager/index.php) Error preparing statement for query: SELECT `modActionDom`.`id`, `modActionDom`.`set`, `modActionDom`.`action`, `modActionDom`.`name`, `modActionDom`.`description`, `modActionDom`.`xtype`, `modActionDom`.`container`, `modActionDom`.`rule`, `modActionDom`.`value`, `modActionDom`.`constraint`, `modActionDom`.`constraint_field`, `modActionDom`.`constraint_class`, `modActionDom`.`active`, `modActionDom`.`for_parent`, `modActionDom`.`rank`, `FCSet`.`template`, `FCSet`.`constraint`, `FCSet`.`constraint_field`, `FCSet`.`constraint_class` FROM `modx_actiondom` AS `modActionDom` JOIN `modx_fc_sets` `FCSet` ON `modActionDom`.`set` = `FCSet`.`id` JOIN `modx_fc_profiles` `Profile` ON FCSet.profile = Profile.id LEFT JOIN `modx_fc_profiles_usergroups` `ProfileUserGroup` ON Profile.id = ProfileUserGroup.profile LEFT JOIN `modx_fc_profiles` `UGProfile` ON UGProfile.id = ProfileUserGroup.profile WHERE ( ( `modActionDom`.`action` = ? AND `modActionDom`.`for_parent` = ? AND `FCSet`.`active` = ? AND `Profile`.`active` = ? ) AND ( ( `ProfileUserGroup`.`usergroup` IN ('1') OR ( `ProfileUserGroup`.`usergroup` IS ? AND `UGProfile`.`active` = ? ) ) OR `ProfileUserGroup`.`usergroup` IS ? ) ) ORDER BY modActionDom.rank ASC - Array
(
[0] => 42000
[1] => 1064
[2] => 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 '? AND `UGProfile`.`active` = ? ) ) OR `ProfileUserGroup`.`usergroup` IS ? ) )' at line 1
)
☆ A M B ☆