B
B
bossigorxxx2019-10-24 15:40:35
MODX
bossigorxxx, 2019-10-24 15:40:35

How to get into the modx revo admin panel?

Help) I can not get into the admin panel. Changed the password. Changed email, reset sessions in the database, reset the retry block. Climbed into the log and there it is. I don't understand anything. Where to dig? File xpdo.class.php replaced

[2019-10-24 12:34:12] (ERROR @ /home/u254632187/public_html/core/xpdo/om/xpdoobject.class.php : 263) Error preparing statement for query: SELECT `modUser`.`id` AS `modUser_id`, `modUser`.`username` AS `modUser_username`, `modUser`.`password` AS `modUser_password`, `modUser`.`cachepwd` AS `modUser_cachepwd`, `modUser`.`class_key` AS `modUser_class_key`, `modUser`.`active` AS `modUser_active`, `modUser`.`remote_key` AS `modUser_remote_key`, `modUser`.`remote_data` AS `modUser_remote_data`, `modUser`.`hash_class` AS `modUser_hash_class`, `modUser`.`salt` AS `modUser_salt`, `modUser`.`primary_group` AS `modUser_primary_group`, `modUser`.`session_stale` AS `modUser_session_stale`, `modUser`.`sudo` AS `modUser_sudo`, `modUser`.`createdon` AS `modUser_createdon` FROM `modx_optm_users` AS `modUser` WHERE `modUser`.`username` = ?  - 
[2019-10-24 12:34:12] (ERROR in xPDOConnection::connect @ /home/u254632187/public_html/core/xpdo/xpdo.class.php : 3119) SQLSTATE[28000] [1045] Access denied for user 'u254632187_optm'@'10.1.2.44' (using password: YES)
[2019-10-24 12:34:12] (ERROR @ /home/u254632187/public_html/core/xpdo/om/xpdoquery.class.php : 637) Could not construct or prepare query because it is invalid or could not connect: SELECT `modUser`.`id` AS `modUser_id`, `modUser`.`username` AS `modUser_username`, `modUser`.`password` AS `modUser_password`, `modUser`.`cachepwd` AS `modUser_cachepwd`, `modUser`.`class_key` AS `modUser_class_key`, `modUser`.`active` AS `modUser_active`, `modUser`.`remote_key` AS `modUser_remote_key`, `modUser`.`remote_data` AS `modUser_remote_data`, `modUser`.`hash_class` AS `modUser_hash_class`, `modUser`.`salt` AS `modUser_salt`, `modUser`.`primary_group` AS `modUser_primary_group`, `modUser`.`session_stale` AS `modUser_session_stale`, `modUser`.`sudo` AS `modUser_sudo`, `modUser`.`createdon` AS `modUser_createdon`, `Profile`.`id` AS `Profile_id`, `Profile`.`internalKey` AS `Profile_internalKey`, `Profile`.`fullname` AS `Profile_fullname`, `Profile`.`email` AS `Profile_email`, `Profile`.`phone` AS `Profile_phone`, `Profile`.`mobilephone` AS `Profile_mobilephone`, `Profile`.`blocked` AS `Profile_blocked`, `Profile`.`blockeduntil` AS `Profile_blockeduntil`, `Profile`.`blockedafter` AS `Profile_blockedafter`, `Profile`.`logincount` AS `Profile_logincount`, `Profile`.`lastlogin` AS `Profile_lastlogin`, `Profile`.`thislogin` AS `Profile_thislogin`, `Profile`.`failedlogincount` AS `Profile_failedlogincount`, `Profile`.`sessionid` AS `Profile_sessionid`, `Profile`.`dob` AS `Profile_dob`, `Profile`.`gender` AS `Profile_gender`, `Profile`.`address` AS `Profile_address`, `Profile`.`country` AS `Profile_country`, `Profile`.`city` AS `Profile_city`, `Profile`.`state` AS `Profile_state`, `Profile`.`zip` AS `Profile_zip`, `Profile`.`fax` AS `Profile_fax`, `Profile`.`photo` AS `Profile_photo`, `Profile`.`comment` AS `Profile_comment`, `Profile`.`website` AS `Profile_website`, `Profile`.`extended` AS `Profile_extended`, `UserSettings`.`user` AS `UserSettings_user`, `UserSettings`.`key` AS `UserSettings_key`, `UserSettings`.`value` AS `UserSettings_value`, `UserSettings`.`xtype` AS `UserSettings_xtype`, `UserSettings`.`namespace` AS `UserSettings_namespace`, `UserSettings`.`area` AS `UserSettings_area`, `UserSettings`.`editedon` AS `UserSettings_editedon` FROM `modx_optm_users` AS `modUser` LEFT JOIN `modx_optm_user_attributes` `Profile` ON `modUser`.`id` = `Profile`.`internalKey` LEFT JOIN `modx_optm_user_settings` `UserSettings` ON `modUser`.`id` = `UserSettings`.`user` WHERE `modUser`.`username` = ? ORDER BY `modUser`.`id` ASC 
[2019-10-24 12:34:12] (ERROR in xPDOConnection::connect @ /home/u254632187/public_html/core/xpdo/xpdo.class.php : 3119) SQLSTATE[28000] [1045] Access denied for user 'u254632187_optm'@'10.1.2.44' (using password: YES)
[2019-10-24 12:34:12] (ERROR in xPDOConnection::connect @ /home/u254632187/public_html/core/xpdo/xpdo.class.php : 3119) SQLSTATE[28000] [1045] Access denied for user 'u254632187_optm'@'10.1.2.44' (using password: YES)
[2019-10-24 12:34:12] (ERROR @ /home/u254632187/public_html/core/xpdo/om/xpdoobject.class.php : 546) Error  preparing statement: SELECT `modUser`.`id` AS `modUser_id`, `modUser`.`username` AS `modUser_username`, `modUser`.`password` AS `modUser_password`, `modUser`.`cachepwd` AS `modUser_cachepwd`, `modUser`.`class_key` AS `modUser_class_key`, `modUser`.`active` AS `modUser_active`, `modUser`.`remote_key` AS `modUser_remote_key`, `modUser`.`remote_data` AS `modUser_remote_data`, `modUser`.`hash_class` AS `modUser_hash_class`, `modUser`.`salt` AS `modUser_salt`, `modUser`.`primary_group` AS `modUser_primary_group`, `modUser`.`session_stale` AS `modUser_session_stale`, `modUser`.`sudo` AS `modUser_sudo`, `modUser`.`createdon` AS `modUser_createdon`, `Profile`.`id` AS `Profile_id`, `Profile`.`internalKey` AS `Profile_internalKey`, `Profile`.`fullname` AS `Profile_fullname`, `Profile`.`email` AS `Profile_email`, `Profile`.`phone` AS `Profile_phone`, `Profile`.`mobilephone` AS `Profile_mobilephone`, `Profile`.`blocked` AS `Profile_blocked`, `Profile`.`blockeduntil` AS `Profile_blockeduntil`, `Profile`.`blockedafter` AS `Profile_blockedafter`, `Profile`.`logincount` AS `Profile_logincount`, `Profile`.`lastlogin` AS `Profile_lastlogin`, `Profile`.`thislogin` AS `Profile_thislogin`, `Profile`.`failedlogincount` AS `Profile_failedlogincount`, `Profile`.`sessionid` AS `Profile_sessionid`, `Profile`.`dob` AS `Profile_dob`, `Profile`.`gender` AS `Profile_gender`, `Profile`.`address` AS `Profile_address`, `Profile`.`country` AS `Profile_country`, `Profile`.`city` AS `Profile_city`, `Profile`.`state` AS `Profile_state`, `Profile`.`zip` AS `Profile_zip`, `Profile`.`fax` AS `Profile_fax`, `Profile`.`photo` AS `Profile_photo`, `Profile`.`comment` AS `Profile_comment`, `Profile`.`website` AS `Profile_website`, `Profile`.`extended` AS `Profile_extended`, `UserSettings`.`user` AS `UserSettings_user`, `UserSettings`.`key` AS `UserSettings_key`, `UserSettings`.`value` AS `UserSettings_value`, `UserSettings`.`xtype` AS `UserSettings_xtype`, `UserSettings`.`namespace` AS `UserSettings_namespace`, `UserSettings`.`area` AS `UserSettings_area`, `UserSettings`.`editedon` AS `UserSettings_editedon` FROM `modx_optm_users` AS `modUser` LEFT JOIN `modx_optm_user_attributes` `Profile` ON `modUser`.`id` = `Profile`.`internalKey` LEFT JOIN `modx_optm_user_settings` `UserSettings` ON `modUser`.`id` = `UserSettings`.`user` WHERE `modUser`.`username` = ? ORDER BY `modUser`.`id` ASC  - 
[2019-10-24 12:34:12] (ERROR in xPDOConnection::connect @ /home/u254632187/public_html/core/xpdo/xpdo.class.php : 3119) SQLSTATE[28000] [1045] Access denied for user 'u254632187_optm'@'10.1.2.44' (using password: YES)
[2019-10-24 12:34:12] (ERROR @ /home/u254632187/public_html/core/xpdo/om/xpdoquery.class.php : 637) Could not construct or prepare query because it is invalid or could not connect: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_optm_session` AS `modSession` WHERE `modSession`.`id` = ? 
[2019-10-24 12:34:12] (ERROR in xPDOConnection::connect @ /home/u254632187/public_html/core/xpdo/xpdo.class.php : 3119) SQLSTATE[28000] [1045] Access denied for user 'u254632187_optm'@'10.1.2.44' (using password: YES)
[2019-10-24 12:34:12] (ERROR @ /home/u254632187/public_html/core/xpdo/om/xpdoobject.class.php : 263) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_optm_session` AS `modSession` WHERE `modSession`.`id` = ?  - 
[2019-10-24 12:34:12] (ERROR in xPDOConnection::connect @ /home/u254632187/public_html/core/xpdo/xpdo.class.php : 3119) SQLSTATE[28000] [1045] Access denied for user 'u254632187_optm'@'10.1.2.44' (using password: YES)
[2019-10-24 12:34:12] (ERROR in xPDOConnection::connect @ /home/u254632187/public_html/core/xpdo/xpdo.class.php : 3119) SQLSTATE[28000] [1045] Access denied for user 'u254632187_optm'@'10.1.2.44' (using password: YES)

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Sanes, 2019-10-24
@bossigorxxx

Check your MySQL connection settings.

V
Vladislav Lyskov, 2019-10-24
@Vlatqa

delete core/cache folder

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question