SQL error

[modxbot]

cghcab created Redmine issue ID 7556

I can't see the web tree. It doesn't seem to be related to security.

The error log reports :

[2012-04-05 17:23:42](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') 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 )

Thanks for help.

[MarkH]

markh submitted:

Is this an update or fresh install?

If you check Security > Users and edit your own user, do you see any user groups there?

[modxbot]

cghcab submitted:

It is a fresh install modx-2.2-pl2. I'm the only user : group Administrator role SupeUser 179/179 permissions.