You have an errant record in your email_account table. You need to find the record that doesn’t belong and delete it.
I only have one entry and I also tested with clean install. I am able to reproduce.
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.
We'll take a look at it but you need to look at the email_account table and config table for any errant records.
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?
Orphaned records (records that aren't related to existing records), duplicate records, etc.
ah thats definiteley not there
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).
here you go
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.
here you go
dolon Still need the config records that relate to the plugin and email..
KevinTheJedi Which table you need? There is no such "config" for email or plugin.
ost_config is config
Got it sorry!
dolon again, the ones related to the email and plug-in. Should be namespace includes email or plugin.
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.
dolon From the config table
SELECT * FROM `ost_config` WHERE `namespace` LIKE '%email%' OR `namespace` LIKE '%plugin%';
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.
That’s the issue. You need to delete all the records with namespace containing account.0.
unfortunately it did not help 🙁 I cleaned it and still the same.