insert into admin_user select (select max(user_id) + 1 from admin_user) user_id, ‘FIRSTNAME’ first_name, ‘LASTNAME’ last_name, ‘myemail@noemailaddress.com’ email, ‘USERNAME’ username, MD5(‘NEWPASSWORDHERE’) password, now() created, NULL modified, NULL logdate, 0 lognum, 0 reload_acl_flag, 1 is_active, (select max(extra) from admin_user where extra is not null) extra, NULL, NULL; insert into admin_role select (select[…]
Read More »There are many tutorials out there that show you how to install Magento using SSH, but in my experience, there is always something that is missing. Here’s a collection of what I’ve found to work. I am using the Magento Sample data on this installation as well. For those of[…]
Read More »Access phpMyAdmin and select the database you need to export. Change “Compression” to bzipped. Click the “Export” Tab. Click the “Custom – display all possible options” radio button. Click “Disable foreign key checks” checkbox. Click “Add DROP TABLE” checkbox Click “Go” button
Read More »It’s actually quite simple to do, and I’m surprised that Magento doesn’t come with a default “Contact” page already setup. First, login to your Magento admin and navigated to CMS > Pages. Click “Add New Page” button. Just fill in your Title, URL Key and select your Store View. Make[…]
Read More »This has to be one of the greatest tips for ANY Magento developer. I’ve had to use it MULTIPLE times. Giving credit where credit is due, this is not my post but originally posted here at TJGamble.com. Although it says this is for Magento version 1.4.1, it does work in[…]
Read More »Open /app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php Create the file structure of : /app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php Copy the contents of the Core file, and paste into the Local version. Find the protected function _prepareCollection. You are going to modify this function by adding one line to make the custom attribute available for inserting into the grid. Just[…]
Read More »