search

Vinai / groupscatalog2

Magento extension to enable you to hide categories and products from customers depending on their customer group. This is a Magento 1.6 and newer compatible version of the Netzarbeiter Customer Groups Catalog extension.
139 stars 60 forks source link

Index problems #8

Closed gmuth closed 12 years ago

gmuth commented 12 years ago

hello,

this extension worked fine for a short time, but after changing some products i got a problem with the index:

php5-cgi indexer.php --reindex groupscatalog2_product X-Powered-By: PHP/5.2.6-1+lenny16 Content-type: text/html

GroupsCatalog Products index process unknown error: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (usr_web39_5/m162_groupscatalog_product_idx, CONSTRAINT FK_41878AA4E9A9B3717EA6F0E40D944FB4 FOREIGN KEY (group_id) REFERENCES m162_customer_group (customer_group_id) ON DELETE CASCADE)' in /home/www/web39/html/magento/lib/Zend/Db/Statement/Pdo.php:228

tried to delete (including the attributes with SQL ) and reinstalled. still got the same problem :(

Zifius commented 12 years ago

Does deleting entries from groupscatalog_category_idx and groupscatalog_product_idx before reindex remedy the issue at least temporary?

gmuth commented 12 years ago

no, they are both empty

gmuth commented 12 years ago

ok, i don't know why, but i deleted and reinstalled it now again and again and its working! yeah!

Vinai commented 12 years ago

Thanks for jumping in Ziffius, and great you solved the issue yourself. I was too busy at Meet-Magento the last 2 days to be able to respond.