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


Symptoms
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.

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

Solution
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.