Archive: sql

A post by FishPig.co.uk Magento’s use of data models provide a great way to access and modify data but sometimes, you can’t beat a direct SQL query! In this article learn to how to correctly query the Magento database directly! Direct SQL Queries In Magento Possibly Related Posts: magento javascript skin path admin vs frontend [...]

A post by FishPig.co.uk Magento’s use of data models provide a great way to access and modify data but sometimes, you can’t beat a direct SQL query! In this article learn to how to correctly query the Magento database directly! Direct SQL Queries In Magento Possibly Related Posts: magento javascript skin path admin vs frontend [...]

It’s boring to add store views manually, especially when your store has many languages. Does anyone use sql upgrade script for adding store views and assigning appropriate locale? How can I do this via sql upgrade script? What is the best practice to setup multilanguage store (any sql upgrades)? Possibly Related Posts: magento javascript skin [...]

Magento constructs its SQL queries like $this->getSelect()->joinInner( array(‘sbao’ => $this->getTable(‘sales/billing_agreement_order’)), ‘main_table.entity_id = sbao.order_id’, array() ) Is there a way to display the resulting query in a string format rather than printing out the huge object e.g. echo $this->getSelect()->joinInner( array(‘sbao’ => $this->getTable(‘sales/billing_agreement_order’)), ‘main_table.entity_id = sbao.order_id’, array() )->toString(); How do you display a Magento sql query as [...]

SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT; SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS; SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION; SET SQL_NOTES=@OLD_SQL_NOTES; How to restore data in Magento from a backup | Magento Help – osCommerce Help Possibly Related Posts: It’s not a bug. It’s a feature. Extension Magento : Filtre à Sélection Multiple « Eric Kranich News from Byte HQ » Multiple [...]

Hi I’m trying to rewrite or extend all database update sql’s files from core to local without success, until now I have: CORE: +core +Mage +Mymodule +… +etc -config.xml +sql +mymodule_setup -mysql4-install-0.1.0.php -mysql4-install-0.1.0-0.1.1.php -… LOCAL: +local +Mage +Mynamespace +Mymodule +… +etc -config.xml +sql +mymodule_setup -mysql4-install-0.1.0.php -mysql4-install-0.1.0-0.1.1.php -… So my question is to avoid problems when [...]

On any fast paced software development project, the task of keeping the development and production databases in sync become a sticky wicket. Magento offers a system to create versioned resource migration scripts that can help your team deal with this often contentious part of the development process. In the ORM article we created a model [...]

Every once in awhile I am programming something in Magento and I get a MySQL error. When the exception displays on the screen it only displays the first few characters of the query that it was trying to execute. Is there a way to get Magento to display the entire query in the stack trace? [...]

by fRAiLtY (Posted Sun, 02 Jan 2011 17:45:08 GMT)Hi guys, How can I add (via SQL) 2.5% to product prices that are TAXABLE GOODS only. I really would be better doing this via SQL as I have 22 Magento sites and don’t want to be exporting/importing on all of them. I’m guessing using a JOIN [...]

Direct SQL queries in Magento | Fontis – IT Consulting, Development and eCommerce Possibly Related Posts: It’s not a bug. It’s a feature. Extension Magento : Filtre à Sélection Multiple « Eric Kranich News from Byte HQ » Multiple stores in one Magento install OnePica ImageCDN – Magento Connect Magento Expert India – Hire Expert [...]