Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: ^SoporteGSM^ on August 29, 2020, 07:56:28 PM

Title: How can I reset the statistics of the Topic views to zero?
Post by: ^SoporteGSM^ on August 29, 2020, 07:56:28 PM
I want to reset to zero only the statistics of the views of the topics

how can I do it?
Title: Re: How can I reset the statistics of the Topic views to zero?
Post by: -Rock Lee- on September 01, 2020, 02:24:29 PM
I leave the solution here too in case someone else needs it, a SQL query must be made via PHPMyAdmin with the following:

UPDATE `xx_topics` SET `num_views`= 0 WHERE 1

If everything is correct the affected rows should be output, if it fails ensure that the table is named is correct.


Regards!