Using ProductCart - "Type mismatch" errors piling up..

Print Page | Close Window

"Type mismatch" errors piling up..

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=4534
Printed Date: 21-November-2024 at 11:27am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: "Type mismatch" errors piling up..

Posted By: nicholas_head
Subject: "Type mismatch" errors piling up..
Date Posted: 08-June-2011 at 1:32pm

Seeing more errors like this lately:

Error Number: 13
Source: Microsoft VBScript runtime error
Description: Type mismatch
query=SELECT * FROM shipService WHERE serviceActive=-1;
URL: /productcart/pc/viewcart.asp

Any idea what could be going on here?

Also seeing these:

Error Number: 13
Source: Microsoft VBScript runtime error
Description: Type mismatch
query=SELECT discountPerUnit,discountPerWUnit,percentage,baseproductonly FROM discountsPerQuantity WHERE idProduct=12 AND quantityFrom<=2 AND quantityUntil>=2
URL: /productcart/pc/instPrd.asp

Replies:

Posted By: Greg Dinger
Date Posted: 08-June-2011 at 1:42pm

2 points.

in /productcart/includes/opendb.asp there is a statement:

on error resume next

it sounds like that has been set to this for debugging:

'on error resume next

If you remove the ' from before there, normal store error handling will take over.

But that takes us to the second point. Is your store altered? Did someone alter something related to shipping, or something else? The point above leads me to wonder why that "on error resume next" was altered. There would have been a likely reason to do that - namely, debugging a program mod.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: nicholas_head
Date Posted: 08-June-2011 at 1:54pm

Thanks, but nope, those lines aren't commented out in opendb.asp

Also, those error messages are coming from the ProductCart error logging.

Posted By: Greg Dinger
Date Posted: 08-June-2011 at 2:27pm

<<<ProductCart error logging>>>

Ahh, ok.

Back to the question then - is the store altered?

I recommend you submit a support request because someone will have to dig in and look at this, and it will likely require admin access as well as FTP.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: nicholas_head
Date Posted: 08-June-2011 at 8:33pm

Bummer, thought it would be something sort of obvious. The only addons we have are official ones from Early Impact, like Google Checkout. Thanks for the help.