Posts tagged: Magento

Magento Table Structure

When you first look at Magento database, it can be overwhelming because of its complexity. The Magento database is heavily dependent on EAV (Entity Attribute Value) model. While the EAV model makes it easier to expand the database, i.e. adding your own entities or attributes specific for your store, SQL codes can be very difficult to write. Before you customize Magento database, make sure you read through EAV model and you understand Magento table structure thoroughly. EAV Core Tables All EAV tables are prefixed with "eav_". eav_entity_type: table of all entitiesIt contains information about entity codes, entity models, entity tables and more. Example ...

How to Edit the Magento Footer & Footer Links

The Magento footer links are collected from a few different layout components: 1. About Us | Customer Service -> cms.xml These two links are default static blocks taken from the database. To edit them, go to Magento Admin -> CMS -> Static Blocks. 2. Site Map -> catalog.xml <reference name="footer_links"> <action method="addLink" translate="label title" module="catalog" ifconfig="catalog/seo/site_map"><label>Site Map</label><url helper="catalog/map/getCategoryUrl" /><title>Site Map</title></action> </reference> 3. Search Terms | Advanced Search -> catalogsearch.xml <reference name="footer_links"> <action method="addLink" translate="label title" module="catalogsearch" ifconfig="catalog/seo/search_terms"> <label>Search Terms</label> <url helper="catalogsearch/getSearchTermUrl" /> <title>Search Terms</title> </action> <action method="addLink" translate="label title" module="catalogsearch"> <label>Advanced Search</label> <url helper="catalogsearch/getAdvancedSearchUrl" /> <title>Advanced Search</title> </action> </reference> 4. Contact Us -> contacts.xml <reference name="footer_links"> <action method="addLink" translate="label title" module="contacts" ifconfig="contacts/contacts/enabled"><label>Contact Us</label><url>contacts</url><title>Contact Us</title><prepare>true</prepare></action> </reference> 5. RSS -> rss.xml <reference name="footer_links"> <action method="addLink" translate="label title" module="rss" ifconfig="rss/config/active"><label>RSS</label><url>rss</url><title>RSS testing</title><prepare>true</prepare><urlParams/><position/><li/> <a>class="link-feed"</a> </action> </reference> * 2. Site Map, ...

Magento Installation Problem - MySQL Access Denied

I was installing Magento on one of my commercial sites just to try it out and ran into this installation problem: SQLSTATE[28000] [1045] Access denied for user ......# 'root'@’localhost’ (using password: YES) # Database connection error ... The error message explains itself: there is a database connection issue and it's probably because either your username and / or password don't match or your account doesn't have the privilege for this execution. My question was exactly about that, too. "Why does it try to access MySQL database using the 'root' account? " I'm using shared hosting service from HostGator for this site, and I don't have ...