Giter VIP home page Giter VIP logo

groupscatalog2's People

Contributors

alexdrupal avatar kiatng avatar vinai avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

groupscatalog2's Issues

Can't rewrite GroupsCatalog products indexes

The following exception is thrown:

 Integrity constraint violation: 1062 Duplicate entry '64541-14-1' for key 'IDX_GROUPSCATALOG_PRODUCT_IDX_ENTITY_ID_GROUP_ID_STORE_ID' 

I think it's nearly the same problem like the one with categories you fixed yesterday.

Array attributes generate error notice

Eg
Notice: Array to string conversion in /app/code/community/Netzarbeiter/GroupsCatalog2/Model/Entity/Attribute/Source/Customergroup/Withdefault.php on line 70

The getOptionText method explodes the string before checking to see if it is a string

        if (strpos($value, ','))
        {
            $value = explode(',', $value);
        }

These notice messages rapidly fills up the system.log :-)

Reindexing throws error.

If I try to reindex using the gui, it gives an error that it can't reindex. If I try to reindex using the shell, it gives me the following:

$ php shell/indexer.php --reindex groupscatalog2_category
GroupsCatalog Categories index process unknown error:
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' in lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `index_p...', Array)
#5 lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `index_p...', Array)
#6 lib/Zend/Db/Adapter/Abstract.php(632): Varien_Db_Adapter_Pdo_Mysql->query('UPDATE `index_p...', Array)
#7 app/code/core/Mage/Index/Model/Resource/Process.php(137): Zend_Db_Adapter_Abstract->update('index_process', Array, Array)
#8 app/code/core/Mage/Index/Model/Resource/Process.php(109): Mage_Index_Model_Resource_Process->_updateProcessData('21', Array)
#9 app/code/core/Mage/Index/Model/Process.php(219): Mage_Index_Model_Resource_Process->failProcess(Object(Mage_Index_Model_Process))
#10 app/code/core/Mage/Index/Model/Process.php(253): Mage_Index_Model_Process->reindexAll()
#11 shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#12 shell/indexer.php(198): Mage_Shell_Compiler->run()
#13 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' in lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `index_p...', Array)
#4 lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `index_p...', Array)
#5 lib/Zend/Db/Adapter/Abstract.php(632): Varien_Db_Adapter_Pdo_Mysql->query('UPDATE `index_p...', Array)
#6 app/code/core/Mage/Index/Model/Resource/Process.php(137): Zend_Db_Adapter_Abstract->update('index_process', Array, Array)
#7 app/code/core/Mage/Index/Model/Resource/Process.php(109): Mage_Index_Model_Resource_Process->_updateProcessData('21', Array)
#8 app/code/core/Mage/Index/Model/Process.php(219): Mage_Index_Model_Resource_Process->failProcess(Object(Mage_Index_Model_Process))
#9 app/code/core/Mage/Index/Model/Process.php(253): Mage_Index_Model_Process->reindexAll()
#10 shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#11 shell/indexer.php(198): Mage_Shell_Compiler->run()
#12 {main}

This is due to that the indexer tries to import 90000 indexes with one query.

In file:

app/code/community/Netzarbeiter/GroupsCatalog2/Model/Indexer/Abstract.php

Replace:

$this->_getWriteAdapter()->insertMultiple($this->_getIndexTable(), $data);

With:

$chunks = array_chunk($data,1000);
foreach($chunks as $chunk)
{
    $this->_getWriteAdapter()->insertMultiple($this->_getIndexTable(), $chunk);
}

And that worked for me.

Netzarbeiter_GroupsCatalog2 SEO Sitemap

Hallo,

ich habe die Netzarbeiter_GroupsCatalog2 in Magento 1.6.2 installiert.
Nun funktioniert die SEO Sitemap nicht mehr.
Kannst du mir weiterhelfen?

Besten Dank

Frank Nerger

Problems with prices

I have downloaded and installed this pluging and all is working, just for one small exeption, when I put a product to the shopping cart, it does not give me the customer group price when this extension is installed, it gives me the normal price.

Any other that has experinced this or have and idea of what i can do?

Category login reguired : for certain user groups

Hi,

I am having 3 categories, Among them one of the category “Golf Clubs” will be accessible to certain user groups namely “Club members”. But the category should be visible when i click that it leads to a login page.

General Configuration:

Category Mode : Show category by Default
Hide Categories from : None

Category Configuration for “Golf Clubs” Category:

Hide from Groups: None
Show to groups : Club members

I think i made some mistake. Please correct and help me o this.

I think your module was the only free module which supports my needs. Please let me know the reply ASAP.

{{blocks}}, category settings and parent/root category settings

If I have a root category that is visible only to a certain group, but then I choose to remove all restrictions from a sub-category under it I'm finding that I still can' t access that subcategory from within a custom layout or {{block}} rule. I can access the sub-category via it's URL but I can't access it from XML or {{block}} syntax.

So as an example, say I have a CMS page which contains some new products called up like this:

{{block type="catalog/product_list" category_id="262" template="catalog/guest/new_products_homepage.phtml"}}

Then I set the root category to be visible only to logged in users and this new products category is set to be visible to all.
If I then visit the CMS page that holds the block it triggers an "Invalid category" exception.

    a:5:{i:0;s:17:"Invalid category.";i:1;s:3685:"#0 /var/data/mysite/web/app/code/core/Mage/Catalog/Model/Layer.php(191): 
Mage::throwException('Invalid categor...')

In the stack trace there's no sign of Groups catalog , but I can work around the problem by disabling Groups catalog so I'm sure it's coming from here.

My current solution is to set a registry key from my layout xml files that I then use to disable groups catalog on specific pages, so a tweak in Data.php like this

        public function isModuleActive($store = null, $checkAdmin = true)
    {
        $store = Mage::app()->getStore($store);
        if ($checkAdmin && $store->isAdmin())
        {
            return false;
        }
        //benz001
        //Check the registry for a disable flag and honour it
        if(Mage::registry('wh_disable_groups_ext') == 1){           
            //We don't care about stores here as we expect this to come from a store level template
            return false;
        }   
        //end benz001

        $setting = $this->getConfig('is_active', $store);
        return (bool) $setting;
    }

Then I create a new block to set/unset registry keys so I can trigger it from a theme.

So I'm not sure if this is a bug or a feature request:

  1. having an exception triggering response to inserting a {{block}} or seems like a bug,
  2. being able to deliberately 'punch holes' in the groups catalog system from the layout files feels very much like a useful new feature that themes can make use of.

Multistore products -> login

Hi,

I'm setting up our second store and came up with a strange issue.
When I enable 1 product to show up in 2 root categories (thus in 2 stores) in every store I have to login to see the product. These products are setup to be viewable by everyone.
When I disable the module in one of these stores for that specific store the problem has gone and I can view the product normal.

If I have a product which is only in 1 root category / store there is absolutely no problem. It only shows up after enabling the product in another store/category.

Does this sound familiar? (hope so...)

gr,
koen

503 error after unistalling everything according to your guides.

We want to uninstall the plugin and we run the db queries you provided and deleted all instances of the extension in the ftp. There is no error message only a 503 browser error and this sentence from magento :

Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Any ideas? How can we completely remove it? Our website is down and we cant access the admin...

Install issue

I installed module in a 1.7.0.2 site (site is upgraded from 1.6).

I get the following error in frontend:

a:5:{i:0;s:100:"Invalid backend model specified: netzarbeiter_groupscatalog2/entity_attribute_backend_customergroups";i:1;s:5368:"#0 /var/www/q/app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php(346): Mage::exception('Mage_Eav', 'Invalid backend...')
#1 /var/www/q/app/code/core/Mage/Eav/Model/Entity/Abstract.php(640): Mage_Eav_Model_Entity_Attribute_Abstract->getBackend()
#2 ...

And I get the following error in backend:

a:5:{i:0;s:29:"Indexer model is not defined.";i:1;s:3265:"#0 /var/www/q/app/code/core/Mage/Index/Model/Process.php(306): Mage::throwException('Indexer model i...')
#1 /var/www/q/app/code/core/Mage/Index/Block/Adminhtml/Notifications.php(41): Mage_Index_Model_Process->getIndexer()
#2 ...

If I unistall module, site is back to normal.

Any ideas?

thanks! //martin

category is not showing

Hello Vinai

I am using Mangeto 1.7.0.2, and I have encountered an issue that the category on the left side bar is not showing. It only shows one category, but not the other. I checked every set up and they are the same.

Here is the value of configuration:

Enable Module: enable
Product Mode: Hide product by default
Show Products to: Wholesale
Category Mode: Hide product by default
Show Products to: Wholesale
How to handle guests accessing a hidden entity: redirect to target route
Redirect route for guests: customer/account/login
How to handle logged in customers accessing a hidden entity: redirect to target route
Redirect route for logged in customers: b2b (CMS URL)
Display a message when a hidden entity is accessed?: Yes

And I have checked all the categories and products are set to "USE DEFAULT" value
Right now, only one category is showing, but not the rest when I login to the account.

Could you give me some advise how to solve this problem?

Sharon

Issue with product in cart which is hidden after login

We have a problem with this extension implemented at the webshop of one of our larger account Paula's Choice. Webshop details: Netzarbeiter_GroupsCatalog2 version 0.2.4. on Magento ver. 1.6.2.0 (currently in the process of upgrading to 1.7.2). They run a true European webshop selling cosmetics.

They use your extension to shield off products and categories from specific (consumer) customer groups.
The problem occurs in the following situation:
customer is logged out (guest) and places product Y and product Z in shopping cart (product Y can not be viewed by customer group X).
customer (member of customer group X) logs in. Account page is loaded with only 1 product in cart.
customer tries to go to cart and is placed in infinite loop. The only way to show the webshop again is to delete the cookies.
We think the extension should check -after log in- if the cart contains products that can not be viewed and removes these products from the cart.

Could you advise on how we may proceed with this problem?

Reindexing not working with plugin installed.

screen shot 2013-05-03 at 9 22 52 am

If I uninstall the module, then it goes back to working like normal. I'm just a frontend dev so I'm not sure how to check specifics or error logs, but I'm running Magento 1.7.0.2 and using the Connect Manager install link.

Thanks!

Error 404

System -> Configuration -> NETARBEITER EXTENSIONS / Groups Catalog 2 -> Page not Found (404)

I have this problem in version 0.2.4 (beta)

Very slow query

Hello,

After installed the extension, we have a query that is loading more than 2 hours and is growing for 3GB in tmp table

This is the query

SELECT `count_table`.`category_id`, COUNT(DISTINCT count_table.product_id) AS `product_count`
   FROM `catalog_product_entity` AS `e`
   INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='149' 
   INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 
   LEFT JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '65') AND `at_name_default`.`store_id` = 0 
   LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '65') AND (`at_name`.`store_id` = 1)
   INNER JOIN `groupscatalog_product_idx` ON e.entity_id=groupscatalog_product_idx.entity_id AND groupscatalog_product_idx.group_id=0 AND groupscatalog_product_idx.store_id=1
   INNER JOIN `catalog_category_product_index` AS `count_table` ON count_table.product_id = e.entity_id
   INNER JOIN `groupscatalog_product_idx` AS `groupscatalog_product_idx_2` ON groupscatalog_product_idx.entity_id=e.entity_id AND groupscatalog_product_idx.group_id=0 AND groupscatalog_product_idx.store_id=1
   WHERE
   (
      (
         (price_index.min_price -(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 6 THEN 0.0600 WHEN 7 THEN 0.2100 ELSE 0 END))*CASE price_index.tax_class_id WHEN 6 THEN 0.0600 WHEN 7 THEN 0.2100 ELSE 0 END)
         +((price_index.min_price-(price_index.min_price/(1+(CASE price_index.tax_class_id WHEN 6 THEN 0.0600 WHEN 7 THEN 0.2100 ELSE 0 END))*CASE price_index.tax_class_id WHEN 6 THEN 0.0600 WHEN 7 THEN 0.2100 ELSE 0 END))
         *CASE price_index.tax_class_id WHEN 6 THEN 0.0600 WHEN 7 THEN 0.2100 ELSE 0 END))
      * 1)
    <= 100)
   AND (count_table.store_id = 1)
   AND (count_table.category_id IN ('189', '190', '191', '192', '193', '194', '195', '196', '197', '288'))
   GROUP BY `count_table`.`category_id`

Best regards

Catalogue gone after groupscatalog2 installed

Hi, I have installed your extension however right after installation my catalogue is gone. tried to uninstall the extension following you instructions in magentoconnect then the entire site shows multiple errors.
Is there any otherway to uninstall ? Thanks

Error after Install

Hey there,

Wonderful extension! Looking forward to take advantage of it.

In the meantime, I have come across the below errors after install. Magento is stock, no changes made to the code, design, etc. Only added my own theme.

I am running on 1.7.0.2
Extension Version: 0.2.7

Please let me know if I can provide any additional information.

I receive the following when trying to access the configuration for the extension:

Fatal error: Class 'Netzarbeiter_GroupsCatalog2_Model_System_Config_Backend_Customergroup_Abstract' not found in /var/www/vhosts/test.com/httpdocs/magento/app/code/community/Netzarbeiter/GroupsCatalog2/Model/System/Config/Backend/Customergroup/Product.php on line 25

Also, I am asked to re-index the following databases:

GroupsCatalog Products
GroupsCatalog Categories

However, upon re-indexing, I receive the following error:

There was a problem with reindexing process.

And lastly, when trying to access the FrontEnd:

SELECT `e`.* FROM `catalog_product_entity` AS `e`
 INNER JOIN `groupscatalog_product_idx` ON groupscatalog_product_idx.catalog_entity_id=e.entity_id AND groupscatalog_product_idx.group_id='6' AND groupscatalog_product_idx.store_id=1 WHERE (`e`.`entity_id` IN(42, 42))



Trace:
#0 /var/www/vhosts/test.com/httpdocs/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/test.com/httpdocs/magento/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/vhosts/test.com/httpdocs/magento/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/test.com/httpdocs/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `e`.* FR...', Array)
#4 /var/www/vhosts/test.com/httpdocs/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.* FR...', Array)
#5 /var/www/vhosts/test.com/httpdocs/magento/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `e`.* FR...', Array)
#6 /var/www/vhosts/test.com/httpdocs/magento/lib/Varien/Data/Collection/Db.php(734): Zend_Db_Adapter_Abstract->fetchAll('SELECT `e`.* FR...', Array)
#7 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1047): Varien_Data_Collection_Db->_fetchAll('SELECT `e`.* FR...')
#8 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#9 /var/www/vhosts/test.com/httpdocs/magento/lib/Varien/Data/Collection.php(741): Mage_Eav_Model_Entity_Collection_Abstract->load()
#10 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Collection.php(1473): Varien_Data_Collection->getIterator()
#11 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Sales/Model/Resource/Quote/Item/Collection.php(182): Mage_Catalog_Model_Resource_Product_Collection->addOptionsToResult()
#12 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Sales/Model/Resource/Quote/Item/Collection.php(139): Mage_Sales_Model_Resource_Quote_Item_Collection->_assignProducts()
#13 /var/www/vhosts/test.com/httpdocs/magento/lib/Varien/Data/Collection/Db.php(581): Mage_Sales_Model_Resource_Quote_Item_Collection->_afterLoad()
#14 /var/www/vhosts/test.com/httpdocs/magento/lib/Varien/Data/Collection.php(741): Varien_Data_Collection_Db->load()
#15 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Sales/Model/Quote.php(736): Varien_Data_Collection->getIterator()
#16 /var/www/vhosts/test.com/httpdocs/magento/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Observer.php(211): Mage_Sales_Model_Quote->getAllVisibleItems()
#17 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Model/App.php(1338): Netzarbeiter_GroupsCatalog2_Model_Observer->salesQuoteLoadAfter(Object(Varien_Event_Observer))
#18 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Netzarbeiter_GroupsCatalog2_Model_Observer), 'salesQuoteLoadA...', Object(Varien_Event_Observer))
#19 /var/www/vhosts/test.com/httpdocs/magento/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent('sales_quote_loa...', Array)
#20 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Model/Abstract.php(267): Mage::dispatchEvent('sales_quote_loa...', Array)
#21 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Sales/Model/Quote.php(1841): Mage_Core_Model_Abstract->_afterLoad()
#22 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Sales/Model/Quote.php(367): Mage_Sales_Model_Quote->_afterLoad()
#23 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Checkout/Model/Session.php(120): Mage_Sales_Model_Quote->loadActive('328')
#24 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Checkout/Model/Cart.php(119): Mage_Checkout_Model_Session->getQuote()
#25 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Checkout/Model/Cart.php(552): Mage_Checkout_Model_Cart->getQuote()
#26 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Checkout/Model/Cart.php(527): Mage_Checkout_Model_Cart->getItemsQty()
#27 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Checkout/Helper/Cart.php(141): Mage_Checkout_Model_Cart->getSummaryQty()
#28 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Checkout/Block/Links.php(46): Mage_Checkout_Helper_Cart->getSummaryCount()
#29 [internal function]: Mage_Checkout_Block_Links->addCartLink()
#30 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Model/Layout.php(348): call_user_func_array(Array, Array)
#31 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Model/Layout.php(214): Mage_Core_Model_Layout->_generateAction(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#32 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Model/Layout.php(206): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#33 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#34 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
#35 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Cms/Helper/Page.php(113): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#36 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home')
#37 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home')
#38 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Cms_IndexController->indexAction()
#39 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index')
#40 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#41 /var/www/vhosts/test.com/httpdocs/magento/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#42 /var/www/vhosts/test.com/httpdocs/magento/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#43 /var/www/vhosts/test.com/httpdocs/magento/index.php(88): Mage::run('', 'store')
#44 {main}

Thank you!

Jeremy

Heavy Database Load

Quote from Email:
Hello we would like to use your very nice module Group Catalog2. We're running Magento 1.7.0.2, it's 1 store with 3 storeviews (3 languages).
When we installed your module everything is working perfect, however the database load is becoming very high so our hosting provider doesn't like it :) .

Is there any way to fix this, or could you help us to resolve this problem?

Category login reguired : for certain user groups

Hi,

I am having 3 categories, Among them one of the category “Golf Clubs” will be accessible to certain user groups namely “Club members”. But the category should be visible when i click that it leads to a login page.

General Configuration:

Category Mode : Show category by Default
Hide Categories from : None

Category Configuration for “Golf Clubs” Category:

Hide from Groups: None
Show to groups : Club members

I think i made some mistake. Please correct and help me o this.

I think your module was the only free module which supports my needs. Please let me know the reply ASAP.

Mage_Eav_Model_Entity_Collection_Abstract, instance of Mage_Catalog_Model_Resource_Category_Flat_Collection

Hello,

When i try to activate your module in Magento 1.6.2.0, front crash with no response.

In var/system.log :

2012-09-26T11:06:03+00:00 ERR (3): Recoverable Error: Argument 1 passed to Netzarbeiter_GroupsCatalog2_Model_Resource_Filter::addGroupsCatalogFilterToCollection() must be an instance of Mage_Eav_Model_Entity_Collection_Abstract, instance of Mage_Catalog_Model_Resource_Category_Flat_Collection given, called in /app/code/community/Netzarbeiter/GroupsCatalog2/Model/Observer.php on line 377 and defined in /app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Filter.php on line 59

And in database, we have many request :
SELECT main_table.entity_id, main_table.level, main_table.path, main_table.position, main_table.is_active, main_table.is_anchor, main_table.name, url_rewrite.request_path FROM catalog_category_flat_store_1 AS main_table
LEFT JOIN core_url_rewrite AS url_rewrite ON url_rewrite.category_id=main_table.entity_id AND url_rewrite.is_system=1 AND url_rewrite.product_id IS NULL AND url_rewrite.store_id='1' AND url_rewrite.id_path LIKE 'category/%'
INNER JOIN groupscatalog_category_idx ON main_table.entity_id=groupscatalog_category_idx.entity_id AND groupscatalog_category_idx.group_id=0 AND groupscatalog_category_idx.store_id=1
INNER JOIN groupscatalog_category_idx AS groupscatalog_category_idx_2 ON main_table.entity_id=groupscatalog_category_idx.entity_id AND groupscatalog_category_idx.group_id=0 AND groupscatalog_category_idx.store_id=1 WHERE (path LIKE '1/2/3/%') AND (main_table.store_id = '1') AND (is_active = '1') AND (include_in_menu = '1') ORDER BY name ASC

I think it's cause by many module installed on this Magento.

Please contact me to solve this problems.

Thanx Vinaï.

Wishlist stops working if extension is enabled

Greetings!

First thanks!, its a great extension and every Magento should have it... After a while using it i realize the "wishlist" option won't work anymore, and after looking why I end up with groupscatalog2 extension, this is the error that shows me, any idea how to solve?:

a:5:{i:0;s:66:"Item (Mage_Wishlist_Model_Item) with the same id "5" already exist";i:1;s:3971:"

#0 /var/www/lib/Varien/Data/Collection/Db.php(576): Varien_Data_Collection->addItem(Object(Mage_Wishlist_Model_Item))
#1 /var/www/lib/Varien/Data/Collection.php(752): Varien_Data_Collection_Db->load()
#2 [internal function]: Varien_Data_Collection->count()

#3 /var/www/app/design/frontend/base/default/template/wishlist/item/list.phtml(39): count(Object(Netzarbeiter_GroupsCatalog2_Model_Wishlist_Resource_Item_Collection))

#4 /var/www/app/code/core/Mage/Core/Block/Template.php(241): include('/var/www/app/de...')

...

#37 {main}";s:3:"url";s:10:"/wishlist/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

Thanks,

Santiago

Issues with price filter

Hi,

I've installed the plugin and it works perfectly apart from one thing:

On a category listing page where you can filter by price, it seems to include all products in the menu not the ones displayed to the current user.

example:
I have a product that costs £4000 which is available to a logged in group. All other publicly available products are less than £1000. If I go to the site and don't log in, the filter by price nav displays:

£0.00 - £999.99 (132)
£4,000.00 And Above (1)

Clicking on the £4000.00 And Above link goes to a page saying no products in category. Which is correct as they're only available to a logged in user.

Is there a way to get the nav to only show the products available to the current user?

Thanks
Steve Jones

Problems with install

Hi,
We are using the original Netzarbeiter_GroupsCatalog on our first store (ver. 1.7.2) we built in August. It is working fine. We are building a 2nd store and I manually installed (not through Magento Connect) the upgraded Netzarbeiter_GroupsCatalog2 and it turns our backend into a blank page with only the admin header.

Is there anywhere I can download the original Netzarbeiter_GroupsCatalog (I can't use Magento Connect because that function for some reason isn't working) or do you happen to know why the Netzarbeiter_GroupsCatalog2 doesn't work on our ver 1.7.2?

Thanks in advance.

Michelle

Fatal error: Class 'Mage_Netzarbeiter_Groupscatalog2_Block_Adminhtml_Data_Form_Customergroup' not found in /.../lib/Varien/Data/Form/Abstract.php on line 146

I uninstall the module and everything worked correctly until I create attribute_set
After that when I wanted to see the product I get this error
Fatal error: Class 'Mage_Netzarbeiter_Groupscatalog2_Block_Adminhtml_Data_Form_Customergroup' not found in /.../lib/Varien/Data/Form/Abstract.php on line 146

I reinstalled the module, I could see the product, after uninstall it, again I get this error.

Index problems

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 :(

Issue related to default values for Show to / Hide from groups

Hi,

I noticed a strange behavior of the extension regarding the default parameters. Here is what I observed :

Let's have the following configuration :

  • Extension active by default with option "Hide products by default"
  • Extension active on store 1 with option "Show products by default"

Then, product A has the following config :

  • by default, "Show to groups" is set to [USE DEFAULT]
  • for store 1, "Hide from groups" use the default value of the product.

In that configuration, product A will never show up in store 1, although IMHO it should, because :

  • store 1 default behavior is "Show products by default"
  • product A "Hide from groups" for store 1 is using the default product value, which is "[USE DEFAULT]".

However, what seems to happen is that if the default value of the product is used for the "Hide from Groups" field, the default behavior will be applied too, regardless of the actual default behavior of the current store.

Note : if I disable the extension by default afterwards, the previous setting continues to be applied.

Did you notice the same behavior ? And if yes, do you know how to fix it ?

Thanks,
Olivier.

Hidden products in order history cause redirect

Quote from email:
I have an error for customers logging in to my site that i think i've narrowed down to the catalog module.

When logging in, instead of being redirected to the account dashboard as requested, i get redirected to the home page with /cms/ added to the domain. Order history and account dashboard are not viewable. however all other account pages are.

CSV Product import

when we import products via csv the group NOT LOGGED IN is not set.
All other groups are set correctly, only when we import groupskatalog2 "NOT LOGGED IN"
this value is not set correctly?

Related products from restricted categories

Hi,
first of all thanks for this must have extension, came really handy for me today

I have a situation when for a group one category is restricted while other is not. These categories share same products though they differ a bit. Products are not restricted at all (can't do so because I'd have to enter them twice)
Now I have situation when in related products block products from the restricted category appear. Is this something could be resolved in the extension or it works as designed?

Thank you,
Alex

Upgrading to 0.2.7 from 0.1.0 fails, missing columns in groupscatalog_category_idx

The upgrade SQL file is called upgrade-0.2.4-0.2.5.php so if you get version 0.2.7 from GitHub and you were on an earlier release like 0.1 then the upgrade SQL doesn't run.

So the fix is rename the file to upgrade-0.2.4-0.2.7.php and re-run the installation.

If this error has already hit you then you can fix it in your installation by renaming the script then in your database drop the core_resource version back to your earlier release and hit the site again, this will retrigger the installer.

Don't index disabled products or stores with disabled module

[From email]:
My company currently uses your GroupCatalog2 module for a multi store
setup. We found an issue which is causing us significant heart ache.
Your module creates an index for every product for every group and
every store. Even where the output is disabled. For our configuration
this is not optimal as the resulting index table is over 1.5million
records. Is there a way to disable the indexing for stores where the
module is disabled and where the product is not listed? Any help is
appreciated, thank you.

[Feature] Redirect

Redirect to the parent directory instead of to an error page.

Thank you for your support!

Can't find 'Netzarbeiter Extensions' in /System/Configuration

Hi, I'm using your Groups Catalog 2 plugin

'Then visit the configuration page at System / Configuration / Netzarbeiter Extensions / Groups Catalog 2 and configure as needed.'

<-- There is no 'Netzarbeiter Extensions' in System > Configuration

As far as I can tell, the plugin installed fine and is active (I also logged out/in)

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /home/(username)/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php on line 357

Hi

I am getting the below Fatal error when I re-index groupscatalog2_product manually, any idea why and what I can do to fix it.

When I re-index groupscatalog2_category it indexes successfully, HELP :(

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /home/comamari/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php on line 357

Do I need to increase php memory?

Many thanks

Amer Laldin (M.D)

GroupsCatalog Categories and GroupsCatalog Products cannot rebuild the indexes

Hi Vinai,

I have a problem with one of your extensions (groupscatalog2).

I cannot manage to reindex GroupsCatalog Categories and GroupsCatalog Products.
Also, when activating the extension all menus and products dissapear

Do you have any idea where to start looking at?

I have a Magento CE 1.7.0.2

Not sure if it helps but..

Extension Installed are:
AddThis_SharingTool
Aoe_Scheduler
ArtsOnIT_OfflineMaintenance
Auguria_Sponsorship
Belvg_All
Belvg_FacebookFree
Clockworkgeek_Rememberme
Devinc_Multipledeals
Ebizmarts_MageMonkey
Ebizmarts_Mandrill
Idev_OneStepCheckout
Mage_Admin
Mage_AdminNotification
Mage_Api
Mage_Api2
Mage_Authorizenet
Mage_Backup
Mage_Bundle
Mage_Captcha
Mage_Catalog
Mage_CatalogIndex
Mage_CatalogInventory
Mage_CatalogRule
Mage_CatalogSearch
Mage_Centinel
Mage_Checkout
Mage_Cms
Mage_Compiler
Mage_Connect
Mage_Contacts
Mage_Core
Mage_Cron
Mage_CurrencySymbol
Mage_Customer
Mage_Dataflow
Mage_Directory
Mage_Downloadable
Mage_Eav
Mage_GiftMessage
Mage_GoogleAnalytics
Mage_GoogleCheckout
Mage_ImportExport
Mage_Index
Mage_Install
Mage_Log
Mage_Media
Mage_Newsletter
Mage_Oauth
Mage_Page
Mage_PageCache
Mage_Paygate
Mage_Payment
Mage_Paypal
Mage_PaypalUk
Mage_Persistent
Mage_Poll
Mage_ProductAlert
Mage_Rating
Mage_Reports
Mage_Review
Mage_Rss
Mage_Rule
Mage_Sales
Mage_SalesRule
Mage_Sendfriend
Mage_Shipping
Mage_Sitemap
Mage_Tag
Mage_Tax
Mage_Usa
Mage_Weee
Mage_Widget
Mage_Wishlist
Mage_XmlConnect
Netzarbeiter_GroupsCatalog2
Netzarbeiter_LoginCatalog
OrganicInternet_SimpleConfigurableProducts
Phoenix_Moneybookers
TBT_Enhancedgrid

When attempting to rebuild the indexes, the stack-traces in the file var/log/exception.log related to this are:

2012-10-05T02:02:53+00:00 DEBUG (7): Exception message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.value' in 'field list' Trace: 0 /home/sites/domainname.com/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) 1 /home/sites/domainname.com/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array) 2 /home/sites/domainname.com/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) 3 /home/sites/domainname.com/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `e`.`ent...', Array) 4 /home/sites/domainname.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.`ent...', Array) 5 /home/sites/domainname.com/public_html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array) 6 /home/sites/domainname.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(172): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select)) 7 /home/sites/domainname.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(136): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity() 8 /home/sites/domainname.com/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll() 9 /home/sites/domainname.com/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll() 10 /home/sites/domainname.com/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll() 11 /home/sites/domainname.com/public_html/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(124): Mage_Index_Model_Process->reindexEverything() 12 /home/sites/domainname.com/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Index_Adminhtml_ProcessController->reindexProcessAction() 13 /home/sites/domainname.com/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('reindexProcess') 14 /home/sites/domainname.com/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) 15 /home/sites/domainname.com/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() 16 /home/sites/domainname.com/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array) 17 /home/sites/domainname.com/public_html/index.php(87): Mage::run('', 'store') 18 {main}

2012-10-05T02:02:59+00:00 DEBUG (7): Exception message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.value' in 'field list' Trace: 0 /home/sites/domainname.com/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) 1 /home/sites/domainname.com/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array) 2 /home/sites/domainname.com/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) 3 /home/sites/domainname.com/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `e`.`ent...', Array) 4 /home/sites/domainname.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.`ent...', Array) 5 /home/sites/domainname.com/public_html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array) 6 /home/sites/domainname.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(172): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select)) 7 /home/sites/domainname.com/public_html/app/code/community/Netzarbeiter/GroupsCatalog2/Model/Resource/Indexer/Abstract.php(136): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->_reindexEntity() 8 /home/sites/domainname.com/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Netzarbeiter_GroupsCatalog2_Model_Resource_Indexer_Abstract->reindexAll() 9 /home/sites/domainname.com/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll() 10 /home/sites/domainname.com/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll() 11 /home/sites/domainname.com/public_html/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(124): Mage_Index_Model_Process->reindexEverything() 12 /home/sites/domainname.com/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Index_Adminhtml_ProcessController->reindexProcessAction() 13 /home/sites/domainname.com/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('reindexProcess') 14 /home/sites/domainname.com/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) 15 /home/sites/domainname.com/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() 16 /home/sites/domainname.com/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array) 17 /home/sites/domainname.com/public_html/index.php(87): Mage::run('', 'store') 18 {main}

Migration tool shouldn't need old files to be present

If the database is set up for groups catalog 1, but the groups catalog 1 files aren't present it would still be great if we could run the migration assistant.

This scenario happened to me after upgrading form 1.3 to 1.6, the cleanest upgrade path came from using a fresh install of 1.6 and then letting it up-rev the database - but of course this confuses the migration tool.

In this scenario $this->isGroupsCatalogInstallResourcePresent() returns true but $this->isGroupsCatalogInstalled() returns false.

So that means if you look at migration.phtml you will see most of the page content , but can't take any actions - and most of the actions are still perfectly applicable.

Perhaps if you added a method to Netzarbeiter_GroupsCatalog2_Block_Adminhtml_System_Tools_Migration like

public function areCatalog1FilesPreset(){ 
    /*
    Check if any of these exist
        'app/etc/modules/Netzarbeiter_GroupsCatalog.xml',
        'app/code/community/Netzarbeiter/GroupsCatalog/',
        'app/locale/de_DE/Netzarbeiter_GroupsCatalog.csv',
        'app/locale/en_US/Netzarbeiter_GroupsCatalog.csv',
        'app/locale/fr_FR/Netzarbeiter_GroupsCatalog.csv',
        'app/locale/nl_NL/Netzarbeiter_GroupsCatalog.csv'
    */
}

Then you could change the migration.phtml page to work more like a migration checklist showing either a tick or a button against each step.

The products are not being restricted based on customer group in my store

I am trying to show one set of products when the customer group ID is 4 and a different set (similar products but with different prices) when the customer group ID is NOT 4

I have configured this in the Magento admin but it's just not working. Any advice?

To recreate the problem clear cookies and visit this link:

You will see the results are the same...

The reason behind me doing this is to basically show a different set of prices based on the link we provide to the customers. If you know a better way to achieve this then I'm all ears.

Many thanks,
Chris

Disappearing Menu items

Hey Vinai,

I've installed your extension and it seemed to work fine at first but now I have a few problems. I assigned a customer to a group, then created a category hiding it from everybody except this new group.

When I log in with this user's details, my main menu disappears. Can you help please?

Regards,

Karen

[Feature] Products "inherit" rules from categories.

Implement new feature:

During indexing for product entities:

  • apply the most restricting rules from any category a product is assigned to
  • if the product has more restricting rules, use those.

The result would be, that for a given store, any group that is unable to access a category a product is assigned to, or is unable to access a product individually, would be unable to access that product.

So in effect it would be enough to manage visibility rules for categories, and products are hidden automatically.

A side effect would be slower indexing because of the increased processing overhead.

Optional: make this configurable on a per-category basis?

Delete a website from Magento, unable to index Groups Catalog after

I have a Magento instance with 2 websites and around 5000 skus, I change the second website to be the default site and then delete the first (this is all on a staging server of course),

After doing that I'm unable to index GroupsCatalog Products without getting out of memory errors.

I then flush out all orders and customers from the history, so the only thing in the database is the 5000 skus - of course this makes no difference as it's not hitting that part of the DB.

I've tried merging in the indexing patch from 017d395 with no improvement I'm afraid.

Installation failed - Exception during cache and session cleaning

I have two magento 1.7.0.2 installations and have tried to install groups catalog 2 with magento connect. On both installations I have become this error (Exception during cache and session cleaning) during installation. After this, i can't open the frontend and the backend: There has been an error processing your request.

In var/report/ I find this:

a:5:{i:0;s:285:"Error in file: "/var/www/magento/app/code/community/Netzarbeiter/GroupsCatalog2/sql/netzarbeiter_groupscatalog2_setup/upgrade-0.2.4-0.2.5.php" - SQLSTATE[HY000]: General error: 1025 Error on rename of './www1063072/#sql-388_1ce' to './www1063072/groupscatalog_product_idx' (errno: 150)";i:1;s:898:"#0 /var/www/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /var/www/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '0.1.0', '0.2.5')
#2 /var/www/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('0.1.0', '0.2.5')
#3 /var/www/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /var/www/magento/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /var/www/magento/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App->_initModules()
#6 /var/www/magento/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /var/www/magento/index.php(87): Mage::run('', 'store')
#8 {main}";s:3:"url";s:9:"/magento/";s:11:"script_name";s:18:"/magento/index.php";s:4:"skin";s:7:"default";}

Can you help?

Regards
Daniel

some group products not working

On some grouped products the product will not go into cart. there is no rhyme and reason as to which work and which don't

About redirect to target route

Hello,

I have a problem to redirect customers to homepage instead of account admin panel. I tried to use "Redirect to target route" in "How to handle logged in customers accessing a hidden entity" field and place the route as "cms/index/index" or "cms/page/view/id/home", but it acts like it redirects to parent directory as if I clicked on the shipment terms at first, then login, it will redirect me to the shipment terms page, and if I didn't click on any page, then it will redirect me to the account admin page.

Could you help to give me advice how to redirect customers to homepage?

Sharon

Varien Class issue after install

Vinai,

Really enjoy the concept of this plugin, however we seem to be having issues getting it to work properly. Here is the issue we're receiving when we try to go into to the catalog configuration area (It has been redacted to keep out clients site id private):

Fatal error: Class 'Mage_Groupscatalog_Block_Adminhtml_Catalog_Product_Helper_Customergroups' not found in /home/b******/public_html/s*************.com/lib/Varien/Data/Form/Abstract.php on line 144

Do you have any ideas why this might be doing this? The Magento version we're using is 1.6.2; cache has been cleared and the indexes re-indexed. The following setting are setup in the plugin:

/----Begin----/
Enable Module: (bool) True

Product Mode: Show Products by Default
Hide Products from: NOT LOGGED IN and General Sales

Category Mode: Show Products by Default
Hide Categories from: NOT LOGGED IN and General Sales

How to handle guests accessing a hidden entity: Redirect
Redirect route for guests: customer/account/login

How to handle logged in customers accessing a hidden entity: Redirect
Redirect route for logged in customers: {{HOME_URL}}/custom/moreinfo.html (This is a CMS page)

Display a message when a hidden entity is accessed?: No
Auto refresh CATEGORY cache

Automatically refresh the CATEGORY BLOCK HTML cache to update the category navigation when the visibility setting for a category is changed. : (bool) True (Yes)
/----End----/

Any pointers on how to get this working would bee great! Thank you for your time.

-Josh

Fatal error: Class 'Netzarbeiter_GroupsCatalog2_Helper_Data'

Hi there,

I have just installed GroupsCatalog2 per instruction.

im on magento community 1.7

What i did:

  1. Dissable compiler
  2. Clear all cache
  3. Install the module
  4. log out of admin
  5. log back in amin
  6. Configured the module and it works flawlessly

however when i enable compiler i get this error and the site stop working all together

Fatal error: Class 'Netzarbeiter_GroupsCatalog2_Helper_Data' not found in /home/xxx/public_html/app/Mage.php on line 546

I then went to my backend via mysite/downloader and reinstall the compiler module to get back the site.

but when and everytime i enable compiler i will get the same error

anychance if you could help

please please

regards

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.