VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Weird server error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

virgvv
Starting Member

6 Posts

Posted - January 16 2007 :  13:56:31  Show Profile  Reply with Quote
Hi, maybe someone geekier than I can shed some light on this:

For some reason, two of the categories in my client's shop have started bringing up server errors when you click on the category link:

# Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
/shopproductinventory.asp, line 20

I tried deleting and re-creating those category records and replacing my edited shopproductinventory.asp script with the original. Neither worked.

I've sent a support ticket to the web host, but wonder if anyone here has encountered something similar. I'm stumped as to why only two product categories would be throwing the error. I can't see anything "special" about either category compared with the others.

Thanks.

nxpage
Starting Member

49 Posts

Posted - January 17 2007 :  14:29:24  Show Profile  Reply with Quote
Make sure your categories don't have any special characters in them. I had a similar problem when our shipping method name had parenthasis in them like:

UPS Ground (No PO boxes)

ended up changing it to

UPS Ground - No PO boxes

... and then it worked.
Go to Top of Page

virgvv
Starting Member

6 Posts

Posted - January 17 2007 :  15:55:32  Show Profile  Reply with Quote
Thanks! The two categories did have forward slashes in them, but removing them didn't seem to help. I'll try again, though.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000