Posted in: Magento, SSH

Create new Magento Admin user via SQL

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 »
Posted in: Magento, SSH

Install Magento via SSH

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 »
Posted in: SSH

Upload local file to server using ssh

Open terminal and cd to the location of your file then do the following: $ scp [filename.extension] [username@serverIP]:[folder]/. example using actual names $ scp 3.tar myusername@192.168.1.1:public_html/.

Read More »
Posted in: Magento

Exporting A Magento Database using phpMyAdmin

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 »
Posted in: WordPress

Custom Styles for WordPress Visual Editor

Create a new CSS file in your theme folder and name it custom-editor-style.css Then open your functions.php file, in your theme folder, and paste the following: function my_theme_add_editor_styles() { add_editor_style( ‘custom-editor-style.css’ ); } add_action( ‘init’, ‘my_theme_add_editor_styles’ ); Then write your new styles in the custom-editor-style.css file.

Read More »
Posted in: Magento

How to add a default contact form to a Magento CMS page

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 »
Posted in: Magento

New Template Page Layout In Magento

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 »
Posted in: Laughable

What Kind of Programmer are You?

#1: Gandalf This programmer type looks like a short-list candidate to play Gandalf in The Lord of the Rings. He (or even she!) has a beard halfway to his knees, a goofy looking hat, and may wear a cape or a cloak in the winter. Luckily for the team, this[…]

Read More »
Posted in: css

Removing the Dreaded tag “dotted line”

This has always been one of those issues that just drives me mad.  You’ve set border to none, yet this dotted line ALWAYS appears around your <a> element.  Well, would you believe that you can solve this with just one, very, VERY, simple line of CSS? Just add : a[…]

Read More »