This is a discussion on "Multiple-step operation generated errors" within the Databases section. This forum, and the thread "Multiple-step operation generated errors are both part of the Program Your Website category.
|
|
|
|
|
 |
||
Multiple-step operation generated errors
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
|
#1
Mar 11th, 2008, 10:29
|
|||
|
|||
|
Multiple-step operation generated errors
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 :        
|
|
|
|
#2
Mar 13th, 2008, 14:53
|
|||
|
|||
|
Re: Multiple-step operation generated errors
Any one?
|
|
#3
Mar 14th, 2008, 07:29
|
|||
|
|||
|
Re: Multiple-step operation generated errors
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.
Last Blog Entry: ASP Programming Tips and Technique (Oct 26th, 2007)
|
|
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| [SOLVED] Link Scanner to find where 404 errors are being generated | nate2099 | PHP Forum | 3 | Jan 19th, 2008 11:41 |
| ASP-MySQL: Advance Login Page [Step-By-Step Tutorial - Example In Action] | Monie | Classic ASP | 4 | Oct 25th, 2007 05:43 |
| I need to know about Gradient fill operation | balaakrs | Flash & Multimedia Forum | 1 | Oct 1st, 2007 21:38 |
| Tutorial: A step-by-step guide to creating & adding a favourites icon to your website | Antwan | Starting Out | 0 | Sep 8th, 2006 14:16 |
| Operation for Date | siaoa84 | Classic ASP | 3 | Oct 17th, 2003 10:10 |
