Get all Root-Category-IDs of all stores

SheldonNo Comments

This snippet gives you all entity_id’s of all Root-IDs of the Magento instance: /** * @return array Root-IDs of all stores */ public function getAllRootIds(){# $aRootIds = array(); $aRootIds[Mage_Catalog_Model_Category::TREE_ROOT_ID] = Mage_Catalog_Model_Category::TREE_ROOT_ID; $aAllStores = Mage::app()->getStores(); foreach ($aAllStores as $iID => $store){ $rootID = $store->getRootCategoryId(); $aRootIds[$rootID]=$rootID; } return array_keys($aRootIds); }  

Error cause by DEFINER in MySQL-dumps

SheldonNo Comments

When importing MySQL- dumps of a Magento database sometimes you get an error message like that (although you can connect to the database via shell f.e.): ERROR 1044 (42000) at line 592: Access denied for user ‘sheldon’@’localhost’ to database ‘magento’ In these cases you’ ll recognize that the user, who tries to connect, is wrong […]

Reset Icons And Logos After Upgrade

SheldonNo Comments

All images are laying in the root folder of dokuwiki. So you can do $> cp -f favicon.ico lib/tpl/dokuwiki/images/favicon.ico $> cp -f logo.png lib/tpl/dokuwiki/images/logo.png $> cp -f apple_icon.png lib/tpl/dokuwiki/images/apple-touch-icon.png $> touch conf/local.php $> rm -rf data/cache/* from within the root. The $> touch conf/local.php resets the update hints (yellow boxes). Or just use this bash script: […]

Extract single file or folder

Sheldon1 Comment

You know the problem when trying to get just one file or folder out of your GIT repository? For example if you had a repository for all your Magento modules you’ve written, you might  want to extract only one of them to a new project. Sure  you can use subtree but sometimes you only want to get […]

MySQL root-user and password under Plesk Parallels

SheldonNo Comments

Plesk changes the root user name to admin and stores the corresponding password in /etc/psa/.psa.shadow. The value inside this file looks really strange – like an encrypted key or hash. But that’s really your password for the admin user! If you’re lazy – like me – you can login as admin like that: $> mysql -uadmin […]

Plesk Parallels add authorized keys authentication

SheldonNo Comments

In Parallels Plesk 9.x, 10.x and 11.x for Linux (in this case CentOS 6.6) there is a bug. You can not authenticate via ssh key or add one f.e. with: $> ssh-copy-id -i .ssh/deploy_rsa.pub user@ask-sheldon.com Thats why you have to do this: Edit ssh deamon configuration: $> sudo nano /etc/ssh/sshd_config Add the following line: AuthorizedKeysFile […]

Install attribute in entity main table

SheldonNo Comments

Sometimes it is useful to add some fields to the attribute main table (f.e.: IDs from external systems like a middleware or a PIM). In the following example you can see how to add ID-fields to the category entity. Therefore I created a setupscript as an instance of Mage_Catalog_Model_Resource_Setup. Setup-model declaration in config.xml: <?xml version=”1.0″?> […]