Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
Old 08-04-2012, 08:09 PM Magento help needed
Junior Talker

Posts: 2
Trades: 0
Magento 1.7
1. Can't publish prducts after installation the theme Fortis.
Settings of products are correct: stock - no, enable, category - checked.
When I tried fresh install of Magento everything worked correctly.
After I enable Fortis theme and tried to create a product, product is not shown frontend.
2. I also admited that I can't reindex price issue.
I tried plenty solutions in the forums but nohing helps.
Who knows what is it?
Here is the part of log.
Code:
2012-08-03T02:39:36+00:00 DEBUG (7): Exception message: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1
Trace: #0 /html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#4 /html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#5 /html/app/code/local/Innoexts/StorePricing/Model/Mysql4/Downloadable/Indexer/Price.php(127): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
#6 /html/app/code/core/Mage/Downloadable/Model/Resource/Indexer/Price.php(47): Innoexts_StorePricing_Model_Mysql4_Downloadable_Indexer_Price->_prepareFinalPriceData()
#7 /html/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(385): Mage_Downloadable_Model_Resource_Indexer_Price->reindexAll()
#8 /html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#9 /html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#10 /html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#11 /html/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(124): Mage_Index_Model_Process->reindexEverything()
#12 /html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Index_Adminhtml_ProcessController->reindexProcessAction()
#13 /html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('reindexProcess')
#14 /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 /html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#16 /html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#17 /html/index.php(93): Mage::run('frenchshoretour...', 'website')
#18 {main}
dmonco is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 08-06-2012, 01:49 PM Re: Magento help needed
King Spam Talker

Posts: 1,110
Name: Paul W
Trades: 0
It's a rather fundamental error - what does the theme manufacturer say?

Similar reported error and fix: http://stackoverflow.com/questions/1...dex-corruption
__________________
Great music:
Please login or register to view this content. Registration is FREE



Please login or register to view this content. Registration is FREE

Last edited by PaulW; 08-06-2012 at 01:52 PM..
PaulW is online now
Reply With Quote
View Public Profile
 
Old 08-07-2012, 05:26 PM Re: Magento help needed
Junior Talker

Posts: 2
Trades: 0
Thanks. I read it, but I think I have different.
I don't understand what should I add.
Here is from log:
/html/app/code/local/Innoexts/StorePricing/Model/Mysql4/Downloadable/Indexer/Price.php(127): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')

And here is from code
Mage::dispatchEvent('prepare_catalog_product_index _select', $eventData);
$query = $select->insertFromSelect($this->_getDefaultFinalPriceTable());
$write->query($query); //line 127 here
$select = $write->select()->join(array('wd' => $this->_getWebsiteDateTable()), 'i.website_id = wd.website_id', array());
dmonco is offline
Reply With Quote
View Public Profile
 
Old 08-08-2012, 05:40 AM Re: Magento help needed
King Spam Talker

Posts: 1,110
Name: Paul W
Trades: 0
If the maker of the new theme is changing db structure then it must surely be documented - that's why I mention them. Check their website/installation instructions.
__________________
Great music:
Please login or register to view this content. Registration is FREE



Please login or register to view this content. Registration is FREE
PaulW is online now
Reply With Quote
View Public Profile
 
Reply     « Reply to Magento help needed
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.14661 seconds with 11 queries