Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook Tuesday at 01:29 PM
Day_ Posted May 5, 2019 Share Posted May 5, 2019 I do have a ticket open with a current issue which I have updated with this, but as it's the weekend was wondering if anyone may have come across this and can point me in the right direction of what could be causing this whilst I wait. Basically I moved my site to a new server, since then the time is off as tasks are showing as being run with the time shown as one hour ahead, we have topics scheduled to open and lock which are all over the place right now. WHM Server time is correct. I ran a query on the database to check the timezone, this is also correct Link to comment Share on other sites More sharing options...
Adlago Posted May 5, 2019 Share Posted May 5, 2019 See this article - your MySQL server timezone may be incorrect. https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html Link to comment Share on other sites More sharing options...
Day_ Posted May 5, 2019 Author Share Posted May 5, 2019 10 minutes ago, Adlago said: See this article - your MySQL server timezone may be incorrect. https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html It's set to SYSTEM which the server time is correct Link to comment Share on other sites More sharing options...
Adlago Posted May 5, 2019 Share Posted May 5, 2019 In your Registrations statistic, down you have link "Results are shown in the server's timezone. Learn More" Click Learn More and see your server timezone Link to comment Share on other sites More sharing options...
Day_ Posted May 5, 2019 Author Share Posted May 5, 2019 1 hour ago, Adlago said: In your Registrations statistic, down you have link "Results are shown in the server's timezone. Learn More" Click Learn More and see your server timezone This is also showing as correct but says I don’t have Timezone support? Link to comment Share on other sites More sharing options...
Adlago Posted May 5, 2019 Share Posted May 5, 2019 Check your Cron Jobs. Delete command from server and create it again. Link to comment Share on other sites More sharing options...
Day_ Posted May 5, 2019 Author Share Posted May 5, 2019 5 minutes ago, Adlago said: Check your Cron Jobs. Delete command from server and create it again. Tried, still the same. It's not just tasks, on the front end if you hover over Posted time it's running +1 Link to comment Share on other sites More sharing options...
Adlago Posted May 5, 2019 Share Posted May 5, 2019 Did you try another browser? Link to comment Share on other sites More sharing options...
Day_ Posted May 5, 2019 Author Share Posted May 5, 2019 18 minutes ago, Adlago said: Did you try another browser? Yep, Safari, Chrome and it's not just me, moderators can also see the time is out. Will have to leave it until the boffins are back in the office Link to comment Share on other sites More sharing options...
Adlago Posted May 5, 2019 Share Posted May 5, 2019 Your server have BST time (UTC +1) But "date_default_timezone_set( 'UTC' ); " (row 525 init.php) Probably now, time on your board shows UTC +2 You can try changing the "date_default_timezone_set( 'UTC' ); " to an init.php file, such as BST, or UTC-1 Link to comment Share on other sites More sharing options...
Day_ Posted May 5, 2019 Author Share Posted May 5, 2019 3 minutes ago, Adlago said: Your server have BST time (UTC +1) But "date_default_timezone_set( 'UTC' ); " (row 525 init.php) Probably now, time on your board shows UTC +2 You can try changing the "date_default_timezone_set( 'UTC' ); " to an init.php file, such as BST, or UTC-1 Just changed it to date_default_timezone_set( 'BST' ); Ran support tool just to clear the cache, still showing as an hour off, ran a task and again +1 ahead it's showing as being run Link to comment Share on other sites More sharing options...
Adlago Posted May 5, 2019 Share Posted May 5, 2019 Try BST-1 Link to comment Share on other sites More sharing options...
Day_ Posted May 5, 2019 Author Share Posted May 5, 2019 5 minutes ago, Adlago said: Try BST-1 Still the same, also tried Europe/London but no change Link to comment Share on other sites More sharing options...
Adlago Posted May 5, 2019 Share Posted May 5, 2019 Specifically, try UTC-1, not BST-1 Link to comment Share on other sites More sharing options...
Day_ Posted May 5, 2019 Author Share Posted May 5, 2019 2 minutes ago, Adlago said: Specifically, try UTC-1, not BST-1 Again, the same, no change ☹️ Link to comment Share on other sites More sharing options...
Adlago Posted May 5, 2019 Share Posted May 5, 2019 In the menu Reputation - Leaderboard timezone - there is one setting - try it too Link to comment Share on other sites More sharing options...
Day_ Posted May 5, 2019 Author Share Posted May 5, 2019 1 minute ago, Adlago said: In the menu Reputation - Leaderboard timezone - there is one setting - try it too It's set to London, I look in the leaderboard, switch to today. The time here now is 16.21 but again it's showing as an hour ahead Link to comment Share on other sites More sharing options...
Adlago Posted May 5, 2019 Share Posted May 5, 2019 See admin/convertutf8/init.php (row25,26) /* Set timezone */ date_default_timezone_set( 'UTC' ); and try change UTC -> UTC-1 (or BST) Link to comment Share on other sites More sharing options...
Day_ Posted May 5, 2019 Author Share Posted May 5, 2019 7 minutes ago, Adlago said: See admin/convertutf8/init.php (row25,26) /* Set timezone */ date_default_timezone_set( 'UTC' ); and try change UTC -> UTC-1 (or BST) Tried this, then cleared cache and came up with a warning that I have modified files which need fixing, ignored and looked anyway and no, didn't fix it, so put UTC back again. The init file didn't like that being changed Link to comment Share on other sites More sharing options...
Day_ Posted May 5, 2019 Author Share Posted May 5, 2019 Ok, I've fixed it, I'm a genius....but most likely probably not. Right, I'm not entirely sure what I did, but what I did fixed it. In WHM and MultiPHP turned off PHP-FPM for the account, set the version to inherit which was PHP 7.2 (ea-php72) And that fixed it. I then when into LVE manager and enabled 7.3 for me to select as only alt was available in MultiPHP as the system PHP version and that crashed the site. Anyhow, I go to cPanel and enable 7.3. Update me crons and that and it's all working tickety boo Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.