Hi,
I installed MODx on my site. Installation went Ok without any errors or warnings ,but when I tried to log into manager I got blank screen and this message in error log.
[2010-11-08 15:36:48] (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`, `modActionDom`.`for_parent` AS `modActionDom_for_parent` FROM `modx_actiondom` AS `modActionDom` LEFT JOIN `modx_access_actiondom` `Access` ON `modActionDom`.`id` = `Access`.`target` WHERE ( `modActionDom`.`action` = ? AND `modActionDom`.`active` = ? AND `modActionDom`.`for_parent` = ? 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
)
MODx:
2.0.4-pl2
Server:
Linux crown 2.6.31-19-server #56-Ubuntu SMP Thu Jan 28 03:40:48 UTC 2010 x86_64 GNU/Linux
Php:
PHP Version => 5.2.10-2ubuntu6.5
PDO support => enabled
PDO drivers => mysql
PDO Driver for MySQL, client library version => 5.1.37
Web server:
Server version: Apache/2.2.12 (Ubuntu)
MySql:
5.1.37-1ubuntu5.4
Any ideas?
MODX Staff