Wait ~12 million second before posting or searching

[erdiyilmaz]

Hi,

My server time (year) suddenly changed 2012 to 2016. I didn't realize. We used forum about one day with this. Today i changed my server year 2016 to 2012.

When i changed server year 2016 to 2012:

- users can not searching, they encounter: "12... million second wait before search".
- users can not look at last messages, they encounter: "12... million second wait before search".
- users can not sending private message, they encounter: "12... million second wait before posting".

I think, users cookies session time stayed at 2016. Normally time between queries is only 30 sec. or waiting time between posting is 10 sec.

How can i solve this problem?

[kh99]

For searches, I believe you can just truncate the "search" table.

For private messages, it looks like it checks the last entry in pmtext for a given user. Since we
know that Jan 1 2016 is unix timestamp 1451606400, and the difference between 2012 and 2016 is 126230400, you can do this query:

UPDATE pmtext SET dateline = dateline - 126230400 WHERE dateline > 1451606400


You could also do similar queries on the post and thread tables (not all timestamps are named dateline so you might have figure out which colums are timestamps and run the query multiple times).

It might be a good idea to do a database backup before trying any of this.