We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 38830
    • 1 Posts
    Hi All,

    I just installed a clean new version of MODX Revolution 2.2.0-pl2. but I don't see "Home" listed in "Resources Tree"(please see attached screenshot).

    I didn't see errors in firebug but I saw the following mysql syntax error in /cache/logs/error.log:
    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
    )
    


    Here's my system info:
    system: Linux x86_64
    web server: apache 2
    mysql: 5.5.21
    PHP: 5.2.17-0.dotdeb.0

    Thanks in advance!

    J