Change your WordPress table prefix

Change your WordPress table prefix

This post is a bit more advanced, but important. One of the most common ways an intruder gets into your system is through what is called an SQL injection. In order to combat this, the most effective initial step you can take is to rename your WordPress table prefix. There are two ways to do this; find a plugin that does it, or more advanced if you have database access, is to make the changes yourself.

If you're just installing WordPress, open the wp-config.php and change $table_prefix = 'wp_';

to $table_prefix = 'wp_hg143g7_';

Replacing hg143g7 with any combination of letters and numbers you wish. Now install WordPress, and all is well.

If you have WordPress already installed, backup your website and database before you follow the next steps. Expect a few minutes of downtime while you make these changes.

I've not tested this plugin, but there is a change table prefix plugin you can use. Run it once, then you can delete the plugin. done.

The more advanced manual option:

  • Change $table_prefix in wp-config.php as I suggested above.
  • Change the table names in phpMyAdmin, or using SQL:
RENAME table `wp_commentmeta` TO `wp_hg143g7_commentmeta`;
RENAME table `wp_comments` TO `wp_hg143g7_comments`;
RENAME table `wp_links` TO `wp_hg143g7_links`;
RENAME table `wp_options` TO `wp_hg143g7_options`;
RENAME table `wp_postmeta` TO `wp_hg143g7_postmeta`;
RENAME table `wp_posts` TO `wp_hg143g7_posts`;
RENAME table `wp_terms` TO `wp_hg143g7_terms`;
RENAME table `wp_term_relationships` TO `wp_hg143g7_term_relationships`;
RENAME table `wp_term_taxonomy` TO `wp_hg143g7_term_taxonomy`;
RENAME table `wp_usermeta` TO `wp_hg143g7_usermeta`;
RENAME table `wp_users` TO `wp_hg143g7_users`;

If there are other tables that start with wp_ from plugins etc, change them as well. Now search the options table:

SELECT * FROM `wp_hg143g7_options` WHERE `option_name` LIKE '%wp_%'

rename any results with wp_ to the new prefix. Now search usermeta for the same thing:

SELECT * FROM `wp_hg143g7_usermeta` WHERE `meta_key` LIKE '%wp_%'

At this point any tables starting with wp_ should have the new wp_hg143g7_ prefix.

Modifying your WordPress screen options in the Dashboard

One of the options in WordPress you may not yet know about is your screen options. When in your Dashboard, look to the top right underneath your name, there should be two pull down menu options; Screen Options and Help. When you click on the Screen Options tab, you should see something like this:

 

Wordpress Screen Options WordPress screen options in the Dashboard

As you try the various options, you'll see them be added or removed in real time. You'll notice different options if you do this in the main Dashboard area, vs being "Add New" posts or "Add New" page, so try the screen options in each of these. Here is how it will look under "Add New" posts for example: 

Post screen options Post screen options

 

You can see the options are different, and as you click on add or delete, you should see the option be removed from your screen. If you don't see any windows being removed or added, you may have to scroll down if you have a lot going on — on your screen. For example, I'm using a plugin called WordPress SEO by Yoast that is quite large. I don't see the Discussion widget get added or removed unless I scroll beneath the WordPress SEO window. 

We now offer unlimited long distance phone service in North America

The only requirement to qualify for this service is that you have a broadband internet connection with low latency for our unlimited long distance phone service. You can test this by going to SpeedTest.net and click "Begin test". Under Ping you should see a number under 100ms, and under download it should be a number larger than 1Mbps. If you meet this criteria, you're ready to start the transition!

Most important to know is that we're using your internet for this connection, and as such 9-1-1 does not work with geo-location. You should use a cellular telephone in an emergency. 

We'll mail you your new VoIP hardware, fully configured for you. Plug one end into your internet router, and the other into your telephone, and you're done! You now have unlimited long distance in North America! If you regularly call other regions, please contact us for pricing. For your first year, the cost is $25/month, and after that you'll be charged $20/month, paid annually. Choose from any area code in Canada or the United States. 

If you'd like to keep your existing telephone number, no problem! It will take approximately one month to transfer your current telephone number to us, and this way your friends and family won't know anything changed.

You can sign up right now on our Other Services page!

Change your admin username in WordPress

One of the first security tips I can provide is to change your admin username in WordPress. One of the ways people break into WordPress, is by a brute force attack. Once you know the username of the administrator, you take a large dictionary file of words, and try every possible combination as the password for that user until you get it right. You don't have to try this manually, there are programs that do automated, and very rapidly. On most computers and systems, the default administrator is either "admin" or "root", the case of WordPress, it is admin. I recommend you take a few minutes and go into your Dashboard -> Users -> Add New and create two new accounts. Make one an editor account, this is the only you'll typically use from now on. Also add a new account, but instead of giving it editor privileges, choose "Administrator" as the role. Once you verified you can login to both of them with the appropriate permissions, delete the "admin" account. (Bulk actions -> Delete -> Apply)

If your WordPress themes says which editor approved each post, you'll want to go into Posts -> All Posts and check any post that says admin. Then go to Bulk Action -> Edit and change the Author option to the new editor and choose update.

You'll also want to ask yourself, "How strong is my password?"

Google releases a new tool to disavow links

Today Google released a new tool to disavow links to help resolve negative search engine optimisation (SEO) results.This follows Microsoft's Bing search engine who released a similar tool back in June. Most website owners can safely ignore this warning, unless you're aware of bad links to your site you really would like to disassociate from. Previously Google just ignored them, but with their new "Penguin Update", they now rank such links as negative. As such, this forced them to offer a tool to webmasters to clearly identify the unwanted links. Think about this tool as the ability to tell search engines which web sites you don't trust that are linking to you, and that you're aware they have a much lower page rank than yours does. If you've never received a warning from Google about bad links or spam links, you can probably ignore this. If you've received such a message in the past, go straight to the tool which is now active in Webmaster tools

If you're looking to work on your SEO, SEOMoz has a useful post on 17 types of link spam to avoid, before someone adds you to their disavow links tool. 

 

Would a free website help you get off the ground?

Through my regular attendance at events like Ideas Meetings, ASC and IdeaWave, I know that a lot of people have ideas for a product or business they'd like to launch.  However, they often cite finances as a barrier to entry and of course getting a website started for a new product does entail a financial commitment.  As many of you know, I volunteer more than I work and I prioritize on giving back to the community; as such, I'm excited to announce One Day Website will begin giving away one free website per month.  Not just a One Day Website, but the Custom Tailored package, including wo hours of graphic design,and two hours of copy writing or editing of your existing content.

To be eligible, send an email to [email protected] with 200-400 words on why we should choose you out of the other applications. Tell us what sets your idea apart and why you think your product or business could be successful; we want to hear your personal story in your own words to help create the best website to help your vision become a reality.  Special consideration will be given to products or ideas that will serve to benefit the community as well as you individually.  By submitting an application, we can use your submission in any promotional materials we choose. We will include one year of hosting, but after that, you'll be responsible for the yearly hosting fee.  Please refer to the Details page for a full explanation of benefits, terms and conditions included with the initial yearly package.

In the spirit of fostering a cycle of community giving, we hope that when you make your first $1000, you pay us back the $499 so that we can continue to help others.  Submt your entry today – we're excited to see what you can come up with and how we can help spread the word!

 

What is a WordPress CMS?

If you're looking to create a website and you're not a techy, you're probably not yet that familiar with hypertext markup language (HTML) or cascading style sheets (CSS). Instead, you're likely looking for a content management system or CMS. A CMS allows you to edit all of your pages from one central place. They also allow for a collaborative website, if you have other family or staff you'd like to help you edit your website. You can think of a CMS like having two websites. The first is the CMS, which you need to login to, the second is the public website that everyone sees. As soon as you save a change in the CMS, it automatically appears.

Here at One Day Website, we use the Wordpress CMS. It's also the easiest to learn, and the most popular. By using WordPress, you'll get their popular Dashboard, where you can create a new webpage, or blog post, in seconds, without any knowledge of HTML or CSS, it looks more like a Wordprocessor instead.

Add new page

If you have an old or outdated website, we can convert it to a WordPress template. This means it will look the same to your website visitors, but now that it will be using WordPress CMS, you can easily update any of the pages or blog posts at your convenience. And if you find yourself with writers block, don't hesitate to use our professional copy writers, who can write the content for your website as well, with a focus on your target audience and search engine optimization.

Trying the Responsive Web Design friendly Soliloquy slider

A couple things we've been working on are responsiveness, and customer satisfaction. Responsive Web Design (RWD) is the application of building your website(s) with the idea they may be viewed on various devices, be it a cell phone, tablet or desktop computer. For example, if this post is difficult to navigate or read in your current viewer, please let me know. It should resize as your display does. 

Is your WordPress theme responsive? Have you tried to view it on a smart phone or using a text only browser like lynx?

Social driver has posted what they feel are the 20 best responsive websites of 2012.

I was really excited to get rid of the HTML table on the portfolio page, and try a slider, but finding an easy to use responsive slider that doesn't require a third party interaction took a little research. This brought me to the free Soliloquy slider for WordPress. See the slider in action with a rotating dozen of our portfolio examples on our portfolio website examples page.

If you install and activate the plugin, you'll see "Soliloquy" under Settings in your Dashboard. I went to "Add new" and entered a slider called "Featured clients".

Screen Shot of Soliloquy Screen Shot of Soliloquy

In there I added a dozen screen shots of client websites (you can use any pictures you wish), made sure I entered ALT tags for the vision impaired, and finally added URL links in case people click on the image, they can be brought to the actual website. You can then take the shortcode they provide and paste it into any page or post, and that's it. Let me know if you have any issues!

Even lower prices, and new features; we’re one year old!

To celebrate our one year anniversary, I'm excited to announce some lower prices, as well as some new features. For our first year, we've been offering a single plan, at $399. This is when some of our competitors charge between $2,000 and $5,000 for the same service, and we have you up and running in one day. Instead of moving closer to our competitors, we're making it even easier to choose us; our introductory website package is now only $299!

Thanks to your continued support, we've hired a graphic designer, as well as a copy writer/editor to help you with your content. You can hire either at our standard service rate. We've found that most people using our introductory package want some graphic design and/or copy help, so we're introducing today, two new packages. The Custom Tailored package is the traditional package, as well as 2 hours of graphic design, as well as 2 hours of copy writing or editing, for only $499! We're quite confident no one can compete with us any longer. And just in case you've got a little more budget, for $899 we'll provide you our Business One Day Wesbite which offers yet another 2 hours of graphic design, and 2 hours of copy help, as well as set you up with website analytics! With 8 hours of labour, and the analytics and SEO install, that makes your website setup and hosting effectively free!

For more information, check out our new Compare Plans page. Contact us if you'd like more information. 

 

 

Add Meta Description tags for everything

If you authored websites with HTML in the past you probably remember meta keywords tags; these have effectively been rendered useless, as so many people used keywords that weren't applicable to their site to gain traffic that would have otherwise gone to their competitors. Because of this, Google no longer uses meta keyword tags in web ranking; however, they do still utilize "description" meta tags for results snippets as described in this article.  

It should be obvious by now that you can add a description for every page as well as post in WordPress, and these are really handy as Google will often pick them up to use under your links. One of the often neglected areas in WordPress where site owners forget to add meta description is categories and tags. In your Dashboard, you should be able to find each of them under the Posts sub-heading. Once there, choose edit and use the description field to describe it as best you can. There's a lot of space you can use there, so don't waste it. Some themes don't use this field, so when you save the description for the first time, see if you can find it on the website. Even if you can't see it anywhere, don't feel you've wasted your time; search engine web crawlers will pay attention to every word you use.! From WordPress SEO by Yoast, "The meta description is under 120 characters, however up to 156 characters are available. The available space is shorter than the usual 155 characters because Google will also include the publication date in the snippet."

Spending a little time to add a description to every page, post, category and tag is just one more place you can make it easier for potential customers to find you.