My Programming Life

$productId =1; $loadpro=Mage::getModel('catalog/product')->load($product->getId()); $mediaApi = Mage::getModel("catalog/product_attribute_media_api"); $mediaApiItems = $mediaApi->items($product->getId()); foreach($mediaApiItems as $item) { $mediaApi->remove($loadpro->getId(), $item['file']); } $loadpro->save();

SELECT table_name,column_name,table_schema FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name like '%mail%'

I have used DbVisualizer 9.0 in Ubuntu 13.04. Because of that I cannot use other software like netbeans and chrome due to slowness of their process. So I moved to different Mysql Admin tools and Tora is great tool. http://torasql.com/ here is how you can install it in Ubuntu $ sudo apt-get install tora $ sudo apt-get install libqt4-sql-mysql libqt4-sql-psql libqt4-sql-sqlite libqt4-sql-odbc libqt4-sql-tds

I just want to mention here I found some of my friends offering cheap web hosting in fiverr. Checkout their gigs. They offer following options for $5. Its Cheap I guess. Why don't you give a try Below are the links to those gigs. You can pay them via Paypal http://fiverr.com/calestomedia/provide-a-genuine-5-websites-hosting-package-for-1-year-including-cpanel-fantastico-sitebuilder-500-free-templates http://fiverr.com/llcoollasa/give-you-100mb-hosting-space

Again I Spent quiet time to set `Use Default Value` in Magento.  I wanted to set Product Status to be `Use Default  Value` under store views. I tried some methods and checked not lucky for me so i tested with the database.

You might want to update or insert Database single statement rather than checking the record is inserted or and again go to the update. But using following SQL statement you can run First run and check Insert statement and if that fails Update statement after that.

Override Magento Module MD5 to SHA1 Here I am going to override the hash function in Encryption class to sha1 instead of md5. Original file is located in below path.