We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 40683
    • 4 Posts
    Resource tree doesn't appear after moving to host.

    I get an error at the error log:
    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

    This question has been answered by ivan_sobaka. See the first response.

    • discuss.answer
      • 40683
      • 4 Posts
      that was because of php version.

      I swithed it to php 5.3 it it is works now!
        • 41945
        • 13 Posts
        I have this problem. There are no possibility change php from 5.2.11 to 5.3.

        Help me solve it any way.

        I tried to install Revo 2.2.2, 2.2.5, 2.2.6 to clean system or upgrade, but always have :
        (ERROR @ /manage/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`.`constraint_class`, `FCSet`.`constraint_field`, `FCSet`.`constraint`, `FCSet`.`template` FROM `2w_actiondom` AS `modActionDom` JOIN `2w_fc_sets` `FCSet` ON `modActionDom`.`set` =  `FCSet`.`id` JOIN `2w_fc_profiles` `Profile` ON FCSet.profile = Profile.id LEFT JOIN `2w_fc_profiles_usergroups` `ProfileUserGroup` ON Profile.id = ProfileUserGroup.profile LEFT JOIN `2w_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

        )
          • 41945
          • 13 Posts
          More errors :
          [2012-11-03 10:07:33] (ERROR @ /connectors/resource/index.php) Error preparing statement for query: SELECT modAccessContext.id, modAccessContext.target, modAccessContext.principal, modAccessContext.authority, modAccessContext.policy, Policy.data FROM `2w_access_context` AS `modAccessContext` LEFT JOIN `2w_access_policies` `Policy` ON `modAccessContext`.`policy` =  `Policy`.`id` WHERE  ( `modAccessContext`.`principal_class` = ? AND `modAccessContext`.`target` = ? )  ORDER BY modAccessContext.target,modAccessContext.principal,modAccessContext.authority,modAccessContext.policy ASC  - Array
          (
              [0] => HY000
              [1] => 2014
              [2] => Cannot execute queries while other unbuffered queries are active.  Consider using PDOStatement::fetchAll().  Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
          )
            • 41945
            • 13 Posts
            [2012-11-03 12:43:04] (ERROR @ /connectors/resource/index.php) Error 00000 executing statement:
            Array
            (
            [0] => 00000
            )
              • 41945
              • 13 Posts
              After running setup I has :
              Error update table for class modResource
              Array
              (
              [0] => 42000
              [1] => 1061
              [2] => Duplicate key name 'cache_refresh_idx'
              )

                • 41945
                • 13 Posts
                Anyone ?
                  • 10208 ☆ A M B ☆
                  • 1,780 Posts
                  Still? Any other issues or errors? I can't help but I'm hoping the bump will help.
                    Frogabog- MODX Websites in Portland Oregon
                    "Do yourself a favor and get a copy of "MODX - The Official Guide" by Bob Ray. Read it.
                    Having server issues? These guys have MODX Hosting perfected - SkyToaster
                    • 41945
                    • 13 Posts
                      • 10208 ☆ A M B ☆
                      • 1,780 Posts
                      I'm sorry, not sure what it means that you linked back to this thread.
                        Frogabog- MODX Websites in Portland Oregon
                        "Do yourself a favor and get a copy of "MODX - The Official Guide" by Bob Ray. Read it.
                        Having server issues? These guys have MODX Hosting perfected - SkyToaster