• English
  • German

Home » General » Alex » jQuery Horizontal Accordion 2.0 Alpha 2 coming

Thank you for all the nice feedback for the jQuery Horizontal Accordion. I am currently finishing the next alpha version. I am adding fixes for IE and the window resize feature back into the release.

Should have a download for you start of next week.



FaceYourManga is a Flash Web Application that allows you to create an Avatar for yourself or your friends in an absolutely free, easy and quick way.



Openfire 3.6.4 gets released.



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.