Cant login to manager

Currently runnning 2.64

none of the users can login, this occurred after the site was compromised.

We have restored back to 11 July 2018, still the same

I tried running the well know API script for changing the user password, it returns "user not found"

If I try "Forgot your login" on the manager page, I get the same result: "User not found with that email or username. Please try again."

I have tried with several user credentials, all with the same results.

There are a lot of continual errors in the log happening:

[2018-07-26 08:09:16] (ERROR @ /index.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ? -
[2018-07-26 08:09:16] (ERROR in xPDOConnection::connect @ /home/sites/XXXXX.com/public_html/core/xpdo/xpdo.class.php : 3043) SQLSTATE[HY000] [1045] Access denied for user 'cl30-jp17-YYY'@'10.0.44.131' (using password: YES)
[2018-07-26 08:09:16] (ERROR in xPDOConnection::connect @ /home/sites/XXXXX.com/public_html/core/xpdo/xpdo.class.php : 3043) SQLSTATE[HY000] [1045] Access denied for user 'cl30-jp17-YYY'@'10.0.44.131' (using password: YES)

Any help would be appreciated.

Did you change password to your database?
It seems there are problems with DB connection...
Do you have access to MODX files?
Please check all credentials from core/config/config.inc.php are actual (user,db,host,pass)
Do you have any other errors at core/cache/logs/error.log?

Well, current users list can be checked roughly via Database tables, do you have an access?

It could also be a problem with sessions. MODX passes the entered password in a _$SESSION variable.

One cause of that could be if your .htaccess file used to rewrite URLs -- www to non-www or vice versa, but no longer does. If a user comes in on one and gets switched to the other, the session (and the entered password) will be lost.

Quote from: himurovi4 at Jul 26, 2018, 09:09 AM

Did you change password to your database?
It seems there are problems with DB connection...
Do you have access to MODX files?
Please check all credentials from core/config/config.inc.php are actual (user,db,host,pass)
Do you have any other errors at core/cache/logs/error.log?

Well, current users list can be checked roughly via Database tables, do you have an access?

I have FPT access and I can see the SQL tables.
I have checked the config files it the credentials are fine
I have executed the following UPDATE modx_users SET hash_class = 'hashing.modMD5', password = MD5('password') WHERE username = 'uname';
This returns 1 row affected.
Sometimes I can login for one session, but after I logout I cant login again.

On one of the occasions whenI did get logged in I was able to install the upgrade plugin:
When I ran the plugin it errored with Fatal Error: Make sure you PHP session is valid and working

Here are some of the latest entries.
[2018-07-27 12:37:11] (ERROR in resource 1011 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 12:39:22] (ERROR in resource 165 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 12:40:09] (ERROR in resource 26 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 12:40:26] (ERROR in resource 233 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 12:40:45] (ERROR in resource 210 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 12:40:49] (ERROR in resource 55 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 12:42:31] (ERROR in resource 106 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 12:45:23] (ERROR in resource 268 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 12:49:09] (ERROR in resource 1065 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 12:50:16] (ERROR in resource 952 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 12:52:40] (ERROR in resource 288 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 13:07:58] (ERROR in resource 1062 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 13:09:49] (ERROR in resource 25 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 13:10:23] (ERROR in resource 247 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 13:14:40] (ERROR in resource 1055 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 13:14:53] (ERROR in resource 160 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~160? &scheme=`http`]]` encountered
[2018-07-27 13:14:53] (ERROR in resource 160 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~160]]` encountered
[2018-07-27 13:14:54] (ERROR in resource 160 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 13:14:54] (ERROR in resource 160 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~160]]` encountered
[2018-07-27 13:14:54] (ERROR in resource 160 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~160]]` encountered
[2018-07-27 13:14:54] (ERROR in resource 160 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~160]]` encountered
[2018-07-27 13:14:54] (ERROR in resource 160 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~160]]` encountered
[2018-07-27 13:14:54] (ERROR in resource 160 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~160]]` encountered
[2018-07-27 13:15:23] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:15:23] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 543) Error 42S22 executing 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`, `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_users` AS `modUser` LEFT JOIN `modx_user_attributes` `Profile` ON `modUser`.`id` = `Profile`.`internalKey` LEFT JOIN `modx_user_settings` `UserSettings` ON `modUser`.`id` = `UserSettings`.`user` WHERE `modUser`.`username` = ? ORDER BY `modUser`.`id` ASC - Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:17:19] (ERROR in resource 1058 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 13:17:38] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:17:38] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 543) Error 42S22 executing 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`, `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_users` AS `modUser` LEFT JOIN `modx_user_attributes` `Profile` ON `modUser`.`id` = `Profile`.`internalKey` LEFT JOIN `modx_user_settings` `UserSettings` ON `modUser`.`id` = `UserSettings`.`user` WHERE `modUser`.`username` = ? ORDER BY `modUser`.`id` ASC - Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:17:50] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:17:51] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 543) Error 42S22 executing 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`, `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_users` AS `modUser` LEFT JOIN `modx_user_attributes` `Profile` ON `modUser`.`id` = `Profile`.`internalKey` LEFT JOIN `modx_user_settings` `UserSettings` ON `modUser`.`id` = `UserSettings`.`user` WHERE `modUser`.`username` = ? ORDER BY `modUser`.`id` ASC - Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:18:31] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:18:31] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 543) Error 42S22 executing 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`, `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_users` AS `modUser` LEFT JOIN `modx_user_attributes` `Profile` ON `modUser`.`id` = `Profile`.`internalKey` LEFT JOIN `modx_user_settings` `UserSettings` ON `modUser`.`id` = `UserSettings`.`user` WHERE `modUser`.`username` = ? ORDER BY `modUser`.`id` ASC - Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:18:39] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:18:39] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 543) Error 42S22 executing 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`, `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_users` AS `modUser` LEFT JOIN `modx_user_attributes` `Profile` ON `modUser`.`id` = `Profile`.`internalKey` LEFT JOIN `modx_user_settings` `UserSettings` ON `modUser`.`id` = `UserSettings`.`user` WHERE `modUser`.`username` = ? ORDER BY `modUser`.`id` ASC - Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:19:30] (ERROR in resource 43 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 13:20:16] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 240) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:20:16] (ERROR @ /home/sites/XXXXXXX.com/public_html/core/xpdo/om/xpdoobject.class.php : 543) Error 42S22 executing 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`, `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_users` AS `modUser` LEFT JOIN `modx_user_attributes` `Profile` ON `modUser`.`id` = `Profile`.`internalKey` LEFT JOIN `modx_user_settings` `UserSettings` ON `modUser`.`id` = `UserSettings`.`user` WHERE `modUser`.`username` = ? ORDER BY `modUser`.`id` ASC - Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modUser.createdon' in 'field list'
)

[2018-07-27 13:24:02] (ERROR in resource 240 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered
[2018-07-27 13:26:05] (ERROR in resource 16 @ /home/sites/XXXXXXX.com/public_html/core/model/modx/modparser.class.php : 1372) Bad link tag `[[~21]]` encountered

Quote from: BobRay at Jul 26, 2018, 11:35 PM

It could also be a problem with sessions. MODX passes the entered password in a _$SESSION variable.

One cause of that could be if your .htaccess file used to rewrite URLs -- www to non-www or vice versa, but no longer does. If a user comes in on one and gets switched to the other, the session (and the entered password) will be lost.

Thanks for your input.

I am not aware of any changes to the .htaccess, at the moment. It is just me trying to get access, so I get to control the url entry point.

I responded to Himurovich with some more info that might be of help.

Sorry, I should have mentioned that the answer to the modUser errors is here: https://bobsguides.com/blog.html/2016/06/27/missing-db-fields-(unknown-column)/

Quote from: BobRay at Jul 27, 2018, 09:45 PM

Sorry, I should have mentioned that the answer to the modUser errors is here: https://bobsguides.com/blog.html/2016/06/27/missing-db-fields-(unknown-column)/

Hi
Thanks that makes a lot of sense, I will try and restore and see if I can upgrade, in easy steps.

Interestingly we were getting an error upgrading using the UpgradeModx plugin, I have tracked a solution down.

The problem was Make Sure your PHP session is valid and working.
The fix is to add a line immediately above the session loop-back tester comment, it sets the variable.

I am not sure if this is the best solution but it worked.

$_SESSION['session_test']= 1;

/* session loop-back tester */

Good catch. That's not really an UpgradeMODX issue, though. It's part of the MODX setup script, which is launched at the end of UpgradeMODX.

Normally, failing that test would indicate a problem with sessions that would prevent logging in to the Manager. I don't know how it could have worked for you (unless it was a temporary sessions problem that went away), but I'm glad you got things sorted.

Quote from: BobRay at Jul 27, 2018, 09:45 PM

Sorry, I should have mentioned that the answer to the modUser errors is here: https://bobsguides.com/blog.html/2016/06/27/missing-db-fields-(unknown-column)/

@bob : I am also getting a similar error in the error log, and log file becomes 500+mb within just a couple hours (2-3).



Can I use the same solution for this problem mentioned in "missing-db-fields-(unknown-column)"?

@amipatil It can't hurt and might solve the problem.