"Type mismatch" errors piling up..

Author

Message

Topic Search

Topic Options

nicholas_head View Drop Down

Newbie

Joined: 27-July-2010
Status: Offline
Points: 0

Post Options

Post Reply

Quote nicholas_head

Report Post

Thanks(0)

Quote

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

Greg Dinger View Drop Down

Certified ProductCart Developers

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238

Post Options

Post Reply

Quote Greg Dinger

Report Post

Thanks(0)

Quote

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.

nicholas_head View Drop Down

Newbie

Joined: 27-July-2010
Status: Offline
Points: 0

Post Options

Post Reply

Quote nicholas_head

Report Post

Thanks(0)

Quote

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

Greg Dinger View Drop Down

Certified ProductCart Developers

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238

Post Options

Post Reply

Quote Greg Dinger

Report Post

Thanks(0)

Quote

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.

nicholas_head View Drop Down

Newbie

Joined: 27-July-2010
Status: Offline
Points: 0

Post Options

Post Reply

Quote nicholas_head

Report Post

Thanks(0)

Quote

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.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
nicholas_head Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-July-2010 Status: Offline Points: 0	Post Options Post Reply Quote nicholas_head Report Post Thanks(0) Quote Reply 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

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply 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.

nicholas_head Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-July-2010 Status: Offline Points: 0	Post Options Post Reply Quote nicholas_head Report Post Thanks(0) Quote Reply 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

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply 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.

nicholas_head Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-July-2010 Status: Offline Points: 0	Post Options Post Reply Quote nicholas_head Report Post Thanks(0) Quote Reply 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.