bardentech
Starting Member
39 Posts |
Posted - October 07 2009 : 23:37:04
|
We are processing quite a few orders a day on our system and we got a compaint from a customer stating that they couldn't order from our website. Each time they entered the Billing information it would kick back stating that City is required. Apparently anytime you have a two word city with Union in it ( Union City, Union Turnpike, etc..) it will kick it back out and the customer can't order.
Has anyone experienced this? I tried it on a demo site and the same thing happened. Any ideas on a fix? |
|
support
Administrator
4679 Posts |
Posted - October 08 2009 : 00:17:54
|
Hi there,
Union is a reserved word as a result of SQL injections however you can remove it from the list following these steps.
Try this.
1. Open file shop$db.asp using notepad.
2. Locate these codes below :
strWords = replace(strWords, "''", "'")
3. After the codes above, please insert these codes :
strWords = replace(strWords,"Union", "Union*")
4. Save the file and upload to your site.
Hope this helps.
Thanks Wilson
VPASP Support |
|
|