Teach you to solve discuz! forum time not unified problem

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

discuz!7.0 is Sing (Comsenz) company released in December 2008, a forum BBS construction station products. When the discuz! forum runs, often have users encounter such a problem, the member's last visit time and final publication time will exceed the current time, this situation occurs because the server time ahead of the reason. For example, it is 2009-7-28 16:00, and the last visit time and last publication time of the member's personal Center show as 2009-7-29 16:00.

At this time, the administrator needs to check the server's time settings to restore normal time. Although the server time has been adjusted, but there will still be some people's personal center to show the exception, such as members if only log on without posting the last published time will not be updated. You need to use SQL statements to upgrade the database at this time.

The upgrade method is as follows:

In the System Setup => tool => database => upgrade

Write the following SQL statement

UPDATE cdb_members SET lastactivity=lastvisit WHERE lastactivity>unix_timestamp ();

The meaning of this statement is to find a user whose last publication time is greater than the present time, setting his last publication time to the last access time.