Error 3201 when trying to add a product by cloning
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3472
Printed Date: 24-June-2025 at 3:38am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Error 3201 when trying to add a product by cloning
Posted By: new2pccart
Subject: Error 3201 when trying to add a product by cloning
Date 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.
|
Replies:
Posted By: ProductCart
Date 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 - 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 http://www.productcart.com" rel="nofollow - shopping cart software
|
Posted By: Scott T
Date 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
|
|