Timezone issue with osticket 1.17.2

jmasse

I have an issue with timezone with osticket 1.17.2

PHP timezone : America/Toronto
Web server system timezone : America/Toronto
Osticket timezone : America/Toronto

Mysql timezone : (There is no America/Toronto in AWS RDS, so I use the US/Eastern)

And I end up with that osticket is using SYSTEM timezone? The time when i create a new ticket is the UTC one. (The mysql system timezone which cannot be changed on AWS).

To fix the issue I needed to comment the line 77 at /include/mysqli.php
#'TIME_ZONE' => 'SYSTEM',

And now everything work well, is that normal?

jmasse

I have the feeling that line 77 at /include/mysqli.php is the issue, it try to use the Mysql SYSTEM timezone which cannot be changed on AWS.

jmasse

Another big issue with this line :

By default the MySQL 8 support emoji but because of the line 75-77 it got reversed back to utf8 instead of using utf8mb4.

@db_set_all(array(
'NAMES' => 'utf8',
'CHARACTER SET' => 'utf8',
'COLLATION_CONNECTION' => 'utf8_general_ci',
'SQL_MODE' => '',

Mysql 8 sHould use utf8mb4 with collation of utf8mb4_0900_ai_ci but it got dropped to the old utf8 that doesnt support emoji.