Hello,
I’ve experienced a problem using MODx Revolution.
After installing without any errors, I am brought to the login page for the manager panel. Once I do so, however, nothing shows up; I get a blank white page. If I clear my cache, I am able to re-enter login information and the page can still detect incorrect login combos.
Running on:
PHP 5.1.2
MySQL 5.0.22
Apache 2.0.55
Debian
In the error logs I get:
[2011-01-27 14:29:30] (ERROR @ /manager/index.php) Error preparing statement for query: SELECT modActionDom.*, Set.constraint_class, Set.constraint_field, Set.constraint, Set.template FROM `queensu_actiondom` AS `modActionDom` JOIN `queensu_fc_sets` `Set` ON `modActionDom`.`set` = `Set`.`id` JOIN `queensu_fc_profiles` `Profile` ON Set.profile = Profile.id LEFT JOIN `queensu_fc_profiles_usergroups` `ProfileUserGroup` ON Profile.id = ProfileUserGroup.profile LEFT JOIN `queensu_fc_profiles` `UGProfile` ON UGProfile.id = ProfileUserGroup.profile WHERE ( ( `modActionDom`.`action` = ? AND `modActionDom`.`for_parent` = ? AND `Set`.`active` = ? AND `Profile`.`active` = ? ) AND ( ( `ProfileUserGroup`.`usergroup` IN ('1') OR ( `ProfileUserGroup`.`usergroup` IS ? AND `UGProfile`.`active` = ? ) ) OR `ProfileUserGroup`.`usergroup` IS ? ) ) ORDER BY Set.template ASC, 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
)
Any help?
MODX Staff
