Just installed osTicket on a shared server (GoDaddy) and having an issue with ticket times being 1 hour behind. Also when Collision Avoidance is enabled it shows the error "This action requires a lock. Please try again!" when trying to update a ticket.
Have set Default Time Zone to "America/Los_Angeles" in Admin/Settings/System and also in Agent/Profile/Preferences, but Information page shows MST (Interpreted as America/Denver) as the Time zone under Database Information and Usage (server is located in Arizona). Since this is a shared server I don't believe we can change the time zone in the database.
After doing some digging found a possible solution was to update class.config.php from:
function getDbTimezone() {
if (!$this->exists('db_timezone')) {
require_once INCLUDE_DIR . 'class.timezone.php';
$this->persist('db_timezone', DbTimezone::determine());
}
return $this->get('db_timezone');
}
To:
function getDbTimezone() {
if (!$this->exists('db_timezone')) {
require_once INCLUDE_DIR . 'class.timezone.php';
$this->persist('db_timezone', DbTimezone::determine());
}
$dvd_db_timezone='America/Los_Angeles';
return $dvd_db_timezone;
}
But after making this change we were no longer able to see any tickets so rolled back the change. Any ideas?
Server Information
osTicket Version v1.15.2 (cb6766e)
Web Server Software Apache
MySQL Version 5.7.33
PHP Version 7.4.16
