We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 38869
    • 6 Posts
    I have an error appearing in the logs, which seems to be why I cant see any resources in the resource tree under why contexts. Upgraded from 2.1.5 to 2.2.0.

    (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','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28') 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
    )
      • 38869
      • 6 Posts
      Anyone?
        • 22303 MODX Staff
        • 10,725 Posts
        Sounds like the upgrade was not successful. Did you use the advanced package?
          • 38869
          • 6 Posts
          Didn't use the advanced package. What is your suggestion, try to run the install script again?
            • 38869
            • 6 Posts
            Ran the install script again. Problem still exists.

            I have attached the error log. This is after clearing the error log and loading the manager.
              • 41945
              • 13 Posts
              Anyone ?
                • 41945
                • 13 Posts
                Anyone ?
                  • 28042 ☆ A M B ☆
                  • 24,524 Posts
                  What version of MySQL are you using?
                    Studying MODX in the desert - http://sottwell.com
                    Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                    Join the Slack Community - http://modx.org
                    • 41945
                    • 13 Posts
                    mySql - 5.0.45-log

                    PHP - 5.2.11

                    I have 3 others revo sites on this server, its work properly.
                      • 41945
                      • 13 Posts
                      Anyone ?