How to easily move databases from staging to production environments

HeidiSQL allows you to copy entire schemas DIRECTLY ACROSS database servers!

Often times people are faced with the cumbersome task of moving an entire database from one environment to another, usually by creating a dump file of the database, moving it across from one database server to another, and re-running the script on the destination. This is irritating in that it requires one to create a file that is immediately disposed of, and to transfer that file one or two times over the wire. It is also prone to error in that it entails many distinct steps that each have their own glitches or mistakes to make. The good news is that the easy, one-step solution exists in a product you just haven't tried yet.


Getting a 500 Server Error after adding an htaccess file in Magento root

When trying to get server rewrites to work in Magento, you will need to ensure that the .htaccess file is in the Magento root directory.

On many shared hosting accounts such as GoDaddy and 1and1 you will get a "500" error from the server after enabling the appropriate settings.

Go into your .htaccess file and uncomment the "RewriteBase" directive, changing it to your folder's name.

Here's the catch for those of you not running in a virtual folder: Still uncomment it, but make it read: RewriteBase \ (that's a "backwards slash")

Vee-ola - Your site is up!


Applying One Exposed Filter Against Multiple Fields in Drupal Views

You are trying to have a single, exposed filter in Drupal Views which allows you to apply the value against more than one field to filter results.

You've tried Views PHP, CustomField and similar tactics. You've considered using some sort of jQuery function but know it's relatively hacky and possibly unreliable. You're about to give the whole idea the boot.

You've looked everywhere but cannot find a solution.

Now you have.

(Yeay - that really works! Yeay...)


Some great resources on how to get started programming Magento extensions

php Architect's Guide to Programming with Magento

Here's a great post on the basics of Magento controllers for your extension, especially IndexAction() and such:

It also ancludes this link to the best Magento dev learning site:

And finally, it links to an outstanding book for learning this crazy stuff:


Cannot seem to create new Magento admin groups in system.xml and adminhtml.xml

When learning to create a module that adds new administration groups to the Magento admin panel, follow these instructions:

However, something they fail to mention is that after you have created your new admin groups in system.xml, and after you have created your adminhtml.xml file (to allow permissions) you must LOG OUT AND LOG BACK IN (as administrator) to re-load the ACL and allow the new permissions to take effect!!! A tiny but hugely important detail. Failing to do so leads to hours of troubleshooting!!!

You heard it here first...


Subscribe to RSS - dev