Getting some strange product and sql query error

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello everyone,

     Errors are shown when i click on categories and products page

* Error At 8/5/2009 6:26:49 AM
* CustomerRefID: 186916090-62649
* Session ID: 186916090
* Error Number: 13
* Error Source: Microsoft VBScript runtime error
* Error Description: Type mismatch
*
Last Query: SELECT DISTINCT optionsGroups.OptionGroupDesc,
pcProductsOptions.pcProdOpt_ID, pcProductsOptions.idOptionGroup,
pcProductsOptions.pcProdOpt_Required, pcProductsOptions.pcProdOpt_Order
FROM products INNER JOIN ( pcProductsOptions INNER JOIN ( optionsgroups
INNER JOIN options_optionsGroups ON optionsgroups.idOptionGroup =
options_optionsGroups.idOptionGroup ) ON optionsGroups.idOptionGroup =
pcProductsOptions.idOptionGroup ) ON products.idProduct =
pcProductsOptions.idProduct WHERE products.idProduct=22 AND
options_optionsGroups.idProduct=22 ORDER BY
pcProductsOptions.pcProdOpt_Order;
* RequestMethod: GET
* ServerPort: 80
* HTTPS: off

the above is the error is displayed on every products page whenever i click to categories.
And even when i add more than 1 product to the category, only 1 product is shown while the others arent.  The error is same like the error information page in control panel.
I dont know what to do, i checked the codes in viewcategories.asp i couldnt find any solution.

Please help me!! :(

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Ashutosh Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 05-August-2009 Location: India Status: Offline Points: 0	Post Options Post Reply Quote Ashutosh Report Post Thanks(0) Quote Reply Topic: Getting some strange product and sql query error Posted: 05-August-2009 at 8:00am
	Hello everyone, Errors are shown when i click on categories and products page * Error At 8/5/2009 6:26:49 AM * CustomerRefID: 186916090-62649 * Session ID: 186916090 * Error Number: 13 * Error Source: Microsoft VBScript runtime error * Error Description: Type mismatch * Last Query: SELECT DISTINCT optionsGroups.OptionGroupDesc, pcProductsOptions.pcProdOpt_ID, pcProductsOptions.idOptionGroup, pcProductsOptions.pcProdOpt_Required, pcProductsOptions.pcProdOpt_Order FROM products INNER JOIN ( pcProductsOptions INNER JOIN ( optionsgroups INNER JOIN options_optionsGroups ON optionsgroups.idOptionGroup = options_optionsGroups.idOptionGroup ) ON optionsGroups.idOptionGroup = pcProductsOptions.idOptionGroup ) ON products.idProduct = pcProductsOptions.idProduct WHERE products.idProduct=22 AND options_optionsGroups.idProduct=22 ORDER BY pcProductsOptions.pcProdOpt_Order; * RequestMethod: GET * ServerPort: 80 * HTTPS: off the above is the error is displayed on every products page whenever i click to categories. And even when i add more than 1 product to the category, only 1 product is shown while the others arent. The error is same like the error information page in control panel. I dont know what to do, i checked the codes in viewcategories.asp i couldnt find any solution. Please help me!! :(

Guests Members Profile Send Private Message Find Members Posts Add to Buddy List Guest	Post Options Post Reply Quote Guests Thanks(0) Quote Reply Posted: 05-August-2009 at 11:15am
	Hi Ashutosh, The PC error trapping can be very vague. To work around it and attempt to get a more informative error message, try the following: In the CP, under Settings -> Store Settings -> Miscellaneous toggle the error handler OFF Open /includes/opendb.asp and comment out (put an apostrophe in front of) the first two "On Error Resume Next" commands Then run your pages again and see if you get a more informative error message. Be sure to set these things back afterwards!

Ashutosh Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 05-August-2009 Location: India Status: Offline Points: 0	Post Options Post Reply Quote Ashutosh Report Post Thanks(0) Quote Reply Posted: 06-August-2009 at 6:28am
	Hello Sean, Thank you for the reply. I did both things as you told me. But still i'm getting the same error again. The error handler was already turned off and i made the comment to the first two "On error resume next" . Nothing is changed . Thanks again.

Ashutosh Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 05-August-2009 Location: India Status: Offline Points: 0	Post Options Post Reply Quote Ashutosh Report Post Thanks(0) Quote Reply Posted: 06-August-2009 at 9:25am
	Hello Sean, I got the solution. The reason i was getting this error because i didnt include some piece of code in header.asp. Now its working perfect. Thanks again sean for your help.

BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply Posted: 11-August-2009 at 10:48am
	Ashutosh, What piece of code wasn't included that fixed the problem when you added it? I'm having the same error with viewCategories.asp after moving the site to new hardware.