It could be that your Links table has a prefix and actually isn't named 'Links'. To check this go to the Setup in Admin and select the SQL Server and check if there is anything listed in the Table Prefix. For example it might have a prefix like: Links_
If there is a table prefix such as Links_ you would need to enter the SQL query in the SQL monitor as:
UPDATE Links_Links
SET Hits = '0'
That should work then I think. I realize that doing this once a month is more labor intensive than setting up a program to do it automatically, but once you get the SQL query language down, it is easy and takes about one minute per month or about 12 minutes a year.
--Rover
If there is a table prefix such as Links_ you would need to enter the SQL query in the SQL monitor as:
UPDATE Links_Links
SET Hits = '0'
That should work then I think. I realize that doing this once a month is more labor intensive than setting up a program to do it automatically, but once you get the SQL query language down, it is easy and takes about one minute per month or about 12 minutes a year.
--Rover