Looking for the v10 manual? Visit our new user's guide!
Search Descriptions Version
This article applies to: ML8, MultiStore

'Incorrect Syntax' Error when Using the Compare Stats Function

When clicking the 'Compare Stats' link on the admin home page graphs, an error like the one below displays:

Server Error in '/' Application.

Line 1: Incorrect syntax near '('.
Description: An unhandled exception occurred during the execution of the current web request.

This is caused by an incompatibility between version 8.0+ of the ASPDNSF software and MS SQL 2000. 

Sites running version 8.0 or higher need to be using SQL 2005 or 2008.  Work with your host/server admin to perform that upgrade.