cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 1.9 - bundle product duplicated successfully but not visible on frontend

Highlighted
Senior Member

Magento 1.9 - bundle product duplicated successfully but not visible on frontend

I'm relative new to Magento coding, I'm updating a Magento e-commerce (vers. CE_1.9.2.1). After updating various patch (from SUPEE-6788 to SUPEE-9652) and the code written from the previous programmer, I faced some problems with duplicating and modifying bundle products.

In real, only with a specific attribute group.

When I duplicate a bundle with this specific group, the product comes duplicated correctly, but it is not visible on frontend (neither on its URL). I've already tried all kind of cache clean, reindexes, habilitation, web site viewes, category config, etc... But product is invisible on frontend, also if it is present on backend.

Another error, probably highly related with this, modifying the Option Titles in Bundle Items of an already exists bundle product (always with the same attribute group type), them remain as not changed in frontend, also if in backend (closing and reopening the page, also logging out, cleaning cache, etc..) the titles result set correctly (really strange!). Only on titles however, because I've also tried to remove some products from an option, and it was updated regularly also on frontend.

What could be the bug? How & Where I should watch for find how to debug this?

Any help is appreciated, Thanks.

EDIT

Magento throw this error on exception.log:

Next exception 'Zend_Db_Statement_Exception' with message 

'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'child_id' cannot be null, query was: INSERT INTO `mage_catalog_product_relation` (`parent_id`,`child_id`) VALUES (?, ?)' in /var/www/html/lib/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /var/www/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ma...', Array)
#4 /var/www/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ma...', Array)
#5 /var/www/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(2100): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ma...', Array)
#6 /var/www/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(2073): Varien_Db_Adapter_Pdo_Mysql->insertArray('mage_catalog_pr...', Array, Array)
#7 /var/www/html/app/code/core/Mage/Catalog/Model/Resource/Product/Relation.php(72): Varien_Db_Adapter_Pdo_Mysql->insertMultiple('mage_catalog_pr...', Array)
#8 /var/www/html/app/code/local/Mage/Bundle/Model/Resource/Bundle.php(122): Mage_Catalog_Model_Resource_Product_Relation->processRelations('441', Array)
#9 /var/www/html/app/code/local/Mage/Bundle/Model/Product/Type.php(395): Mage_Bundle_Model_Resource_Bundle->saveProductRelations('441', Array)
#10 /var/www/html/app/code/core/Mage/Catalog/Model/Product.php(541): Mage_Bundle_Model_Product_Type->save(Object(Mage_Catalog_Model_Product))
#11 /var/www/html/app/code/core/Mage/Core/Model/Abstract.php(319): Mage_Catalog_Model_Product->_afterSave()
#12 /var/www/html/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(728): Mage_Core_Model_Abstract->save()
#13 /var/www/html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Catalog_ProductController->saveAction()
#14 /var/www/html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('save')
#15 /var/www/html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#16 /var/www/html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#17 /var/www/html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#18 /var/www/html/index.php(150): Mage::run('', 'store')
#19 {main}
  • CE 1.9
  • magento1