Error 3201 when trying to add a product by cloning

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I am new to Product Cart (took over from someone else) and tried to add a new product to my store by cloning an existing product. The two products are identical except for the picture and description and different sku and name.

The product shows up in my store, but when I go to my website to the product category, I get an error message that there is a problem with the store and when I go to help this is what I get. I deleted the new product once and tried to re-add it both as a new product (same error; I deleted the product) and as a cloned product again (same error; I deleted the product):

Error Number: 3021

Source: ADODB.Field

Description: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

query=SELECT idDiscountperquantity FROM discountsperquantity WHERE idproduct=3812 and discountPerUnit<>0

Request Method: GET

Server Port: 80

HTTPS: off

Local Address: 10.0.0.2

Host Address: 24.159.38.172

User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.5 (KHTML, like Gecko) Chrome/4.0.249.89 Safari/532.5

URL: /tanningbeds/pc/viewCategories.asp

HTTP Headers: hottanningbeds.com, en-US,en;q=0.8

Once I delete the new product, my store works fine. I have no idea why this is happening, what it means, or how to fix it.

This is not the most intuitive shopping cart I've ever worked with.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
new2pccart Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 26-February-2010 Status: Offline Points: 0	Post Options Post Reply Quote new2pccart Report Post Thanks(0) Quote Reply Topic: Error 3201 when trying to add a product by cloning Posted: 26-February-2010 at 3:05pm
	I am new to Product Cart (took over from someone else) and tried to add a new product to my store by cloning an existing product. The two products are identical except for the picture and description and different sku and name. The product shows up in my store, but when I go to my website to the product category, I get an error message that there is a problem with the store and when I go to help this is what I get. I deleted the new product once and tried to re-add it both as a new product (same error; I deleted the product) and as a cloned product again (same error; I deleted the product): Error Number: 3021 Source: ADODB.Field Description: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. query=SELECT idDiscountperquantity FROM discountsperquantity WHERE idproduct=3812 and discountPerUnit<>0 Request Method: GET Server Port: 80 HTTPS: off Local Address: 10.0.0.2 Host Address: 24.159.38.172 User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.5 (KHTML, like Gecko) Chrome/4.0.249.89 Safari/532.5 URL: /tanningbeds/pc/viewCategories.asp HTTP Headers: hottanningbeds.com, en-US,en;q=0.8 Once I delete the new product, my store works fine. I have no idea why this is happening, what it means, or how to fix it. This is not the most intuitive shopping cart I've ever worked with.

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 26-February-2010 at 4:09pm
	This is definitely not an issue that we are aware of. (1) Make sure that the store has been correctly setup. Restore default files if any files have been customized (making a back-up copy of the customized files). (2) Make sure that the database type in the file "includes/storeconstants.asp" is correct (Access vs. SQL). This is a setting that should never change, which is why there is no interface to edit it directly in the Control Panel. However, maybe a mistake was made at the time of setup or the store database was moved from Access to SQL. To find more information on the error, try printing raw errors to the screen by following this article in the ProductCart documentation: http://wiki.earlyimpact.com/how_to/show_raw_errors If you cannot find the source of the problem, certainly open a support ticket.
	The ProductCart Team Home of ProductCart shopping cart software

Scott T Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 10-March-2011 Location: Laramie, WY Status: Offline Points: 0	Post Options Post Reply Quote Scott T Report Post Thanks(0) Quote Reply Posted: 10-March-2011 at 11:06am
	After removing an option, we are getting error 3021 if that item is in a person's shopping cart.We can't remove the item from the cart either. HTTP_CACHE_CONTROL:max-age=0 HTTP_CONNECTION:keep-alive HTTP_KEEP_ALIVE:115 HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8 HTTP_ACCEPT_CHARSET:ISO-8859-1,utf-8;q=0.7,*;q=0.7 HTTP_ACCEPT_ENCODING:gzip,deflate HTTP_ACCEPT_LANGUAGE:en-us,en;q=0.5 HTTP_COOKIE:returnpath=no%20match; pcfront%5FvisitedPrds=%2A314%2A56%2A91%2A158%2A52%2A48%2A60%2A59%2A151%2A74%2A; pcfront%5FvisitedPrdsCP=%2A99%2A314%2A313%2A97%2A167%2A74%2A305%2A306%2A299%2A293%2A; __utma=8046757.1388687850.1294897922.1299738236.1299768439.91; __utmz=8046757.1299768439.91.77.utmcsr=tradingcomputers.com\|utmccn=(referral)\|utmcmd=referral\|utmcct=/TCarrays.html; SavedCartGUID=0548A04D%2DA9C6%2D4789%2DA1CF%2DAC5B5703A64E; ASPSESSIONIDQEDBBTBR=JAPDPMEAEHAKMOKIEKFGKABN; __utmb=8046757.6.10.1299768439; __utmc=8046757; multiplewidgets=true,true,true,true HTTP_HOST:falcon-checkout.com HTTP_REFERER:https://falcon-checkout.com/store/pc/techErr.asp?err= HTTP_USER_AGENT:Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8
	Scott