Copy SQL Server database on same server

January 9th, 2012

Use the following instructions when you need to create a copy of an existing database on the same server.

- Create a backup of the existing database.
- Create the new database and select the task ‘Restore’
- Select the db backup file to restore, however as the backup is for another database on the existing server the option ‘Overwrite the existing database (WITH REPLACE)’ must be selected
- Before restoring the database, just check the filepaths where the database is being restored too!

Magento file and directory permissions

November 29th, 2011

Make sure file and directory permissions are set correctly for a magento installation - check here http://www.magentocommerce.com/wiki/groups/227/resetting_file_permissions

Magento - Call to undefined method Mage_Adminhtml_Block_Widget::getrowurl()

November 23rd, 2011

This error occurred when navigating to ‘Catalog’ -> ‘Manage Categories’. The page did not display correctly and this error could be found in the page by using ‘view source’.

A temporary ‘hack’ fix was found here: http://www.naveenos.com/2011/01/fatal-error-call-to-undefined-method-mage_adminhtml_block_widgetgetrowurl-in-magneto-1-4-2.html

Use a secure password people!

November 23rd, 2011

http://www.smartplanet.com/blog/business-brains/the-25-worst-passwords-of-2011-8216password-8216123456-8242/20065?tag=nl.e098

Adding items to a databound DropDownList

November 23rd, 2011

Use the AppendDataBoundItems property - see http://weblogs.asp.net/andrewrea/archive/2008/01/23/test-post.aspx

How to install magento extensions

November 3rd, 2011

How to install a magento extension using FTP or SSH:

http://www.aschroder.com/2010/05/installing-a-magento-extension-manually-via-ftp-or-ssh/

How to install using Magento Connect Manager or PEAR:
http://blog.magikcommerce.com/how-to-install-magento-extensions-magento-extension-installation-guide/

Upgrade from wordpress 2.x to 3.x

November 1st, 2011

Its actually quite simple to upgrade to wordpress 3.x. Here’s a step-by-step guide…

Just a small note, to disable plugins add define('DISALLOW_FILE_MODS',true); to your config file.

http://wordpress.ralfengel.com/mu-upgrading/upgrade-wp-mu-2-6-5-to-new-wordpress-3-0

Running magento 1.3.x on PHP 5.3.x

October 21st, 2011

If you hit the error message - Unknown error (8192): Function split() is deprecated in /app/code/core/….

take a look at this…

http://www.geekieblog.com/2011/03/magento-1-3-x-environment-won%E2%80%99t-run-on-php-5-3/

Magento database maintenance - large db tables

October 19th, 2011

If you’re noticing your magento site database has grown to become very large take a look at this article on magento database maintenance…

http://docs.nexcess.net/magento-database-maintenance

Magento - Setting free delivery by product or category

September 16th, 2011

http://www.ankitsharma.info/blog/magento-free-shipping-on-specific-category-product