Cleaning the log tables and rebuilding indexes with shell scripts

Based on the same idea as my “cache clearing script“ (but 10x better), Magento now includes some handy scripts to clean the log tables, to compile source files and to rebuild indexes. For people with very large databases (10k+ products) this is sometimes the only way to actually accomplish something without running out of memory or exceeding execution time […]

Updating Magento code to be compatible with PHP 5.3

Even tough PHP 5.3 has been out for quite a while, there is still lots of old code out there that will not run correctly when moved from 5.2 to 5.3. In my case I had to move a 2 year old Magento website to a new server and ran into problems as the default […]

Magento Notice: Undefined index: 0

Today I got this mysterious error message after moving a Magento website to a new server. Magento Notice: Undefined index: 0  in …/htdocs/app/code/core/Mage/Core/Model/Mysql4/Config.php on line 92 Turns out this was due to a faulty import of the database. Apparently there are a few tables where using an id of 0 in the auto_increment column has […]

Netbeans Preparing Commit

If you ever tried to SVN commit a big project using Netbeans (Magento?) you have most likely seen that “Preparing Commit” message doing seemingly absolutely nothing for several minutes. Apparently the commit takes forever because Netbeans is scanning the entire projet to localize any changes done by external applications before committing. This is not really an […]