Keeping the Crazy out of Your Comments

FacebookTwitterGoogle+LinkedInDiggEmail

Recently, Google announced that they are rolling out comment moderation abilities to a handful of YouTube users, with plans for a widespread release in the future.

This is a welcome addition to the YouTube community, and anyone who has ever been brave enough to view comments on even the most innocent of YouTube videos knows exactly why. For beneath nearly every YouTube video lies some of the most ignorant, racist, and profane collection of nonsense you could ever imagine.

So, I started thinking… if a universally popular site like YouTube is experiencing these problems, what about our customers here at IX? What is an upstart blogger or online business owner supposed to do if they want user feedback, but want to avoid this type of online nastiness?

The Problem

Comment spam a very odd phenomenon that takes place on the internet. The ability to anonymously say anything you want, coupled with the absence of accountability, turns some people into raving maniacs who choose to take out their frustrations and insecurities anywhere they can.

This problem isn’t only affecting YouTube, either. Take a look at the comment section of any website that handles movie reviews, news, politics, or gaming. You’re sure to find your fair share of senseless aggression and filth.

So, the question is, how do website owners defend themselves from these malicious parties?

Know Your Enemy

First, let’s identify where all of this garbage is coming from. There are 3 major categories of inappropriate comment sources that you’ll want to filter out:

1. Trolls – Trolls are people that get a kick out of ruffling feathers. They will purposely try and start a online ruckus by presenting a ridiculous opinion in a serious manner, or play devil’s advocate just to rile people up. They rarely believe what they write, but they take pleasure in getting under people’s skin.

2. Bots – If you ever see a comment that sounds like an advertisement, it’s most likely a spam bot. Much like spam emails, these automated bots leave comments on popular videos and blogs with promises of great wealth for minimal effort. Here’s an example:

spammer

Note: Finding this bot spam took me literally 30 seconds. It was the most recent comment on the popular Gangnam Style music video on YouTube.

3. Genuine Craziness – Even though a lot of comment section trash is generated by people just being jerks to rile people up, there are some folks out there who have an agenda and legitimately believe in what they’re saying. These people can be particularly off-putting to level-headed comment posters because they’re typically angry, offensive, illogical, and relentless.

Filter out the Filth

Now that you know where all the junk is coming from, here are some methods to keep it out of your comment sections and message boards.

Turn off Anonymous Comments – If your blog software or comment section of your site has a setting that allows people to comment anonymously, make sure to switch it off. This will cut down on a very large amount of spam bots and trolls.

Captcha – This free program prompts the user to type in a series of letters or numbers before they make a comment to ensure that they are a live human being and not an automated spam bot. You may have seen these at one time or another on an online store or when signing up for a newsletter.

recaptcha

 

Captcha plugins are available for popular blogging and CMS software like WordPress, MediaWiki, and ASP.NET. Check out their website for more information.

Text Filters – Check to see if your blog or forum software of choice has a plugin that will filter out profanity, sexual references, and racial slurs. Some of these filters will just replace offending words with asterisks, while others will restrict an offending message from being posted at all. This should drive away or at least censor people who want to simply coat your comment section will four-letter words.

Don’t Over-Censor

Not all confrontation is necessarily bad when it comes to online comments. While filtering out the bad apples makes a comment area a better, more peaceful place, don’t be tempted to start banning people because of minor disagreements or legitimate gripes.

For instance, if you sell a product, and someone leaves a message on your comment board that says, “Your product broke after 3 days. Not a happy customer,” you might be tempted to remove the content or ban the user so they don’t spread any more ‘bad press’ about your company. However, this is a huge mistake and can backfire for a number of reasons.

For one, your customers are your revenue base, so it’s best to keep them happy. Ignoring or deleting users that have real complaints doesn’t fix the underlying problem, and will only cause more headaches in the future.

Secondly, if you’re caught intentionally ignoring or censoring displeased customers, you’ll soon find yourself in a firestorm of bad press. Nothing shows your customer base that you don’t care about them more than deleting bad reviews to skew public reception into your favor. People will take to Facebook, Twitter, Yelp, and anywhere else that people will listen to decry your name and shady business practices. When it’s all said and done, the act of censoring a negative review can hurt far more than the negative review itself.

It’s best to address gripes and complaints head on, and in public. Make your own comment profile and respond to customers’ concerns directly. Let your users and customers see that you’re not afraid to address the issue and help someone who’s unhappy. It demonstrates your willingness to work with people and your openness to criticism.

Conclusion

These tips should help you ward off the majority of cyber-crazies, but there isn’t an everlasting cure-all. You have to be a constant gardener when it comes to your website’s forums. So, periodically check your comment boards and user forums from time to time to make sure they haven’t been consumed by the internet’s darker side.

Thanks for reading, and good luck!

FacebookTwitterGoogle+LinkedInDiggEmail

How to migrate a WordPress site

FacebookTwitterGoogle+LinkedInDiggEmail

Because of the increasing popularity of WordPress, the question of how to migrate an existing WordPress site is one we receive frequently.  Several of our customer relations specialists have assisted in fine tuning a general process, and we thought we would share this set of instructions in the hopes that it will save you some frustration in attempting this task on your own.

This post assumes you have basic knowledge of navigating both the WordPress Dashboard, and the IX Web Hosting control panel.

Utilities you will need:

  • Either a search-and-replace tool, or an advanced plain-text file editor with a search/replace function (Windows Grep or Notepad++ recommended)
  • A compression utility with .gzip compression option (7-Zip recommended)
  • A ftp-client and the ftp information for your account (FileZilla recommended, ftp info can be found/changed inside your IX Control Panel under FTP Manger)

Inside of your WordPress Dashboard (aka wp-admin)

  • If your Permalinks settings are something other than “Default”, take note of this setting and change it to “Default”
  • Take note of your Widgets settings and locations as sometimes these are reset when moving your installation
  • Take note of any custom menu buttons for the same reason
  • Finally, take note of the Blog location and Home location settings inside of the General settings section.  You will need these.

Using a ftp client (such as Filezilla)

  • Copy all of your WordPress site’s files to your computer
  • After the copy is complete, copy it again so you will have a second backup just in case.  You will be modifying at least one copy of this backup, so creating another is recommended in case anything goes wrong
    • This can be done before changing the settings in the WordPress Dashboard but occassionally a plugin will rewrite a file based upon your Permalinks settings.  Therefore, I typically suggest doing this after making the Permalinks change.

Inside phpMyAdmin – Export

  • Launch phpMyAdmin from your IX Control panel using the mysql database username chosen when your WordPress installation was created
    • If you do not know your database username, you may find it inside of your wp-config.php file
  • Once inside of phpMyAdmin, click on (or choose from a dropbox) the WordPress database name on the left side of the screen
    • Again, check your wp-config.php file if unsure what your database name is
  • You should now see, on the main section on the right side of the screen, a list of your database’s tables.  These usually start with the prefix “wp_” but another prefix also could have been specified during the WordPress installation.
  • Click on the Export tab at the top of the screen.
  • Without changing any options, click the Go button at the bottom of the screen.  This will start the database copy process and may either ask you to download a file ending in the extension “sql” or may even open this file in your browser automatically.  If your browser automatically opens this file, wait for the page to fully load, then save the file to your computer from your browser’s menus.
  • Just as with the files you downloaded via ftp, make a 2nd copy of this file just in case

Congratulations – 1/3 there

If you’ve made it this far, you have a truly FULL backup of your WordPress site.  If anything ever happens to your WordPress site, you can use these files to overwrite and restore it to today’s exact settings and content.

Prepare your database backup for migration

  • Your database backup “sql” file contains information specific to your old blog.  You need to search and replace that information to the new blog location.  To do this, you can either use a program such as Windows Grep, or open the file with a PLAIN-TEXT editor.  Notice the emphasis on PLAIN-TEXT… do NOT use office document editors as they may alter the contents of this file, or not load at all because of the sheer size of this file.  I recommend using Notepad++ or Dreamweaver if you have them… Notepad++ is free, lightweight, and easy to use, and Dreamweaver is a common favorite of developers (and a free trial is available if you don’t own your own copy).  Windows Grep will do this process much easier and faster, especially on older computers, since it doesn’t attempt to load the entire file into memory at one time.
  • Once you have either of these, look for a “Find and Replace” or just “Replace…” option in the menus.  You will need to search/replace both the Blog location and Home location you made note of earlier (these may be the same, if so, only one search/replace is necessary) and of course you are replacing with the new locations you intend to use.
    EXAMPLE: Search For: olddomain.com  Replace With:  newdomain.com
    • If either the new or old WordPress location involve a subfolder… be sure to type this in in the following format “mydomain.com/foldername”
    • As I hinted at in the description of this section, this file may be HUGE!  Depending on the speed and power of your computer, you may be waiting a while for it to open the file, and even longer still for it to replace everything.  If you have a really old or low performance computer, you may not be able to complete this part… but one of our customer relations specials can attempt to do so for you
  • Once the replacement is complete, save this file (as a new name if you’d like so can easily distinguish it from your backup copies)

Prepare your file backup for migration

  • Just as you searched and replaced your database backup, you should also search and replace every file in your file backups as well.  Don’t worry, you shouldn’t have to do this individually with each file – all three of the programs I recommended have a search and replace option for an entire directory at a time.
    • Find this option to search multiple files/directories and, just like above, search for your old WordPress location, and replace with your new WordPress location

Create a new database for the new location(s)

  • This will not be necessary if you intend on re-purposing the same database you were using before, but will be necessary if you are changing accounts, changing hosts, or keeping the previous WordPress location active
    • Click on MySQL Server inside your IX Control Panel and follow the steps to create a new database, a NEW user (for both security and performance reasons, do not re-use the same user), and a new password.
  • When creating your database, you will have the option to specify a description – I always recommend writing the name of the domain (or domain+folder), your chosen “name” for the blog, or another unique identifier so you can easily know what this database is used for
  • The password will need to contain, at minimum, one uppercase letter, one lowercase letter, and one number
  • Make note of the following 4 things as you are going through this process… you will need them:
    • Database Host (mysql####.ixwebhosting.com for example)
    • Database Name
    • Database User
    • Database User Password

Update wp-config.php

  • This will not be necessary if you intend on re-purposing the same database you were using before, but will be necessary if you are changing accounts, changing hosts, or keeping the previous WordPress location active
    • Almost done with the modifications now… this one is easy.  Find the copy of the wp-config.php file you copied via ftp earlier and open it in your plain-text editor.  Now, find and update the Database Host, Name, User, and Password with the ones you noted earlier when you created your new empty database.  There are literally only four lines here and they’re at the top of the file so you won’t need any search/replace tool… just make sure that all 4 options retain the quotes that were surrounding them before you started.

Compress your modified database file

Unfortunately, while phpMyAdmin will generally export large database files, due to the load importing a large file can generate, phpMyAdmin has been limited to only import a file as large as 2MB.  This means that the file you just modified is probably too large for phpMyAdmin to accept.  The GOOD news is that phpMyAdmin will accept archived files.

  • Using the compression utility of your choice, create an archive out of the file you just finished modifying and choose GZIP as the format (again, 7-Zip is recommended here because it’s free and fairly easy to use)
    • Some versions of phpMyAdmin do accept ZIP (.zip) files, but all versions accept GZIP (.gz) files so of course I recommend you choose this format

Ready to migrate

Alright, in theory you now have a copy of WordPress ready for uploading to your new blog location.  Because you have a full backup of your database and files, you will not need to install WordPress first in this new location, and will simply put them into place.

  • Using your ftp-client, connect to the location of the new blog, and upload all of the WordPress files you copied down earlier (and the modified wp-config.php file of course)
  • Using phpMyAdmin, go through the same steps you did to Export, only this time choose the NEW User, and choose the Import tab.
    • If given an option to “continue on errors” on this import page, check this option
  • Click on the Browse button and find the GZIP file you created with your modified database backup, and click Go

Cross your fingers

Now your WordPress installation should be fully migrated, and is often mostly if not fully functional.  Try to browse to your new WordPress location and if it displays, click on a few links to make sure everything works properly.  If it does NOT work correctly, or doesn’t load… continue with these steps:

  • Log into your new location’s Dashboard
  • Check the General settings tab to make sure the Blog and Home locations are correct (if not, there may have been a mistake in your search/replace)
  • Check your Permalinks settings and make sure they are set to Default (for now)
  • If either of these were changed… try your blog again.  If still not working correctly, go back to your Dashboard again…
  • Set your theme back to the default WordPress theme
  • Disable (you shouldn’t need to uninstall) your plugins
  • After saving all of these changes… go test your blog again.  It will probably work but won’t look anything like you want.
  • Re-enable your theme
  • Re-enable your plugins one-by-one
  • Change your Permalinks back to the way you had them before

* If your WordPress site is STILL not working correctly… there may have been a problem with one of the steps above, or there could be factors outside of the norm (such as an oddly coded plugin, too low of PHP memory_limit, etc).  At this point, we can try to troubleshoot what the problem is, but depending on what the issue is… we unfortunately cannot guarantee success.  WordPress is a third-party application and has third-party plugins and themes.  As we are not developers, and are not the creators of either WordPress or your theme or plugins, we may not be able to fix the move… however we will be happy to take a look and try.  At the worst case scenario, we do have a development team who can offer you a quote to either fix, move from scratch, or remake your WordPress blog at it’s new location.

Thank you for reading this rather lengthy tutorial.  I sincerely hope it is of use to you, and of course if you find anything incorrect or that can be improved, please be sure to let me know.

FacebookTwitterGoogle+LinkedInDiggEmail

We're Always There When You Need Us The Most!

Your Dedicated Support

At IX, we take care of our customers. And dedicated support is one of the ways we prove to you again and again that we are here to help you every step of the way, regardless of your skill level. With IX dedicated support, you get a support technician personally assigned to assist you. You get their name, number, email, social media connections, and work schedule! It's just one more facet of our service which proves our deeply rooted belief that being a great hosting provider requires more than just cutting-edge technologies, but the best in support and service.