Solved: 5 Years, 8 Months, 4 Weeks ago Changing time in MyBB 1.8
#1
Solved: 5 Years, 8 Months, 4 Weeks ago
Version: 1.8
URL: http://testforum.com
I need help changing the time here. As seen on the only current post, it says 1970, but I am pretty sure it is 2015, about to become 2016 Toungue 
Can you guys assist me with this?
Thanks!
Reply
#2
Solved: 5 Years, 8 Months, 4 Weeks ago
It's probably the default message. You need to update the "mysql_posts" table. Find the "dateline" of the post and change it to "1451001600" which is today.

If you need further convertation you can use this link.
Reply
#3
Solved: 5 Years, 8 Months, 4 Weeks ago
(2015-12-25, 06:30 AM)un4saken Wrote: It's probably the default message. You need to update the "mysql_posts" table. Find the "dateline" of the post and change it to "1451001600" which is today.

If you need further convertation you can use this link.

I need to change the time for the entire forums, and I currently don't know how to, not just for the post.
Reply
#4
Solved: 5 Years, 8 Months, 4 Weeks ago
If you need to adjust site time, it's in ACP -> Configurations -> Date and Time Formats

If Most Users Online section showing the year 1970, you need to reset it by running the following SQL query

UPDATE `mybb_datacache` SET `cache` = 'a:2:{s:8:"numusers";i:0;s:4:"time";i: 1451001600;}' WHERE `title` = 'mostonline'; 


Also, can you provide us your forum url? We can take a closer look.
Reply
#5
Solved: 5 Years, 8 Months, 4 Weeks ago
(2015-12-25, 07:07 AM)un4saken Wrote: If you need to adjust site time, it's in ACP -> Configurations -> Date and Time Formats

If Most Users Online section showing the year 1970, you need to reset it by running the following SQL query

UPDATE `mybb_datacache` SET `cache` = 'a:2:{s:8:"numusers";i:0;s:4:"time";i: 1451001600;}' WHERE `title` = 'mostonline'; 


Also, can you provide us your forum url? We can take a closer look.

URL: http://testforum.com (I am pretty sure I stated this in the first post)
How can I change my own join date? I kinda look old if I joined from 1970.
Reply
#6
Solved: 5 Years, 8 Months, 4 Weeks ago
Run this SQL query

Update `mybb_users` SET `regdate` = '1451001600' WHERE `uid` = 1
Reply
#7
Solved: 5 Years, 8 Months, 4 Weeks ago
Thanks a lot! That did just what I needed!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)