Using ProductCart - Getting some strange product and sql query error

Print Page | Close Window

Getting some strange product and sql query error

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2925
Printed Date: 27-February-2025 at 11:58pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Getting some strange product and sql query error

Posted By: Ashutosh
Subject: Getting some strange product and sql query error
Date 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!! :(

Replies:

Posted By: Guests
Date 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!

Posted By: Ashutosh
Date 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.

Posted By: Ashutosh
Date 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.

Posted By: BrianRoden
Date 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.