How do you reset URL data log?

[markw]

Is there a way of clearing the url tracking log? If you disable url tracking and then reenable it does the url history remain intact?

Thanks

[alan]

The URL tracking information is stored in the ODBC table fsurl. So it won't get deleted even if you disable the URL tracking option.

To clear URL tracking log, you can:

1) execute SQL "delete from fsurl" to delete all the records (i.e. rows) in the table fsurl. You can execute SQL from PHP or MSQRY32.EXE (available in Microsoft Office).

or

2) if you are using the default datasource, replace the file fsurl.dbf from the original FirstSpot installation zip file.
_________________
~ Patronsoft Limited ~