We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 43692
    • 15 Posts
    Hello, guys!
    I have moved our project on MODX Revo, we are happy. All pages, site functions are working, but in MODX manager error.log i always find it:

    [2013-07-29 00:42:50] (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`.`constraint_class`, `FCSet`.`constraint_field`, `FCSet`.`constraint`, `FCSet`.`template` FROM `actiondom` AS `modActionDom` JOIN `fc_sets` `FCSet` ON `modActionDom`.`set` =  `FCSet`.`id` JOIN `fc_profiles` `Profile` ON FCSet.profile = Profile.id LEFT JOIN `fc_profiles_usergroups` `ProfileUserGroup` ON Profile.id = ProfileUserGroup.profile LEFT JOIN `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
    )
    


    and this
    
    [2013-07-28 18:22:13] (ERROR @ /index.php) Error HY000 executing statement: 
    Array
    (
        [0] => HY000
        [1] => 1615
        [2] => Prepared statement needs to be re-prepared
    )
    
    [2013-07-28 18:22:13] (ERROR @ /index.php) Error HY000 executing query: SELECT `modChunk`.`id` AS `modChunk_id`, `modChunk`.`source` AS `modChunk_source`, `modChunk`.`property_preprocess` AS `modChunk_property_preprocess`, `modChunk`.`name` AS `modChunk_name`, `modChunk`.`description` AS `modChunk_description`, `modChunk`.`editor_type` AS `modChunk_editor_type`, `modChunk`.`category` AS `modChunk_category`, `modChunk`.`cache_type` AS `modChunk_cache_type`, `modChunk`.`snippet` AS `modChunk_snippet`, `modChunk`.`locked` AS `modChunk_locked`, `modChunk`.`properties` AS `modChunk_properties`, `modChunk`.`static` AS `modChunk_static`, `modChunk`.`static_file` AS `modChunk_static_file`, `Source`.`id` AS `Source_id`, `Source`.`name` AS `Source_name`, `Source`.`description` AS `Source_description`, `Source`.`class_key` AS `Source_class_key`, `Source`.`properties` AS `Source_properties`, `Source`.`is_stream` AS `Source_is_stream` FROM `site_htmlsnippets` AS `modChunk` LEFT JOIN `media_sources` `Source` ON `modChunk`.`source` = `Source`.`id` WHERE `modChunk`.`name` = ? ORDER BY `modChunk`.`id` ASC  - Array
    (
        [0] => HY000
        [1] => 1615
        [2] => Prepared statement needs to be re-prepared
    )
    
    [2013-07-28 18:22:13] (ERROR @ /index.php) [Notify404] Error: empty message. Most likely the Notify404 template chunk does not exist or hasn't been set.
    [2013-07-28 18:22:13] (ERROR @ /index.php) Error HY000 executing statement: 
    Array
    (
        [0] => HY000
        [1] => 1615
        [2] => Prepared statement needs to be re-prepared
    )
    
    [2013-07-28 18:22:13] (ERROR @ /index.php) Error HY000 executing statement:
    INSERT INTO `session` (`id`, `access`, `data`) VALUES ('72e1a96cf16db9e734365a3991da80aa', 1375021333, 'modx.user.contextTokens|a:0:{}')
    Array
    (
        [0] => HY000
        [1] => 1615
        [2] => Prepared statement needs to be re-prepared
    )
    
    [2013-07-28 19:47:11] (ERROR @ /index.php) Error HY000 executing statement: 
    Array
    (
        [0] => HY000
        [1] => 1615
        [2] => Prepared statement needs to be re-prepared
    )
    
    
    


    Could you help me find the problem? ( i suggest that 2 problems here. )
    In what direction moving?
      • 1343 ☆ A M B ☆
      • 2,213 Posts
      Hello,

      Could you tell us more about your hosting environment and what extras you have installed?
        Patrick | Server Wrangler
        About Me: Website | Tweets |  MODX Hosting