Recover lost images from SD/MMC cards

A very nice and really working recovery tool is  PhotoRec. It’s a very cool commandline tool for Linux which is able to recover all images on a SD or MMC card that have been deleted accidentally. In my case my fingers where faster than my brain and so I had kicked three rally awesome images :-/. […]

Setup an static IP on Arch Linux

Setup an static IP on Arch Linux can be done by placing a config file in /etc/netctl/: $> sudo nano eth0-Valhalla As you can see, you have to install sudo first. Otherwise you have to switch to root user (su). In the file you have to place the following lines for example: Description=’Valhalla at home eth0′ […]

Wifi setup on Arch Linux

The following steps are showing how I did setup my wireless connection with an static IP on my ArchLinux driven RaspberryPi. You need to have installed sudo to uses this instructions: Update all packages: $> sudo pacman -Syu Install dialog package: $> sudo pacman -S dialog Install wpa_supplicant package $> sudo pacman -S wpa_supplicant Run wifi-menu: […]

Get stores last order increment ids

This can be done by the following database query: SELECT cs.store_id, csg.name AS group_name, cw.name AS website_name, cs.name AS store_name, increment_last_id AS last_increment_id, entity_type_code AS entity_code FROM eav_entity_store AS ees INNER JOIN eav_entity_type AS eet ON eet.entity_type_id = ees.entity_type_id INNER JOIN core_store AS cs ON cs.store_id = ees.store_id INNER JOIN core_store_group AS csg ON csg.group_id […]

Increment order increment ids for all stores

The following query increments the last increment ids for all store by 100: UPDATE eav_entity_store AS ees INNER JOIN eav_entity_type AS eet ON eet.entity_type_id = ees.entity_type_id SET ees.increment_last_id = ees.increment_last_id + 100 WHERE eet.entity_type_code=’order’; The actual values for each store can be queried as shown in Get stores last order increment ids.

Install CMS pages with your module

You can do this as shown in the following example of a Magento data setup script: <?php /* @var $installer Mage_Core_Model_Resource_Setup */ $oInstaller = $this; $oInstaller->startSetup(); $aCmsPages = [ [ ‘title’ => ‘FAQ’, ‘root_template’ => ‘two_columns_left’, ‘meta_keywords’ => ‘FAQ’, ‘meta_description’ => ‘FAQ’, ‘identifier’ => ‘faq’, ‘is_active’ => 1, ‘stores’ => 0, ‘sort_order’ => 0, ‘content_heading’ => […]

Observe a process

If you want to see, what a process does, you can use: $> strace -p PROCESSID This will show you all actions of the process in realtime. To get a process id you can use the ps-command.

List processes after CPU usage

$> ps waux –sort=-pcpu If you piped the result into the head command, you can limit the result to the n entries with the highest CPU usage. $> ps waux –sort=-pcpu | head -n 10 In this example you will see the ten most CPU-consuming processes on the machine. The ‘–‘ before pcpu results in […]

Install CMS blocks with your module

You can do this as shown in the following example: <?php /* @var $installer Mage_Core_Model_Resource_Setup */ $oInstaller = $this; $oInstaller->startSetup(); $oCmsBlocks = [ [ ‘title’ => ‘Footer bar for benefits’, ‘identifier’ => ‘footer-bar’, ‘content’ => <<<HTML <ul> <li>Shop Benefit 1</li> <li>Shop Benefit 2</li> <li>Shop Benefit 3</li> <li>Shop Benefit 4</li> <li>Customer Service (D): <a href=”tel:08008828838″ class=”tel”>0800 […]

Silence crontab

Sometimes you don’t want to get any notifications from your cronjob, but somewhere in the code someone echos something and so you get an email each time. That could be very annoying. The following snipped will help you to immobilize the cron. */5 * * * * /var/wwww/whatever.php > /dev/null 2>&1 The important part is > […]