Andrew1986

Hi, i switched my website from access to MySQL and the following error appeared any one have a clue where the error is ?

An error occurred executing the following query, and page execution has been terminated.
SELECT DISTINCT SUM(tblCactuShop1VersionSalesStats.VSS_Quantity) AS ProductHits, tblCactuShop1Products.P_ID, tblCactuShop1Products.P_Name1 FROM ((((tblCactuShop1VersionSalesStats INNER JOIN tblCactuShop1Versions ON tblCactuShop1VersionSalesStats.VSS_VersionID = tblCactuShop1Versions.V_ID) INNER JOIN tblCactuShop1Products ON tblCactuShop1Versions.V_ProductID = tblCactuShop1Products.P_ID) INNER JOIN tblCactuShop1ProductCategoryLink ON tblCactuShop1Products.P_ID = tblCactuShop1ProductCategoryLink.PCAT_ProductID) INNER JOIN tblCactuShop1Categories ON tblCactuShop1ProductCategoryLink.PCAT_CategoryID = tblCactuShop1Categories.CAT_ID) LEFT OUTER JOIN tblCactuShop1Suppliers ON tblCactuShop1Products.P_SupplierID = tblCactuShop1Suppliers.SUP_ID WHERE tblCactuShop1Products.P_Name1 <> '' AND tblCactuShop1Products.P_Live = 'y' AND P_CustomerGroupID IN (0,0) AND tblCactuShop1VersionSalesStats.VSS_Date >= '2008/2/10 11:23:28' AND V_Live ='y' AND CAT_Live = 'y' AND V_CustomerGroupID IN (0,0) AND CAT_CustomerGroupID IN (0,0) AND (SUP_Live <> 'n' OR SUP_Live IS NULL) GROUP BY tblCactuShop1Products.P_ID, tblCactuShop1Products.P_Name1 ORDER BY ProductHits DESC LIMIT 0, 5
Error Description : Multiple-step operation generated errors. Check each status value.
Page of error : /Default.asp
Query String :

Andrew1986

Any one?

Monie

This error means that one or more fields you are inserting/updating contain an invalid value. Some of the possible scenarios are:

1. A string value is being inserted into a numeric field.
2. An invalid date expression is being inserted into a date field.
3. A string value being inserted is longer than the size of the string field.
4. A null value is being inserted into a field that does not allow nulls.