• Englisch
  • Deutsch


Normally upgrading from Magento 1.0.19870 to 1.3.1 should be no problem, as Magento takes care of all the required table changes.  I mostly faced script timeouts on the server in the past, which broke the upgrade process and turned the installation unusable.

I have switched to upgrading customer databases on a local installation, as that allows me to workaround timeouts and prepare databases for the upgrade.

Before upgrading an installation, you should also delete any content that can be recreated by Magento again. Logs, price rule caches …. can all be deleted, as the system can generate those again.

Really sad how everyone needs to piece those things together, as the Magento Community Knowledge Base is mostly outdated and many hints are buried deep inside the forums.

Currently working my way through a huge Magento 1.0.19870 database and will comment on my success once everything works.


Once you have done the export / import multiple times, it gets really easy :)

Here are some things that made things alot easier for me

  1. Update magento/app/etc/local.xml with your changed database details
  2. Update the secure / unsecure urls to match your new domain / setup
    These settings are saved in the magento_core_config_data table.
    The two settings you need to alter are
    – web/unsecure/base_url
    – web/secure/base_url
  3. Sometimes the foreign key constraints break tables on import. The most common are :
    – magento_customer_group
    – magento_core_website
    – magento_core_store
    – magento_core_store_group

    Just check your old setup and update those tables by hand.

    You can run queries by activating and deactivating the foreign key check like this:


    INSERT INTO magento_core_website (website_id, code, name, sort_order, default_group_id, is_default) VALUES
    (0, ‚admin‘, ‚Admin‘, 0, 0, 0),
    (1, ‚base‘, ‚Main Website‘, 0, 1, 1);


  4. Make sure to delete the following folders before you try to access the install again
    – var/cache
    – var/sessions


You can choose which updates to list, when running the Magento Connect Manager. You can allow alpha, beta or only stable releases to be listed.

When saving your settings, the following file needs to be writable:



When it comes to permissions Magento Commerce is very picky, especially as pear requires full write permissions.

The following permissions should be used during install:
find . -type d -exec chmod 777 {} ;
find . -type f -exec chmod 777 {} ;

This will reset all permissions after you are done and secure your setup again:
find . -type f -exec chmod 644 {} ;
find . -type d -exec chmod 755 {} ;
chmod o+w var var/.htaccess app/etc
chmod 550 pear
chmod -R o+w media

30. April 2009

Komodo Development IDE

When it comes to my development environment I have always been really picky. I need a clean and structured interface, not to cluttered, but still adjustable to my needs. I have tested countless IDE solutions in the past, but always seem to come back to Komodo from ActiveState.

26. April 2009

What is Tweetdeck ?

When it comes to my development environment I have always been really picky. I need a clean and structured interface, not to cluttered, but still adjustable to my needs. I have tested countless IDE solutions in the past, but always seem to come back to Komodo from ActiveState.


„MetaNote intends to be the most versatile editor imaginable. Right
click on features in the editor and edit the code behind them. Don’t
like the way ‚Find‘ works? — right click on it, and edit the code.
Need a new button in the toolbar? So add it already, with a single
click. Share packs of extensions and macros with other users.
Everything in MetaNote is under your control, effortlessly, at runtime.“

The project is still in its alpha stages, but a really unique approach. The developer is looking for people that like to jump in and help out making it as versatile as possible.

More about it here


MySQLDumper is a backup programm for MySQL-Databases, written in PHP and Perl. You can dump your data into a backup file
and if needed, restore it. Especially on shared hostings without access to shell-commands, MySQLDumper is a sensefull

MySQLDumper uses a proprietary technique to avoid execution
interruption. It only reads and saves a certain amount of commands and
then calls itself via JavaScript and memorizes how far in the process
it was and resumes its action from its last standby.

MySQLDumper restores a backup file by using the same process. Unlike
other tools splitting and splicing of large files is no longer

More about it here

22. April 2009

What have you been up to?

Another of my irregular updates of what I am currently up to :)

1) Finally  updated the jQuery Horizontal Accordion and made the first alpha available. Still doing some internal cleanup of the plugin to make it a bit smaller and more accessible. Also doing the jQuery CSS Framework integration, that will allow to use themeroller themes with the plugin. The first release really spiked my access stats. On the first day about 15.000 people visited the project page alone. Glad you all enjoy the plugin as much as I do ;)

2) Have been working on cubicFusion, my own php framework, which also runs this content management frontend. After the move to PHP 5 last year, I am moving through all core services and doing a global cleanup. Also consolidating the CMS, as I have been doing deep changes for a client of mine and those need to be merged into the development version. Also upgrading all jQuery plugins to the latest version of jQuery and moving old style javascript to new plugins (Alot easier to maintain).

3) portalZINE TV has taken some of my time this year, but as its no money maker, things are moving a bit slower right now. Need to think about food on the table first :)  Will be doing be-weekly episodes starting next month, allowing to have a more regular schedule and limit the workload a bit. Will also be doing some more DIY stuff. Setting up a mac homeserver, without the need to be a command line guru. Will be presenting some nice solutions for private enthusiasts, developers and small businesses.

4) Working on a new Adobe Flex project and thinking of doing some of the cubicFusion interfaces in Flex aswell. Also working on a Jabber interface. Already using jabber in many administration areas of cubicFusion. The latest Openfire release really rocks.

5) As always many things are running side by side. Really feel the need for some vacation LOL So if you contact me about contract work, it might take me some time to get back to you ;) Please do not hesitate to ask, as I am always looking for new interresting projects.

Really glad that the weather has been good to me the past days, as I was really getting office / cave depressed :) Can finally do my daily Inline Skate rounds again, about 16-20 kilometers in the evening (perfect to get that heart of mine really pumping).