Following SQL Queries are helpful in determining the InnoDB status of MYSQL: 1> SHOW VARIABLES LIKE ‘%have_innodb%’; Result: 2> SHOW ENGINES; Result: You can use these queries in case of Magento too in order to determine the InnoDB status. Cheers!!
One thing to be noted that pre-filled form values do not get reset using the html reset button. In this case, javascript becomes handy. It’s again even much easier to reset using JQuery. Here is the solution: function resetForm(id) { $(‘:input’,’#’+id) .not(‘:button, :submit, :reset, :hidden’) .val(”) .removeAttr(‘checked’) .removeAttr(‘selected’); } <input type=”button” onclick=”resetForm(‘formId’);” value=”Reset” /> Where …
You know that Magento version (>= 1.4.X) works well under PHP 5.3. But what if you want to run the Magento 1.3.X under the same AMP(Apache/Mysql/PHP) package? You may need this in order to test the extension/theme compatibilities. In order to run Magento 1.3.x on PHP 5.3, you need to replace the following function from …
You know we can easily fetch the product names using the Model object. But what if you want to list out all the product names via SQL code? Don’t worry here is the SQL code for you: SELECT `value` AS product_name FROM catalog_product_entity_varchar WHERE entity_type_id = (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = ‘catalog_product’) AND …
It’s really a tedious task when you have to copy all the cms pages/static blocks from your development server to the live server. If you are importing the whole database then you are lucky enough but if you are updating in already installed Magento server then :(, luckily you can use the following commands via …