Can't Add Items After Upgrading MySQL

Comersus Version: 500
Database type: Other
Frequency: Permanent issue


Hi, my ISP was running MySQL 4.0.16 and upgraded to 4.1 and now I get the error
Microsoft VBScript runtime error '800a000d'
Type mismatch
/storeFront/store/comersus_addItem.asp, line 50

I've uncommented the 'on error resume next' and the site passes all of the tests in cartTools. I think I've narrowed the problem down to the function called 'countCartRows' not working properly. It no longer seems to returns an integer, so if statements that test if the cart is empty fail. I've tried casting the return value to an int and a double but it doesn't help. I've verified that everything is getting written to the database correctly, it's just not getting the number of items from the cart correctly any more. I've spent MANY hours on this problem was would really appreciate any help.

Thank,

Brian

Tags:
3 Comments

Add a Comment

Your email address will not be published. Required fields are marked *