ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Using ProductCart
  New Posts New Posts RSS Feed - showing error with pc/instPrd.asp
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

showing error with pc/instPrd.asp
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
marketabilities View Drop Down
Newbie
Newbie


Joined: 10-December-2007
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote marketabilities Quote  Post ReplyReply Direct Link To This Post Topic: showing error with pc/instPrd.asp
    Posted: 23-March-2010 at 10:36am
This error is showing up constantly in our store.  Any idea on how this can be fixed?

Date/Time: 3/20/2010
Session ID: 436607448
Error Number: -2147217900
Source: Microsoft OLE DB Provider for SQL Server
Description: Incorrect syntax near 'declare'.

query=SELECT xfield FROM xfields WHERE idxfield=1 declare

Request Method: POST
Server Port: 80
HTTPS: off
Local Address: 67.199.70.169
Host Address: 165.193.42.147
User Agent: Mozilla/5.0 (compatible; MSIE 7.0; MSIE 6.0; ScanAlert; +http://www.scanalert.com/bot.jsp) Firefox/2.0.0.3
URL: /xxxxxxxxx/pc/instPrd.asp
HTTP Headers: www.xxxxxxxxxxxxxxxxx.com

Back to Top
mattprice View Drop Down
Senior Member
Senior Member


Joined: 03-June-2007
Location: United Kingdom
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote mattprice Quote  Post ReplyReply Direct Link To This Post Posted: 23-March-2010 at 12:23pm
Somebody more technical will probably offer better guidance than me but here goes.
 
It looks like you are hitting an error when trying to add a product with a custom input field to your cart.  Since the error says that there Incorrect syntax near 'declare'.  I would first take a look and see if there are any custom input fields that have the word 'declare' in their description and whether there are any unusual characters either side of that word.  I would also check to see if anything has been changed in file instPRD.asp around line 1171 where the word 'declare' is mentioned
 
Matt
Back to Top
marketabilities View Drop Down
Newbie
Newbie


Joined: 10-December-2007
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote marketabilities Quote  Post ReplyReply Direct Link To This Post Posted: 24-March-2010 at 8:11am
Matt,

Thanks so much for your suggestions.  I looked and can't find a 'declare' on anything other than things that have been commented out and don't find it in descriptions. I don't see anything changed in the instPRD.asp either.  The strange thing is that the error seems to be coming from http://www.scanalert.com/bot.jsp so I'm thinking that maybe that scanalert just doesn't like something so I don't believe at this point it is effecting the stores performance although I'll keep an eye on it.  Thanks again, Stephanie
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.078 seconds.