Admin Access for WordPress in a SQL Database

PROBLEM:  You login to your WordPress and someone, possibly your client, has removed your admin access. SOLUTION: Open your MySQL database through phpMyAdmin (or whichever software package you use.) Click on the database name (not the information schema) on the left. Click on wp_usermeta. Click Insert at the top. unmeta_id = blank user_id = number […]

Read more

What is considered good in analytics stats?

Here is a list of the average numbers you should shoot for when viewing Google Analytics information. Pageviews: 2 pages Average Time on Page: 1-3 minutes (depends on length of the content) Length of Visit: 2-3 minutes Pages per Visit: 3-4 pages Small Business: 500 unique visitors each month (16 visitors a day/1100 pageviews month) […]

Read more

Remove First Character in a Cell

PROBLEM: Some (or all) of your entries have a character at the beginning that needs to be removed. For Example: 12125551212 is a phone number, but you need to remove the 1 and have 2125551212. SOLUTION: The trick is to use a combination of functions. I am assuming you already know how to use the […]

Read more

Smart Quotes in WordPress

PROBLEM: You do not want your posts to have smart quotes. SOLUTION: Download nosmartquotes.php and put it into your plugins folder. Go to your plugins page and activate it. If it works correctly, these "  '  " should not be smart quotes. WHY: Because sometimes, when you copy and paste smart quotes, it adds unusual […]

Read more

Windows Activation After 30 Days

PROBLEM: Windows Activation has expired after 30 days. SOLUTION: Expand activation to 120 days. Start --> All Programs --> Accessories. Right-click on Command Prompt and got to Run as Administrator. (You might need to know a password to go beyond this point.) You should default to the following folder: c:\Windows\system32\ Type in slmgr -rearm Hit […]

Read more

Skype Turns Down Volume

PROBLEM: You receive a phone call and pause your music player. When your call is complete and you unpause, the volume has been decreased. SOLUTION: Right click the speaker icon in the bottom right-hand corner and go to SOUNDS. Click on the COMMUNICATIONS tab.  Select DO NOTHING and then click OK. WHY: Skype is automatically […]

Read more