<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>Tips, Techniques and Guides Magento Software</title>
	<link>http://www.knowmagento.com</link>
	<description>Learning Magento One Stumble at a Time</description>
	<lastBuildDate>Tue, 22 Nov 2011 05:26:33 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.2.1" -->

	<item>
		<title>Create Custom Category Attributes with phpMyAdmin (Tutorial)</title>
		<description><![CDATA[The following is a brief tutorial for creating a custom category attribute. This has only been tested by creating a textfield-type attribute in Magento&#8217;s version 1.3.2. However, to the best of my current knowledge, it should work in any versions 1.2+ and for any type of attribute. Note: changing the attribute type will require a [...]]]></description>
		<link>http://www.knowmagento.com/custom-category-attributes-with-phpmyadmin/</link>
			</item>
	<item>
		<title>./pear: Permission denied</title>
		<description><![CDATA[If your&#8217;re getting a permission denied error when trying to either upgrade or install an extension, chances are the permissions are off on your pear file. No worries &#8211; it&#8217;s a simple fix. SSH into the root directory of your Magento installation and type the following command: chmod 550 pear]]></description>
		<link>http://www.knowmagento.com/pear-permission-denied/</link>
			</item>
	<item>
		<title>Cleaning (Refreshing) Cache</title>
		<description><![CDATA[The Magento Admin panel calls it refreshing (Refresh) the cache, while within the code it&#8217;s refered to as &#8220;cleaning&#8221; the cache. If you want to Refresh your cache within the admin panel, simply go to System &#62; Cache Management.  Drop the box labeled &#8220;All cache&#8221; down to the Refresh option and hit the Save cache [...]]]></description>
		<link>http://www.knowmagento.com/cleaning-refreshing-cache/</link>
			</item>
	<item>
		<title>Adding extentions from the command line</title>
		<description><![CDATA[I&#8217;ve found it&#8217;s sometimes easier to either make upgrades or install extensions via the command line rather than using Magento Connect. To do this, all you need is the extension key. For this example I&#8217;ll use Magento&#8217;s default upgrade key: magento-core/Mage_All_Latest ./pear install magento-core/Mage_All_Latest Easy enough?]]></description>
		<link>http://www.knowmagento.com/adding-extentions-from-the-command-line/</link>
			</item>
	<item>
		<title>Available conditionals for addAttributeToFilter()</title>
		<description><![CDATA[I got a little tired of always referencing a code file in order to remember the conditionals for addAttributeToFilter(). I&#8217;ll come back to this post to clean it up and make it an easier reference, but for now it&#8217;s just a code reference in an easy place to find it /** * Build SQL statement [...]]]></description>
		<link>http://www.knowmagento.com/available-conditionals-for-addattributetofilter/</link>
			</item>
	<item>
		<title>Simple Magento Upgrade</title>
		<description><![CDATA[Of course, you should do a full backup of Magento before performing any upgrade. Once you&#8217;ve done that, the following extension key will take care of all the upgrades you&#8217;ll need at the core level: magento-core/Mage_All_Latest Simply type that into your Magento Connect Manager where it reads: Paste extension key to install: Then hit your [...]]]></description>
		<link>http://www.knowmagento.com/simple-magento-upgrade/</link>
			</item>
	<item>
		<title>PEAR ERROR: Upgrade Failed</title>
		<description><![CDATA[This is an awful message to see in the &#8220;Auto-scroll console contents&#8221; section of the Magento Connect Manager Downloader page. I got the following message when I tried to upgrade recently: PEAR ERROR: upgrade failed So I did a bit of investigating and found that I needed to do some manual cache clearing to fix [...]]]></description>
		<link>http://www.knowmagento.com/upgrade-failed-pear-error/</link>
			</item>
	<item>
		<title>Change MySQL Database Settings</title>
		<description><![CDATA[This probably seems like a no-brainer for many people, but it came up today and I didn&#8217;t have an immediate answer.  So, if you want to change any of your MySQL database access settings (like your database name, database username, database password or database host), you&#8217;ll need to do it within the following file: /app/etc/local.xml [...]]]></description>
		<link>http://www.knowmagento.com/change-mysql-database-settings/</link>
			</item>
	<item>
		<title>Here&#8217;s how I prefer to install Magento via SSH</title>
		<description><![CDATA[The following assumes an installation version of 1.2.0.  It also makes the assumption that you do not want your installation to live in a folder named &#8216;magento,&#8217; but rather your web root folder. SSH into your server and navigation to your web root folder.  Type the following commands: wget http://www.magentocommerce.com/downloads/assets/1.2.0/magento-1.2.0.tar.gz tar -zxvf magento-1.2.0.tar.gz cd magento mv [...]]]></description>
		<link>http://www.knowmagento.com/heres-how-i-prefer-to-install-magento-via-ssh/</link>
			</item>
	<item>
		<title>Simple querying</title>
		<description><![CDATA[Since Magento uses an EAV (Entity Attribute Value) data model, raw SQL queries are (for most practical purposes) out the window.  Therefore, this is a typical method of grabbing the collection of objects you are searching for: $products = Mage::getModel('catalog/product')-&#62;getCollection(); $products-&#62;addAttributeToFilter('sku', '1234'); $products-&#62;addAttributeToSelect('*'); $products-&#62;load(); foreach ($products as $_product) {     print_r($_product-&#62;getData()); } There are also [...]]]></description>
		<link>http://www.knowmagento.com/simple-querying/</link>
			</item>
</channel>
</rss>

