I tried upgrading my RT from 4.2.5 to 4.4.0. I’m facing below issue when i login.
"[97669] [Wed Oct 4 02:13:47 2023] [debug]: Autohandler called ExternalAuth. Response: (1, Successful login) (/opt/rt4/rt/local/plugins/RT-Authen-ExternalAuth/html/Elements/DoAu th:16)
[97669] [Wed Oct 4 02:13:47 2023] [warning]: DBD::mysql::db selectcol_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL ser ver version for the right syntax to use near ‘Groups, Principals, CachedGroupMembers WHERE Principals.Disabled = 0 AND CachedG’ at line 1 at /opt/rt4/rt/sbin/…/lib/RT/Principal .pm line 414. (/opt/rt4/rt/sbin/…/lib/RT/Principal.pm:414)
[97669] [Wed Oct 4 02:13:47 2023] [error]: DBD::mysql::db selectcol_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL serve r version for the right syntax to use near ‘Groups, Principals, CachedGroupMembers WHERE Principals.Disabled = 0 AND CachedG’ at line 1 at /opt/rt4/rt/sbin/…/lib/RT/Principal.p m line 414.
Stack:
[/opt/rt4/rt/sbin/…/lib/RT/Principal.pm:414]
[/opt/rt4/rt/sbin/…/lib/RT/Interface/Web.pm:662]
[/opt/rt4/rt/sbin/…/lib/RT/Interface/Web.pm:370]
[/opt/rt4/rt/share/html/autohandler:53] (/opt/rt4/rt/sbin/…/lib/RT/Interface/Web/Handler.pm:210)"
Really appreciated if you can help me on this!!!