Missing "Save Changes" button for email settings

ealtman

My "Save Changes" button is missing from osticket/scp/emailsettings.php
Can anybody help? I am also getting a 500 error when I run osticket/scp/emailtest.php. This happened after I lost my OAUTH2 connection and had to set up the email again.

Here is my information:
osTicket Version v1.17-rc4 (356e156) — v1.17.2 is available
Web Server Software Apache/2.4.37 (Red Hat Enterprise Linux) OpenSSL/1.1.1k
MySQL Version 8.0.30
PHP Version 8.0.27
PHP Extensions
gdlib Used for image manipulation and PDF printing
imap Used for email fetching
xml XML API
xml-dom Used for HTML email processing
json Improves performance creating and processing JSON
mbstring Highly recommended for non western european language content
phar Highly recommended for plugins and language packs
intl Highly recommended for non western european language content
fileinfo Used to detect file types for uploads
zip Used for ticket and task exporting
APCu Improves overall performance
Zend Opcache Improves overall performance
PHP Settings
cgi.fix_pathinfo "1" is recommended if AJAX is not working
date.timezone Setting default timezone is highly recommended
Database Information and Usage
Schema osticket (localhost)
Schema Signature 83a22ba22b1a6a624fcb1da03882ac1b
Space Used 1435.17 MiB
Space for Attachments 1266.05 MiB
Timezone PST (Interpreted as America/Los_Angeles)

KevinTheJedi

ealtman

Oof you need to upgrade to v1.17.2 asap. You are missing so many bug fixes. Also, please don’t run RC in production. RC are unstable and only meant for testing purposes. So once you upgrade osTicket make sure you update the plugins and retest.

Also, for this missing button look at your PHP and/or webserver logs for any fatal errors. I think it’s due to an invalid record in the database but we need the error to see what’s going on.

Cheers.

ealtman

Ok now I am confused. I followed all the steps to upgrade but no upgrade script ran. Information now looks like this:

osTicket Version v1.17.2 (8fbc7ee) — Up to date
Web Server Software Apache/2.4.37 (Red Hat Enterprise Linux) OpenSSL/1.1.1k
MySQL Version 8.0.30
PHP Version 8.0.27
PHP Extensions
gdlib Used for image manipulation and PDF printing
imap Used for email fetching
xml XML API
xml-dom Used for HTML email processing
json Improves performance creating and processing JSON
mbstring Highly recommended for non western european language content
phar Highly recommended for plugins and language packs
intl Highly recommended for non western european language content
fileinfo Used to detect file types for uploads
zip Used for ticket and task exporting
APCu Improves overall performance
Zend Opcache Improves overall performance
PHP Settings
cgi.fix_pathinfo "1" is recommended if AJAX is not working
date.timezone Setting default timezone is highly recommended
Database Information and Usage
Schema osticket (localhost)
Schema Signature 83a22ba22b1a6a624fcb1da03882ac1b
Space Used 1435.17 MiB
Space for Attachments 1266.05 MiB

I have yet to check for DB errors (httpd/php errors are not helpful in the least) but I still have no "Save Changes" button on the email settings.
--Elizabeth

Daedalus01

ealtman If I am not mistaken, the upgrade script will only run if you are changing major versions ( 1.16 to 1.17) and/or their are database changes. Since you went from 1.17 to 1.17 there is probably not a need for it.

KevinTheJedi

ealtman

Check your logs (general server logs, webserver error logs, PHP error logs, MySQL/MariaDB error logs, osTicket System Logs, Browser Console logs, etc.) for any related errors.

Daedalus01 is correct in that upgrading from the RC to stable will not run any upgrade scripts, just essentially updating the codebase.

Cheers.

ealtman

There are no errors I could find in the mysqld logs. One error from ssl_access_log when I try to test an email looks like this:
###.###.###.### - ealtman [05/Jan/2023:10:08:55 -0800] "POST /osticket/scp/emailtest.php HTTP/1.1" 500 -

Other than that, it is just the Email Settings I can't save.

UPDATE
I'm getting a 500 as the confirmation page when I access open.php to posting a new ticket as well. However, the ticket gets created.
The permissions for open.php are 644 and owned by user:group www-data (the web server user on my server, actually)
I have check all the chmod and chown settings and they are in line.

Other things to check?

Elizabeth

ealtman

So I think what happened is on the .rc version ost_email_account lines weren't being cleared when emails were removed from ost_email. I did this manually after migration and that brought back my "Save Changes" button. Am trying to reconnect my OAUTH2 now. Waiting on my Azure manager. Will let you know how it turns out.

UnderDogMiller

ealtman What did you do to clear this? I'm having this exact issue with the "Save Changes" button missing on the email settings page.

ealtman

I am still waiting on my Azure manager, but in the meantime I did some testing.
The token hadn't been granted in a timely fashion, so I found the following state when I went to Osticket Admin this morning:

The OAUTH2 instance was retained in the OAUTH2 plugin configuration
The Inbox/Outbox settings for the email for which I had requested the token were now blank

I deleted the OAUTH2 instance through the OAUTH2 plugin config interface. Then I deleted the email itself (it was not set as the default). I got a stack trace error, but the email was deleted

Looking at the DB through phpmyadmin, I found that there was still an oauth setting for the email I deleted in ost_email_account, which I don't think is intended. Do you need to add a dependency to make sure settings get cleared?

I will clear it manually for now.

Elizabeth

KevinTheJedi

ealtman

Yes, there are still some lingering cleanup that we are working on.

Cheers.

KevinTheJedi

UnderDogMiller

Check for orphaned records in the ost_email_account table as well as the ost_config table.

Cheers.

UnderDogMiller

Ahh yes - found the table and I too had a rogue entry in the ost_email_account table. I deleted the 2 rogue ID's and the "Save Changes" came back.