Login issue after upgrading from Version 8.7.1 to 8.8.0

📦 Install & Upgrade Help
1

After upgrading to 8.8 version from 8.7.1 I am not able to login into the crm…
It only says: login credentials incorrect.
I tried changing the password via the database, by submitting a SQL query, by restoring the database from an earlier backup, etc.
Here my login error page: Screenshot-2025-02-03-195308 hosted at ImgBB — ImgBB

2

I had a similar issue on our instance after the upgrade.

In my case it turned out that a previous database migration which added the TOTP fields to the user table (SuiteCRM-Core/core/backend/Migrations/Version20241001074858.php at 9df984eccd7c0beebcd089a3c16b469fd089cf88 · salesagility/SuiteCRM-Core · GitHub) had failed.
If this is also the case on your end you should find messages about missing column totp_secret in one of the logs.

I tried to manually add the three new columns but got an error about the row size being too large. So I first had to change the row format to “Dynamic” for the user table and finally was able to add the three new columns.

After that, I was able to log in successfully again.

1 Like
3

Thanks, I tryed but it is not my case…

4

I upgraded 7 to 8.6.1 to 8.8.0: Login credentials incorrect.

  • tail -f public/legacy/suitecrm.log i found totp_secret is missing in table users;
  • ALTER TABLE users ADD COLUMN totp_secret VARCHAR(255) NULL;
  • php bin/console doctrine:schema:validate
  • php bin/console doctrine:schema:update --force

Login works!

3 Likes
5

For those who are not lucky with @sasotech solution, in my case, I also needed to add this two:

  • ALTER TABLE users ADD COLUMN is_totp_enabled TINYINT(1) DEFAULT 0;
  • ALTER TABLE users ADD COLUMN backup_codes TEXT NULL;

I did not need to run bin/console commands for doctrine in order to be able to login. But I thought I should execute it, so I tryed it, getting an error on first one: [ERROR] The database schema is not in sync with the current mapping file.
Second command was fine, but, after that I retryed firstone, with the same result.

Thanks for your help.

1 Like
6

I tried the steps you suggested, but they are not working for me, and no log is being generated in the suitecrm.log file.

7

If no log is being generated in suitecrm.log, make sure the log level is set to debug in config.php:

Also, check other possible log locations depending on your setup:

  • public/legacy/suitecrm.log

  • logs/prod/prod.log (Symfony logs)

  • Your web server or PHP error logs

8

@sasotech I checked every log file, but no logs are being generated in the logs directory.

9

Hello Abhishek,

can you check, whether you’ve got those missing columns in your DB table now?
Did you change anything around your DB version?
Do you use any special characters in your password?
Is any user able to login or are all not able anymore?
Can you try to install a 2nd SuiteCRM instance and copy the table record of the working admin user over to your current SuiteCRM to login an update passwords of your users?