HTTP 500 error saving mail settings

dolon

Hi,
since 1.17.3 upgrade I got http 500 error when I try to modify the email settings. Altough the email works, but you cannot modify the ssettings. The debug shows in log:

[Tue Mar 14 22:20:34.267501 2023] [php:error] [pid 21807] [client 149.200.76.98:61231] PHP Fatal error: Uncaught Error: Call to undefined method osTicket\Mail\BasicAuthCredentials::getAccessToken() in /www/osticket/include/class.email.php:557\nStack trace:\n#0 /www/osticket/include/class.email.php(495): EmailAccount->getAccessToken()\n#1 /www/osticket/include/class.email.php(1349): EmailAccount->checkStrictMatching()\n#2 /www/osticket/include/class.email.php(1377): SmtpAccount->setInfo()\n#3 /www/osticket/include/class.email.php(328): SmtpAccount->update()\n#4 /www/osticket/scp/emails.php(35): Email->update()\n#5 {main}\n thrown in /www/osticket/include/class.email.php on line 557, referer: https://demo.hazimano.hu/scp/emails.php?id=5
[Tue Mar 14 22:20:34.432069 2023] [ssl:debug] [pid 21807] ssl_engine_io.c(1147): [client 149.200.76.98:61231] AH02001: Connection closed to child 10 with standard shutdown (server *:443)

KevinTheJedi

dolon

You have an errant record in your email_account table. You need to find the record that doesn’t belong and delete it.

Cheers.

dolon

KevinTheJedi
I only have one entry and I also tested with clean install. I am able to reproduce.

SeuzRoman

Hello. I'm having the same problem (https://forum.osticket.com/d/102831-1173-e-mail-problem) I'm afraid this might be a bug since I was able to reproduce it on clean install.

In my understanding, there's the algorithm of checking email settings correctness. Now it tries to get access token even in case of basic authentication for which it is not relevant.

In my case though it doesn't affect the saving of the SMTP settings. Despite the error everything works fine.

KevinTheJedi

We'll take a look at it but you need to look at the email_account table and config table for any errant records.

dolon

Has the table structure changed from 1.17.2 -> 1.17.3? Otherwise as I mentioned I tested with a super clean new dataabase, also the previous had only one entry one mail which was working before. What I should check what does it mean "errant" for you?

KevinTheJedi

dolon

Orphaned records (records that aren't related to existing records), duplicate records, etc.

Cheers.

dolon

ah thats definiteley not there

KevinTheJedi

dolon

Then your issue doesn't make much sense.. please post screenshots of your email_account records, plugin_instance records, and config records that relate to the email(s).

Cheers.

dolon

here you go

KevinTheJedi

dolon

That is not what I was asking for. Please provide screenshots of your email_account records, plugin_instance records, and config records that relate to the email(s).

"Records" meaning the records in the database; not UI.

Cheers.

dolon

here you go

KevinTheJedi

dolon Still need the config records that relate to the plugin and email..

dolon

KevinTheJedi Which table you need? There is no such "config" for email or plugin.

ntozier

ost_config is config

dolon

Got it sorry!

KevinTheJedi

dolon again, the ones related to the email and plug-in. Should be namespace includes email or plugin.

dolon

Hey,
yes indeed there are not many, here I attache all. One issue I found which is an old version of instance in the plugin left there and not listed. I deleted from the DB, but unfortunately no change of behavior.

KevinTheJedi

dolon From the config table

SELECT * FROM `ost_config` WHERE `namespace` LIKE '%email%' OR `namespace` LIKE '%plugin%';

dolon

KevinTheJedi
SORRY!!! My bad, I did't notice the config DB table has a limit view of 25 entries. Here you go the sql query. Looks like it is more than one?! I can't really decide.

KevinTheJedi

dolon

That’s the issue. You need to delete all the records with namespace containing account.0.

Cheers.