Community

Can't log in to manager after Revo 2.6.5 upgrade

Hi all! I am in trouble and hope you could help me. I can’t log in to the manager after upgrading websites to Revo 2.6.5. It’s been a while now, but these are rarely updated sites. Anyway, the problem came up finally and I need to fix it. I tried everything as described here: https://bobsguides.com/blog.html/2014/01/02/locked-out-getting-back-into-the-modx-manager/
Including the “ugly method” - no luck. I also tried copying all user data from another website of mine that opens fine. No luck. Each time a submit login info the page reloads displaying empty login form (no error messages).
I noticed that sites in problem have modx_users > createdon = 0. So I copied that info from another modx installation too. Doesn’t help. I wonder what else can be done or what am I missing? Thank you.

1 Like

What version of MODX were you upgrading from?

2 Likes

MODX version and PHP version pls, it matters

1 Like

Version you upgraded from?

Also, what’s in the MODX error log: core/cache/logs/error.log

1 Like

Oh, sorry, I don’t remember which MODX versions were used previously. But let’s assume the sites haven’t been upgraded for two years at least. It is php 7.2

The error log is mysterious to me. It is some 200kb. All errors are dated 3-4/7/2019. The last comes from 20 mins ago. There are 314 instances of the same error:

[2019-07-04 04:20:15] (ERROR @ /homepages/5/d329033657/htdocs/leo/core/xpdo/om/xpdoobject.class.php : 1452) Error 42000 executing statement:
INSERT INTO `leo_session` (`id`, `access`, `data`) VALUES ('93226788e888d4edea68886c076371b7', 1562228415, 'modx.user.0.resourceGroups|a:1:{s:3:\"web\";a:0:{}}modx.user.0.attributes|a:1:{s:3:\"web\";a:5:{s:16:\"modAccessContext\";a:1:{s:3:\"web\";a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}}s:22:\"modAccessResourceGroup\";a:0:{}s:17:\"modAccessCategory\";a:0:{}s:28:\"sources.modAccessMediaSource\";a:0:{}s:18:\"modAccessNamespace\";a:0:{}}}modx.user.contextTokens|a:0:{}')
Array
(
    [0] => 42000
    [1] => 1142
    [2] => INSERT command denied to user 'dbo357885009'@'74.208.57.236' for table 'leo_session'
)

or more common pattern:

[2019-07-04 04:16:03] (ERROR @ /homepages/5/d329033657/htdocs/leo/core/xpdo/om/xpdoobject.class.php : 1452) Error 42000 executing statement:
INSERT INTO `leo_session` (`id`, `access`, `data`) VALUES ('cdd4944b7a30b3732dfe402bb39e8128', 1562228163, '')
Array
(
    [0] => 42000
    [1] => 1142
    [2] => INSERT command denied to user 'dbo357885009'@'74.208.57.236' for table 'leo_session'
)

I wonder what does it mean.

That means the database user you’re connecting with does not have INSERT permission; meaning it can’t write data into the database which is needed for normal functioning.

1 Like

Oh, my apology. The issue has been resolved and it had nothing to do with MODX, of course! I ran of free space in my database. It’s tricky, I can create an unlimited number of dbs on my shared hosting account and I created a bunch - each containing 5-6 MODX websites. For some reason, some dbs are given 1000 MB while others just 100 MB. This one contained several websites and was full. I moved half of the content to other databases (each site has its table prefix), changed db connections in config files as necessary, and all started to work just fine.
bobray, thanks for a hint about error log. It helped me indirectly.
markh - exactly!

1 Like