When a user submits the registration request a 500 error is thrown. Here is the error from the php log:

Error thrown in /var/www/support.tier2tickets.com/public_html/include/class.mailer.php on line 603
[11-Aug-2020 18:28:42 UTC] PHP Fatal error: Uncaught InconsistentModelException: Unable to prepare query: DELETE ost_session.* FROM ost_session WHERE ost_session.user_id = 0 AND ost_session.session_data REGEXP '_auth\|.*\"user\";[a-z]+:[0-9]+:{[a-z]+:[0-9]+:\"id\";[a-z]+:3' in /var/www/support.tier2tickets.com/public_html/include/class.orm.php:3465
Stack trace:
#0 /var/www/support.tier2tickets.com/public_html/include/class.orm.php(1528): MySqlExecutor->execute()
#1 /var/www/support.tier2tickets.com/public_html/include/class.auth.php(1344): QuerySet->delete()
#2 /var/www/support.tier2tickets.com/public_html/include/class.signal.php(98): PasswordPolicy::cleanSessions(Object(User), NULL)
#3 /var/www/support.tier2tickets.com/public_html/include/class.client.php(474): Signal::send('auth.clean', Object(User), NULL)
#4 /var/www/support.tier2tickets.com/public_html/account.php(97): ClientAccount->update(Array, Array)
#5 {main}
thrown in /var/www/support.tier2tickets.com/public_html/include/class.orm.php on line 3465

here is the install info:

I think that cgi.fix_pathinfo warning is also a bug, because I have confirmed it is set to 1

see also: https://forum.osticket.com/d/97238-resolved-error-changing-password

As shown in the image. This is php 7.3 which is the recommended version

    grintor I think that cgi.fix_pathinfo warning is also a bug, because I have confirmed it is set to 1

    This is a Windows PHP setting. It doesn't matter if you aren't running IIS.

    grintor When a user submits the registration request a 500 error is thrown. Here is the error from the php log:

    Is this a new install or an upgrade?

        @grintor

        Also, the issue is not due to PHP rather MySQL 8.0. There were some changes in MySQL 8.0+ that affected some regex we use so we just needed to escape the bracket in the regex.

        Cheers.

        Thank you for the info. I will switch to mariadb

        Chris

        Update: after switching to mariadb all is well.

        Write a Reply...