ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Using ProductCart
  New Posts New Posts RSS Feed - "Type mismatch" errors piling up..
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

"Type mismatch" errors piling up..

 Post Reply Post Reply
Author
Message
nicholas_head View Drop Down
Newbie
Newbie


Joined: 27-July-2010
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote nicholas_head Quote  Post ReplyReply Direct Link To This Post Topic: "Type mismatch" errors piling up..
    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
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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.
 
 
Back to Top
nicholas_head View Drop Down
Newbie
Newbie


Joined: 27-July-2010
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote nicholas_head Quote  Post ReplyReply Direct Link To This Post 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.

Edited by nicholas_head - 08-June-2011 at 1:54pm
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
nicholas_head View Drop Down
Newbie
Newbie


Joined: 27-July-2010
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote nicholas_head Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.063 seconds.