Hey, I was just wondering if anyone has seen the error below before. It occurs on any page that I navigate to. I first noticed it because none of the drop down lists in the admin are populating.
Also, I first noticed in RC2, so I decided to try the latest version straight from svn and the error is occurring with it as well.
Thanks in advance for the help.
[2010-06-13 15:43:02] (ERROR @ /manager/index.php) Error preparing statement for query: SELECT `modActionDom`.`id` AS `modActionDom_id`, `modActionDom`.`action` AS `modActionDom_action`, `modActionDom`.`name` AS `modActionDom_name`, `modActionDom`.`description` AS `modActionDom_description`, `modActionDom`.`xtype` AS `modActionDom_xtype`, `modActionDom`.`container` AS `modActionDom_container`, `modActionDom`.`rule` AS `modActionDom_rule`, `modActionDom`.`value` AS `modActionDom_value`, `modActionDom`.`constraint` AS `modActionDom_constraint`, `modActionDom`.`constraint_field` AS `modActionDom_constraint_field`, `modActionDom`.`constraint_class` AS `modActionDom_constraint_class`, `modActionDom`.`active` AS `modActionDom_active` FROM `modx_actiondom` AS `modActionDom` LEFT JOIN `modx_access_actiondom` `Access` ON `modActionDom`.`id` = `Access`.`target` WHERE ( `modActionDom`.`action` = ? AND `modActionDom`.`active` = ? AND ( ( `Access`.`principal_class` = ? AND `Access`.`principal` IN (1) ) OR `Access`.`principal` IS ? ) ) 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 ’? ) )’ at line 1
)
Yep, I kept the error log open in one window while navigating the manager in the other. I would reload the log after loading a page and there would always be a new entry and it was always the same error.
Thanks for the help.