Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 1 of 2
Error when approved
 
JC_citi
Jr. Member
 
Total Posts:  2
Joined:  2008-08-04
 

Hi,

I got below error message when approved product.

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magento/mag_catalog_product_entity`, CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `mag_eav_attribute_set` (`attribute_set_id`) ON DELETE)

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
william.wws
Jr. Member
 
Total Posts:  1
Joined:  2009-03-09
 

Hi Friends.
I´m getting the same error.
Ideas ?
Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Emperor
Sr. Member
 
Total Posts:  111
Joined:  2007-08-31
 

I’m getting the following error as well:

SQLSTATE[HY000]: General error: 1452 Cannot add or update a child row: a foreign key constraint fails (`magento-1_3_2_2`.`catalog_product_entity`, CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELE)

What can be done to fix this issue.

I am using version: 1.3.2.2. This is the first customer product I have added and tried to approve.

 
Magento Community Magento Community
Magento Community
Magento Community
 
oakRunk
Sr. Member
 
Total Posts:  117
Joined:  2008-09-15
 

this is the error i receive:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.ugiftcert_amount_config’ in ‘field list’

 
Magento Community Magento Community
Magento Community
Magento Community
 
indiarox
Jr. Member
 
Total Posts:  7
Joined:  2009-03-14
 

even i am getting this error is the solution avaliable
following is the error when I try to approve product

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`venadi_beta1/catalog_product_entity`, CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CA)

 
Magento Community Magento Community
Magento Community
Magento Community
 
oakRunk
Sr. Member
 
Total Posts:  117
Joined:  2008-09-15
 

I went to cache settings and pressed rebuild flat category (i think, one of those flat options) and my error went away...maybe you can be so lucky too =)

 
Magento Community Magento Community
Magento Community
Magento Community
 
indiarox
Jr. Member
 
Total Posts:  7
Joined:  2009-03-14
 

still facing same problem is it because i have added and removed some product attributes after defaul installation

 
Magento Community Magento Community
Magento Community
Magento Community
 
aishah
Member
 
Total Posts:  35
Joined:  2009-04-22
 

Same problem, other solutions?

 
Magento Community Magento Community
Magento Community
Magento Community
 
ebizmarts
Mentor
 
Avatar
Total Posts:  2202
Joined:  2008-03-10
Montevideo, Uruguay
 

Hi you all guys,

I have been trying to reproduce your bug without success, could you send us more details about how do you think you get it?
Meanwhile, you should try reinstall the module in the following order:
1st) uninstall the module using the magento connect manager
2nd) refresh the screen
3rd) run those SQL sentences, those will remove all the customerPartner DB info (this will clear your customers products’ list, but will maintain the approved ones in the product list)

DROP TABLE `customerpartner_entity_varchar`;
DROP TABLE `customerpartner_entity_text`;
DROP TABLE `customerpartner_entity_int`;
DROP TABLE `customerpartner_entity_decimal`;
DROP TABLE `customerpartner_entity_datetime`;
DROP TABLE `customerpartner_entity`;
DROP TABLE `customerpartner_aux`;

DELETE FROM `eav_entity_type` WHERE CONVERT(`eav_entity_type`.`entity_type_code` USING utf8) = ‘customerpartner_product’ LIMIT 1
DELETE FROM `core_resource` WHERE CONVERT(`core_resource`.`code` USING utf8) = ‘customerpartner_setup’ LIMIT 1

4th) install the module using the magento connect manager
5th) log out and log in at magento admin panel

Please, let us know if you get any kind of error, and please provide us with as much details as you can.

Regards,
Ebizmarts Team.

 
Magento Community Magento Community
Magento Community
Magento Community
 
p0tp0t
Jr. Member
 
Total Posts:  7
Joined:  2009-10-25
 

Was there a solution to this? I’m also getting this error. Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
p0tp0t
Jr. Member
 
Total Posts:  7
Joined:  2009-10-25
 

Anyone found a solution to this? Thanks in advance. smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
p0tp0t
Jr. Member
 
Total Posts:  7
Joined:  2009-10-25
 

Sorry for the double post. I thought the first one didn’t go thru. rasberry

 
Magento Community Magento Community
Magento Community
Magento Community
 
matte
Member
 
Total Posts:  54
Joined:  2008-12-04
Buonacompra
 

Same problem here and Flat catalog category and product give error!

 
Magento Community Magento Community
Magento Community
Magento Community
 
mageGuy
Jr. Member
 
Total Posts:  1
Joined:  2010-03-19
 

well even after “refresh flat catalog category “ i get the same error.... Any ideas please

 
Magento Community Magento Community
Magento Community
Magento Community
 
bi2c
Jr. Member
 
Total Posts:  6
Joined:  2010-03-18
 

Guys,

for those who got the error.

It s pretty straight forward that the issue comes from the ‘attribute_set_id’. The product (you are currently creating) need a attribute_set_id from eav_attribute_set table in the database.
if an attribute_set_id is not set then it fails, if an attribut_set_id doesnt exist , it also fails.

Backend : when you want to create a new product, magento asks you for an attribut set (and product type).
you have to know the attribute set id for each row in the dropdownlist (you can know all id from eav_attribute_set table in the database)
then you can set the attribute_set_id by
adding the line,

in file : Ebizmarts/Customerpartner/Controllers/ProductsController.php
in function approveAction()
under $magentoProductModel->setTaxClassId(’None’);

$magentoProductModel->setAttributeSetId(1); (or any the attribute_set_id you need for the product)

You should create your custom module to overwrite the file, instead of modifying directly Ebizmarts files.
Hope it helps.

Ed

 
Magento Community Magento Community
Magento Community
Magento Community
 
freedom4ever
Jr. Member
 
Total Posts:  1
Joined:  2010-07-24
 

I followed the above steps, the status still shows Unapproved and the product is added to Catalog
And i’m getting this error, please help

Mage registry key “_resource_singleton/customerpartner/product” already exists

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2