We have just completed an upgrade of SuiteCRM from 7.11 to 7.14.5, including upgrading Debian from Buster to Bookworm and MySql to the latest. I downgraded PHP to 8.2 to comply with the compatibility matrix.
The problem is that all users are forced into the Welcome wizard every time they log in, even though all their details are retained each time.
I thought the trigger for this might be something to do with the date/timezone as there was an issue in the downgrade of PHP where the sym link from php8.2 to php.default was not automatically done during the downgrade from 8.3 to 8.2. Thatās now fixed and the problem persists.
Could someone please tell me the trigger which causes the Welcome wizard to be invoked? Iām now thinking it is something in the MySql Users table.
I believe that behavior is controlled by the installer_locked value in config.php.
But if you ran the upgrade with a wrong PHP version, itās possible that it didnāt run correctly, and something was interrupted mid-way⦠in which case youāre probably better off restarting the process from scratch, to ensure consistency.
Yes, there were certainly inconsistencies in php version as the sym links to php.default and /etc/apache2/conf-enabled/php8.2-fpm.conf were not created when I ran a2dismod and a2enmod as well as update-alternatives. Iāve now written a script to handle a php upgrade or downgrade and get all the links correct - after the horse has bolted!
Iāll have a look at thye installer_locked value in config.php and hopefully, that fixes it, although I may end up running the silent upgrade again if it still isnāt right. Can upgrade wizard or silent upgrade be run over the top of a system that has previously been upgraded such as ours, or do I need to go back to the previous backup?
EDIT: installer_locked was set to true and setting it to false had no effect on the wizard, so still looking for suggestions!
Yes, upgraded sequentially as per instructions.
We do have a snapshot of the VM taken prior to embarking on the upgrade, but there has been 2 weeks of work since then, so Iāll have a go at an upgrade from here to 8.6 and see if that helps. If not, weāll go back to the snapshot. If nothing else, it will be a good dummy run for the upgrade to 8.6 as I see the upgrade methodology is quite different from previous upgrades.
+1 here, same issue, just upgraded to 7.14.5 and I get the new user welcome every time I login! I should mention, that Iām not sure if this starte exactly when I upgraded, or changed my PHP version from 7.4 to 8.1 (I kind of did both near the same time).
Hi all, just a little information,
I had this issue with some users, i realized it happens only to local user. if user credentials are LDAP authenticated, the problem disappears.
By setting back a user to local authentification, the issue is back.
I hope this piece of info is helpful.
Here we go with more details, for user without LDAP Auth
Mon Nov 25 21:51:38 2024 [2011][-none-][FATAL] SECURITY: ldapauth: failed LDAP bind (login) by XXXXXUSER, could not construct bind_user
Mon Nov 25 21:51:38 2024 [2011][-none-][FATAL] SECURITY: User authentication for XXXXXUSER failed
Mon Nov 25 21:51:44 2024 [2933][e802650b-2ca9-4fbb-0c6f-617a39a1f6eb][ERROR] Invalid Referrer: expected the Save action to be called from the Userās Profile Edit View this is the user ID in database
Mon Nov 25 21:51:44 2024 [2933][e802650b-2ca9-4fbb-0c6f-617a39a1f6eb][FATAL] Email address save error
Mon Nov 25 21:51:53 2024 [2933][e802650b-2ca9-4fbb-0c6f-617a39a1f6eb][ERROR] error: no ieID
Mon Nov 25 21:51:54 2024 [2933][e802650b-2ca9-4fbb-0c6f-617a39a1f6eb][ERROR] SugarFolder::retrieveFoldersForProcessing() Cannot Retrieve Folders - Please check the users inbound email settings.
I am not an expert, what I can see even if the user is set for non LDAP Auth, suiteCRM is checking LDAP then a fall back is for local user.
Thanks for the insight! If doesnāt happen to me every login. But, I frequently re-save my user profile because my google sync keeps getting unchecked. I bet, there is an issue with the save of the user record that sets this back to zero. Iāll have to test that!
Iām currently using SuiteCRM Version 7.14.5 and couldnāt find any field like welcome_screen or anything similar in the users or user_preferences tables. Similarly, I checked the config table, but thereās no suitecrm_version field there either.
Could you clarify if youāre referring to SuiteCRM Version 8?
To double-check, Iāll spin up a fresh VM and reinstall Version 7.14.5 to see if I can replicate the issue or if my database schema might be corrupted. For context, this was a clean install.
I have found where the welcome wizard is invoked.
In /var/www/html/modules/Users/ChangePassword.php the value of āutā is obtained and the wizard is invoked if āutā is empty.