Give these a try: at_status: INDEX(entity_id, value_id, value, attribute_id, store_id) at_status_default: INDEX(entity_id, value, attribute_id, store_id) at_visibility: INDEX(entity_id, value_id, value, attribute_id, store_id) at_visibility_default: INDEX(entity_id, value, attribute_id, store_id) e: INDEX(created_at, entity_id) product_website: INDEX(product_id, website_id) When adding a composite index, DROP index(es) with the same leading columns. That is, when you have both INDEX(a) and INDEX(a,b), toss the former. That looks like an EAV schema; such is notoriously difficult to optimize, even when the Optimizer is picking a less-optimal path.

We just need to redesign this template. app/design/adminhtml/default/default/template/catalog/product/helper/gallery.phtmlI'll add analogy to that. <tr id="<?php echo $_block->getHtmlId() ?>_template" class="template no-display"> <td class="cell-image"><div class="place-holder" onmouseover="<?php echo $_block->getJsObjectName(); ?>.loadImage('__file__')"><span><?php echo Mage::helper('catalog')->__('Roll Over for preview') ?></span><$ <td class="cell-label"><input type="text" <?php if($_block->getElement()->getReadonly()):?> disabled="disabled"<?php endif;?> class="input-text" onkeyup="<?php echo $_block->getJsObjectName(); ?>.updateImage$ <td class="cell-position"><input type="text" <?php if($_block->getElement()->getReadonly()):?> disabled="disabled"<?php endif;?> class="input-text validate-number" onkeyup="<?php echo $_block->getJsObjectNam$ <?php foreach ($_block->getImageTypes() as $typeId=>$type): ?> <td class="cell-<?php echo $typeId ?> a-center"><input <?php if($_block->getElement()->getAttributeReadonly($typeId)) :?> disabled="disabled" <?php endif;?> type="radio" name="<?php echo $type['field'] ?>" o$ <?php endforeach; ?> <td class="cell-disable a-center"><input type="checkbox" <?php if($_block->getElement()->getReadonly()):?> disabled="disabled"<?php endif;?> onclick="<?php echo $_block->getJsObjectName(); ?>.updateImage('__$ <td class="cell-remove a-center last"><input type="checkbox" <?php if($_block->getElement()->getReadonly()):?> disabled="disabled"<?php endif;?> onclick="<?php echo $_block->getJsObjectName(); ?>.updateImage$ </tr> Your attribut type ring

Just remove the button and add the caste.protected function _construct() { $helper = Mage::helper('brain_custommenu'); $this->_blockGroup = 'brain_custommenu'; $this->_controller = 'adminhtml_categorylist'; $this-&gt;_headerText = $helper-&gt;__('Category List'); parent::_construct(); $this-&gt;_removeButton('add'); } If you don't get through the code inspector, look at the id and take it down. Then add a button.$this->_addButton('add_new', array( 'label' => Mage::helper('catalog')->__('Add Product'), 'onclick' => "setLocation('{$this->getUrl('//new')}')", 'class' => 'add' ));

Imagine as a response because the commentary does not allow the formatting to be normal.Here's the method in the file. app/code/core/Mage/Core/Model/Config.php line 1349/** * Get model class instance. * * Example: * $config->getModelInstance('catalog/product') * * Will instantiate Mage_Catalog_Model_Mysql4_Product * * @param string $modelClass * @param array|object $constructArguments * @return Mage_Core_Model_Abstract|false */ public function getModelInstance($modelClass='', $constructArguments=array()) { $className = $this->getModelClassName($modelClass); if (class_exists($className)) { Varien_Profiler::start('CORE::create_object_of::'.$className); $obj = new $className($constructArguments); Varien_Profiler::stop('CORE::create_object_of::'.$className); return $obj; } else { return false; } } Do it. var_dump($className) It's probably wrong. Let's move on. getModelClassName() We're going to 1219 of the same file. getGroupedClassName() /** * Retrieve class name by class group * * @param string $groupType currently supported model, block, helper * @param string $classId slash separated class identifier, ex. group/class * @param string $groupRootNode optional config path for group config * @return string */ public function getGroupedClassName($groupType, $classId, $groupRootNode=null) { if (empty($groupRootNode)) { $groupRootNode = 'global/'.$groupType.'s'; } $classArr = explode('/', trim($classId)); $group = $classArr[0]; $class = !empty($classArr[1]) ? $classArr[1] : null; if (isset($this-&gt;_classNameCache[$groupRootNode][$group][$class])) { return $this-&gt;_classNameCache[$groupRootNode][$group][$class]; } $config = $this-&gt;_xml-&gt;global-&gt;{$groupType.'s'}-&gt;{$group}; // First - check maybe the entity class was rewritten $className = null; if (isset($config-&gt;rewrite-&gt;$class)) { $className = (string)$config-&gt;rewrite-&gt;$class; } else { /** * Backwards compatibility for pre-MMDB extensions. * In MMDB release resource nodes &lt;..._mysql4&gt; were renamed to &lt;..._resource&gt;. So &lt;deprecatedNode&gt; is left * to keep name of previously used nodes, that still may be used by non-updated extensions. */ if ($config-&gt;deprecatedNode) { $deprecatedNode = $config-&gt;deprecatedNode; $configOld = $this-&gt;_xml-&gt;global-&gt;{$groupType.'s'}-&gt;$deprecatedNode; if (isset($configOld-&gt;rewrite-&gt;$class)) { $className = (string) $configOld-&gt;rewrite-&gt;$class; } } } // Second - if entity is not rewritten then use class prefix to form class name if (empty($className)) { if (!empty($config)) { $className = $config-&gt;getClassName(); } if (empty($className)) { $className = 'mage_'.$group.'_'.$groupType; } if (!empty($class)) { $className .= '_'.$class; } $className = uc_words($className); } $this-&gt;_classNameCache[$groupRootNode][$group][$class] = $className; return $className; } that this method is done, taken from a prefix class numerical configuration that is indicated in the section models Anyway, after you see the classed imagination, you'll know where the mistake is. But from experience, I'll tell you where the seal is. In principle, the edited JI option should work.

I make this changes in the MySQL Config File:max-allowed-packet = 1024M wait-timeout = 7200 innodb-log-file-size = 2047M innodb-log-buffer-size = 8M innodb-log-buffer-size = 32M And Magento has instaled successfull

Problem is, the block. "pager." as a direct child for the unit VitaliyDev_Vendor_Block_Customerbut in the method VitaliyDev_Vendor_Block_Customer::getPagerHtml() You're trying to extract the child element of the block. "pager."♪To eliminate the problem, change the method getChildChildHtml() ♪ getChildHtml()by the way, this is the method used in your gide. getChildHtml()♪

In the first rule of replace it. <global> <blocks> <Kalinin_Form> <class>Kalinin_Form_Block</class> </Kalinin_Form> </blocks> </global> That's it. <global> <blocks> <kalininform> <class>Kalinin_Form_Block</class> </kalininform> </blocks> </global> It's not the name of the module. It's the key. We'll figure it out next.<layout> <kalininform_index_index> <!-- это ModuleName().'_'.ControllerName.'_'.ActionName --> <reference name="content"> <!-- обновляем контент --> <block type="kalininform/form" name="kalininform" template="Kalinin_Form/index.phtml" /> </reference> </kalininform_index_index> </layout> Now we'll clear the block section.type='kalininform/form It's the type of unit in the render inside the gag. getBlockSingletonand it will be delivered. kalininform/form The first part before the slash is the key in the configuration for the unit of the module, i.e. niche, like this part: <global> <blocks> <kalininform> <class>Kalinin_Form_Block</class> </kalininform> </blocks> </global> Of all the configurations, he'll pick a class name. classIn our case, Kalinin_Form_Block♪ The second part of the key is the way to the class name in the lowercase mode, that is, in our case magento will take. form from the key and transformed into Form and further using the previous class name (realization namespace), it will put this piece at the end of the bottom line, resulting in the final class of the block Kalinin_Form_Block_Form And she's gonna get the next phaser. Kalinin\Form\Block\Form.php♪What to touch template It's a relative path to the head of the directory. template current topic. i.e. if template="Kalinin_Form/index.phtml" should be in the directory. template/Kalinin_Form/♪Then you forgot. name Box in the context of the cluster content It's not, in principle, critical, but the installation of the blocks goes on the name so much better than describe it.There's a few more options I won't stop. output♪as♪after etc.Shablon debag methods:Insert the display of the tracks to the templates система->конфигурация-> для разработчиков Remove the store view in the left corner on the site store, further find the location of the template and include the options подсказка путей шаблона and подсказки классов шаблонов♪Log monitoring, tailf -1000 /magentoroot/var/log/exception.log and tailf -1000 /magentoroot/var/log/system.log where magentoroot To the original directory of magento.Server log monitoring.More for the magento, copy the file. /magentoroot/errors/local.xml.sample Total /magentoroot/errors/local.xml If he's not here, or we'll let him in. default print for the developeric environment is natural.

There are several options:Create a separate фабрику ♪ factory for a front-end module. Rander's on phtml, so I'll get something like that.It's possible to give access to the grinder of products and produce to the adminke, when a shark is created, and don't drink half the hell on the front. And just add some laser attribute and filter it.And then we'll figure out the first case of pseudo php.creating an abstract class in the directory. Block For example, the module will be Test_Frontgreed and analogy is being implemented from adminhtmlfile Block/Abstract.phpabstract class Test_Frontend_Block_Abstract extends Core_Block_Template { private $_collection = null; private $_columns = array(); public function __construct() { $this->setTemplate('your/greed.phtml'); } protected function _prepareCollection() { if($collection = $this->getData('collection') { // логика фильтрации коллекции $collection->load(); return $collection; } } public function getCollection() { if(is_null($this->_collection)) { $this->_collection = $this->_prepareCollection(); } return $this-&gt;_collection; } abstract public function prepareGrid(); //prepare grid protected function _addColumn($type,$key,$options) { $this->_columns[$key] = array( 'type' => $type; 'options' => $options; ); } public function getCollumn() { if(count($this->_columns) == 0) { $this->prepareGrid(); } return $this->_columns; } } Extended from previousclass Test_Frontend_Block_Product extends Test_Frontend_Block { protected function _prepareCollection() { $collection = Mage::getModel('catalog/product')->getCollection(); $this->setCollection(); parent:_prepareCollection(); } public function prepareGrid() { $this->_addColumn('text','entity_id',array('custom_options' => 'custom')); } } Well, the last thing to do is run the pattern.<?php foreach($this->getCollection() as $_product): ?> <tr> <?php foreach($this->getCollumn() as $_key => $_collumn): ?> <td><?php echo $_product->getData($_key) ?> </td> <?php endforeach; ?> <tr> <?php endforeach; ?> This is a simple example of a factory, although the second option should be preferable.

There's a bloc with position: relative. The second block, which will be displayed at the time of the introduction, is entirely relative to the first unit and display: none will be located and will be displayed at the first bloc chove:

Try to set admin store before you go.Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

You have to create a resource model, that's what you need to write. <your_module> <class>You_Module_Model</class> <resourceModel>your_module_resource</resourceModel> </your_module> further configuration resource model <your_module_resource> <class>Your_Module_Model_Resource</class> <entities> <yourtable> <table>your_table</table> </yourtable> </entities> </your_module_resource> further in the configuration of the resource setup <resources> <your_module_setup> <setup> <module>Your_Module</module> </setup> </your_module_setup> </resources> Let's notice. your_module_setup It's the name of the directory sql.Then create our model.class Your_Module_Model_Model extends Mage_Core_Model_Abstract { protected $_dataLayer = null; function _construct() { $this-&gt;_init('your_module/yourtable'); } } Now we're creating a director. Resource Director ModelAnd it's a model resource file.class Your_Module_Model_Resource_Model extends Mage_Core_Model_Resource_Db_Abstract { /** * Resource initialization / protected function _construct() { $this->_init('your_module/yourtable','entity_id'); } } And the last thing we've ever done. Collectionat the Resource Director, we're setting up a subdivision with the name of the resource file. ModelIn our case, a pretty bad name, you'll excuse me. And in this directory, we're making faals. Collection.phpclass Your_Model_Model_Resource_Model_Collection extends Mage_Core_Model_Resource_Db_Collection_Abstract { /* * init collection */ protected function _construct() { $this->_init('your_module/yourtable'); } } I didn't specifically give a full case and name to those you gave. In order to work with magento, it is necessary to know English at least at the technical level. This article will help in your task. http://inchoo.net/magento/magento-install-install-upgrade-data-and-data-upgrade-scripts/ and my answer. Good luck to you, and if there's any trouble with the agent, please write to the ru.stackoverflow.com I'll try to answer quickly. Since magento is very gratified in understanding the architecture, it's better to ask a question and get an answer than to invent a functioning one already exists. Good luck!

It's not a problem, it is. Start a reflex. http://sitename.ru/home before http://sitename.ru/ You can do it in hell. каталог -> управление урл -> добавить In the seclud, the type chooses another, and we follow the fields and we keep.

libapache2-mod-php7.0 - You don't need this module. In addition to the listed, you also need to bet. php7.0-fpm♪

in construction system(система)->configuration(конфигурация)->клиеты(customers)->newslatter(рассылка)->Параметры подписки(params newslater)->Необходимо подтвержение(requir apruve) Make it important. нет(no) English localizationization may not be confused by remembering.to activate all unenacted letters shell$newsletterCollection = Mage::getModel('newsletter/subscriber')->getCollection(); // фильтруем коллекцию по тем чьи email не подтвержденны $newsletterCollection->addFieldToFilter('status',2); foreach($newsletterCollection->load() as $_newsletter) { $_newsletter->setStatus(1); // ставим статус подтверждён $_newsletter->save(); // сохраняем подписчика echo $_newsletter->getEmail().'[ok]'.PHP_EOL; // добавляем вывод } How do you write shell? myshell.phpwith contentsrequire_once 'abstract.php'; class My_Shell_MyShell extends Mage_Shell_Abstract { public function run() { if ($this->getArg('run')) { $this->setStatus(); } } public function setStatus() { // тут код который делает автоматическую подписку // представлен выше } } $shell = new My_Shell_MyShell(); $shell->run(); Crypt launchWe'll go ssh to the server.Let's go to the file shell. cd /path/to/mage/shellLet's start the violin team. php -f myshell.php -- run

♪ System - Article Configurations - Source Catalog - Environmental CatalogThere's a search structure that can be chosen between like♪ fulltext or combine(like + fulltext) it might help, unfortunately, standard job and construction searches are weak and it is usually necessary to introduce additional modules using elastic or sphinx♪

The question is getting old, but since there's no answer, I'll write it.If, in general, we add a form of input in the template[type=file] to select a file, we're texting a counteroler that accepts the file and puts it in the letter, here in my letter. https://gist.github.com/evgv/cf073067a3874c25c56e7f03e9d3129a There is an example of how to tie a file to ZF/Magento

These variables are designed specifically to dynamically add data to static pages, blocks and letters.To work with these variables anywhere else:Let's say we have some "blah, blah, blah, blah, blah, blah." $cutVar = array('custVar' => 'текст катомной переменной'); $text = "бла бла {{custVar}}" $formater = new Varien_Filter_Template(); $formater->setVariables($cutVar); var_dump($formater->filter($text)); It'll give us the "blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah, blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah

We just need to pick up Enter's event and do nothing.$("#id_of_input").keyup(function(event){ if(event.keyCode == 13){ event.preventDefault(); } }); You can read the English. https://stackoverflow.com/questions/905222/enter-key-press-event-in-javascript

Maybe someone to help.<?php $attribute = $_product->getResource()->getAttribute('название вашего атрибута'); ?> <?php $attribute_value = $attribute ->getFrontend()->getValue($_product); ?> <?php if ($attribute_value == 'Yes'): ?> <div>Новинка</div> <?php else: ?> <?php endif; ?>

I've found a solution to help. catalog/product/list/related.phtml and put this code in the right place. <?php $i = 0; ?> <?php foreach($this->getItems() as $_item): ?> <?php if($i++ == 5) break; ?> with what <?php foreach($this->getItems() as $_item): ?> Already. related.phtml, correspondingly just added <?php $i = 0; ?> and <?php if($i++ == 5) break; ?>where 5 is the quantity of the goods left.