ProductCart Shopping Cart Software Forums : showing error with pc/instPrd.asp https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 17:25:42 +0000 Wed, 24 Mar 2010 08:11:36 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3542 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[showing error with pc/instPrd.asp : Matt,Thanks so much for your suggestions....]]> https://forum.productcart.com/showing-error-with-pc-instprd-asp_topic3542_post13606.html#13606 Author: marketabilities
Subject: 3542
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]]> Wed, 24 Mar 2010 08:11:36 +0000 https://forum.productcart.com/showing-error-with-pc-instprd-asp_topic3542_post13606.html#13606 <![CDATA[showing error with pc/instPrd.asp : Somebody more technical will probably...]]> https://forum.productcart.com/showing-error-with-pc-instprd-asp_topic3542_post13589.html#13589 Author: mattprice
Subject: 3542
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
]]> Tue, 23 Mar 2010 12:23:07 +0000 https://forum.productcart.com/showing-error-with-pc-instprd-asp_topic3542_post13589.html#13589 <![CDATA[showing error with pc/instPrd.asp : This error is showing up constantly...]]> https://forum.productcart.com/showing-error-with-pc-instprd-asp_topic3542_post13588.html#13588 Author: marketabilities
Subject: 3542
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

]]> Tue, 23 Mar 2010 10:36:45 +0000 https://forum.productcart.com/showing-error-with-pc-instprd-asp_topic3542_post13588.html#13588