Good day everyone, i'm interested in adding -4.5 GMT Caracas to the timezone, would it be enough to add it directly to the database or is there a proper way to do this?Any other suggestion regarding this topic would be appreciated.Thanks in advance
Yes, insert it directly to the database would also be my suggestion. Assuming your table prefix is "ost_" use the following command.
INSERT INTO `ost_timezone` (`id`, `offset`, `timezone`) VALUES (31, -4.5, 'Caracas');
Thank you very much, will try that
As a side note, the above SQL command should only be used for osTicket 1.9.5.1.
Hello, the adition to the timezone works for the whole system, however it shows at the end of the lists (naturally) so my question is, wouls it cause any problem to manipulate this list entirelly through the database? Thanks in advance
Since every user account has a timezone_id entry that is matched to the id in the timezone table, you would need to update the timezone_id for all the users and agents as well.
So be careful here and maybe just leave it as it is at the end of the list.
It's ok it's a fresh installation, but thanks a lot for the heads up.
Very welcome.
Should I mark this thread as resolved and close it?
