I’m in the process of trying to upgrade an old installation to a current version (most recent 7 or 8). When I did 7.7 to 7.8 update from the update wizard web page, I immediately got a ‘You have been logged out because your session has expired’ and any attempts to login now fail with that and ‘You must specify a valid username and password.’
This is true for users or admin logins. I’m using a password manager so passwords haven’t changed. Also, I tried different browsers/ff containers. The browser cache should not be a issue.
The pertinent sugarcrm log error looks to be:
Thu Dec 8 23:01:51 2022 [2643684][-none-][FATAL] SECURITY: User authentication for mikeb failed
Thu Dec 8 23:01:51 2022 [2643684][-none-][FATAL] FAILED LOGIN:attempts[1] - mikeb
While accurate, it doesn’t really add much. I also got this from the apache logs. It looks to be related but it’s unclear to me if it’s the cause and what the fix would be if so.
[:error] [pid 2643684] [client ip addr] PHP Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, string given in /htdocs/include/database/MysqlManager.php on line 463, referer: no-links-for-me /index.php?action=Login&module=Users
[:error] [pid 2643684] [client ip addr] PHP Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in /htdocs/include/database/MysqlManager.php on line 463, referer: no-links-for-me /index.php?action=Login&module=Users
[:error] [pid 2643684] [client ip addr] PHP Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, string given in /htdocs/include/database/MysqlManager.php on line 463, referer: no-links-for-me /index.php?action=Login&module=Users
If anyone has a suggestion, it would be appreciated, thanks!