TechCounter - TechNews, Money & SEO

If you are getting a database error like this after upgrading to WordPress 2.3

WordPress database error: [Table 'yourdb.wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM `wp_posts` p LEFT JOIN `wp_post2cat` pc ON p.ID = pc.post_id LEFT JOIN `wp_categories` c ON pc.category_id = c.cat_ID WHERE post_status = ‘publish’ GROUP BY cat_ID

Warning: Cannot modify header information - headers already sent by (output started at /homepages/18/yourdb/htdocs/wp-includes/wp-db.php:160) in /homepages/18/yourdb/htdocs/wp-comments-post.php on line 67

Warning: Cannot modify header information - headers already sent by (output started at /homepages/18/yourdb/htdocs/wp-includes/wp-db.php:160) in /homepages/18/yourdb/htdocs/wp-comments-post.php on line 68

Warning: Cannot modify header information - headers already sent by (output started at /homepages/18/yourdb/htdocs/wp-includes/wp-db.php:160) in /homepages/18/yourdb/htdocs/wp-comments-post.php on line 69

Warning: Cannot modify header information - headers already sent by (output started at /homepages/18/yourdb/htdocs/wp-includes/wp-db.php:160) in /homepages/18/yourdb/htdocs/wp-includes/pluggable.php on line 391

The cause of these database errors where wp_post2cat does not exist is due to a single plugin which is not compatible with WordPress 2.3

go on reading »

If you liked this article, click here to buy me a coffee!

Popularity: 20% [?]

If you bought an iPhone, the first time you plug into your computer and link it up with iTunes, you have to agree to some legal terms and conditions. Following is the Apple iPhone Software terms and License Agreement.

U.S. - ENGLISH

IMPORTANT: BY USING YOUR iPHONE, YOU ARE AGREEING TO BE BOUND BY THE FOLLOWING APPLE AND THIRD PARTY TERMS:-

A.    APPLE iPHONE SOFTWARE LICENSE AGREEMENT
B.    GOOGLE MAPS TERMS AND CONDITIONS
C.    YOUTUBE TERMS AND CONDITIONS

APPLE INC.
IPHONE SOFTWARE LICENSE AGREEMENT
Single Use License

PLEASE READ THIS SOFTWARE LICENSE AGREEMENT (”LICENSE”) CAREFULLY BEFORE USING YOUR IPHONE OR DOWNLOADING THE SOFTWARE UPDATE ACCOMPANYING THIS LICENSE. BY USING YOUR IPHONE OR DOWNLOADING THIS SOFTWARE UPDATE, AS APPLICABLE, YOU ARE AGREEING TO BE BOUND BY THE TERMS OF THIS LICENSE. IF YOU DO NOT AGREE TO THE TERMS OF THIS LICENSE, DO NOT USE THE IPHONE OR DOWNLOAD THIS SOFTWARE UPDATE. IF YOU DO NOT AGREE TO THE TERMS OF THE LICENSE AND HAVE NOT USED THE IPHONE, YOU MAY RETURN THE IPHONE TO THE PLACE WHERE YOU OBTAINED IT FOR A REFUND.

go on reading »

Popularity: 15% [?]

StumbleUpon has released a new toolbar version, version 3.15 which enables SearchReviews opt-in and improves existing Facebook integration.

This new SearchReviews as part of the new StumbleUpon toolbar shows which of your friends have rated a site a thumbs-up. You can see this with star ratings along with icons indicating which one of your friends like the site. This in turn allows for search personalization. You can also add people whom you think are experts in a particular category as your friends so that you can view their search result endorsements.

go on reading »

Popularity: 13% [?]

StumbleUpon has been one of my most favorite sites since I first Stumbled upon it. Since then, using StumbleUpon, I have discovered new and amazing websites which I probably would never have come across if not for StumbleUpon.

Now, in order to cater to your ever increasing personalized tastes, StumbleUpon has launched a new personalized user profile page. When you log into your current StumbleUpon homepage, you are given the option to update to the new personalized StumbleUpon homepage.

New Features

* Check out “What’s New” and find out what your friends are doing & saying
* Try the simplified navigation where all the things you want to do are right at your fingertips
* Use the integrated Visual Editor to create and enhance your blog postings

all resulting in a page that looks something like below.. more web 2.0 for lack of a better word and better organization and above all more features for the stumbleupon user. Click on the picture below to check out my Stumbleupon homepage.

Popularity: 14% [?]

For people not tech savvy or making money online using their Blogs, making money from home with a computer and internet access is a very good option to earn some money on the side by getting paid to browse the web and do paid offers.

Fummo is an advertising company which offers such promotions where you can earn money by doing simple and free offers. You can also earn money by using their search engine and surfing the web using their surfbar. You can also make money of referrals where you can make $5 per referral when you get a friend of yours to sign up using your referral link or referral ID and earn 10% of any paid offers they might complete.
There are no limitations on how much money you can make on Fummo. Seems like a good enough deal for people wishing to make money from home.

The downside, you have to view advertisements. NOTE: You do not have to click on any advertisements that are displayed which would be illegal.

So, join fummo and invite your friends also to join under you and get $5 from each your friend!

Popularity: 20% [?]

I previously blogged about displaying your email address as an image to prevent comment spam on your blog. The downside with that popular utility was that it only displayed your email address from a known ISP such as Gmail, Hotmail, Yahoo etc. But how about something that you would like to use for your own blog such as ryan at techcounter.com Well, I first thought I could code it up but why reinvent the wheel. I had Google search pretty hard for it though to find a good source. Turns out there exists an email image button generator or rather a text to image generator.

Using this Email Image Generator, you can display any email address as an image for you to use on your blog or website and help reduce comment spam greatly.

You can choose your font, font size, the color of the text as well as the image background to generate images that match the theme of your blog. You can see it in action in my contact page.

To generate an Email Image for your blog

go on reading »

Popularity: 23% [?]

A Website Directory is something that specializes in liking to other web sites and classifies and categorizes these links. Unlike search engines which bring back results to you based on keywords, a web site directory lists websites by category and subcategories. Web Directories allow blog and website owners to directly submit their blog for inclusion and have editors for reviewing new submissions.

Some of the most popular web directories are Yahoo! Directory and the Open Directory Project(DMOZ). Every search engine recommends these two web directories in particular and once accepted, you gain trust in search engine eyes not to mention the high page rank of those incoming links. All this could result in higher search engine placements for posts on your blog and an increase in page rank which in turn would allow you to monetize your site even further. Oh, also the increased traffic to your blog by visitors to these directories.

Directories have various types of listings, often dependent upon the price paid for inclusion:

* Free Submission - there is no charge for review of the site
* Reciprocal Link - the site submitted must link back to the directory in order to be listed
* Paid Submissions - a fee is charged for reviewing the submitted link

* No Follow - there is a rel=”nofollow” attribute associated with the link, meaning search engines will not follow the link.
* Featured Link - the link is given a premium position in the category where it is submitted
* Featured Homepage Link - the link may be listed on the homepage of the directory.
* Bid for Position - a recent innovation (2007) where sites are ordered based on bids

Yahoo! Directory and ODP are very hard to get into. I know of a website which in spite of having a high Page rank and high traffic did not get accepted into ODP for over 14 months. I have listed some of the website directories out here which will help bring more traffic to your blog. The name of the website directory along with its page rank is shown here. The list starts with a Page rank 8 directory and lists page rank 7 and page rank 6 directories.
go on reading »

Popularity: 17% [?]

One of the biggest issues having a blog is dealing with comment spam. Email harvesters crawl your blog like search engines and find and extract email addresses from web pages. An Email address always contains an @ symbol. These email harvesters do a pattern search for a combination that looks like abc@xyz.com in the HTML source of your web pages. So how to keep your email address visible to humans and your blog visitors but keep them invisible to email spiders.

One of the best methods I find is replacing the email message from text to an image. This results in your email being visible to your blog visitors but invisible to spam bots. There are many other ways which you can use to prevent your email from being spammed and how to hide your email address from spammers.

For now, I will share with you an E-Mail Icon generator which creates an Image Icon of your Email Address. You can use this email image for displaying your email address in your blog.

Some of the example email icons

go on reading »

Popularity: 17% [?]

Google AdSense gives you the option to block competitors ads on your Blog using their Competitive Ad Filter, part of Google AdSense. Google allows you to enter upto 200URLs in here. If you don’t publish ads through Google Adwords, you might be under the impression that hey, I don’t need to use this filter. But you are definitely missing out on additional revenue. Have you ever checked your Google AdSense account and see ad impressions that resulted in a revenue of 1 cent to you? I certainly have. What happens is that you end up losing a valuable visitor to your blog for 1 cent and that too , the ad they click on isn’t of much use because they most likely just clicked on a Made For AdSense (MFA) site ad.

What is a Made for AdSense site?

Have you ever been to a site where there is absolutely no content and all you see are ads, Google AdSense Ads, Yahoo ads, ads ads and more ads. These sites contribute a lot to the internet junkyard and provide no value except to get web visitors to click on advertisements. These MFA sites offer a low CPC rate which takes brings them traffic at a very lost cost. Then these sites make money off the visitor to your blog by serving ads with a higher return.

Implementing the Competitive Ad Filter in your Google AdSense Account

You can prevent these MFA sites from serving ads on your blog or website by using Competitive Ad Filter in your Google AdSense account. When you block these sites, you end up with higher paying ads on your blog.

To get the URL of the site you wish to block, you can use the Google AdSense Preview tool. The Google AdSense Preview Tool is a better option as it prevents you from accidentally clicking on the ads. You can use a different method to find the URL of Flash based ads as the AdSense Preview tool does not work for such ads.

Another excellent site is Ads Black List. This site will generate a list of sites which you can use to filter. However this is a paid service. My firm is responsible for managing many sites.

Here is a list of 200 URLs which I have refined over time and which you can copy and paste into your competitive ad filter.

go on reading »

Popularity: 19% [?]

The list below shows the oldest domain names registered.

Some interesting Observations

1. The first website registered was Symbolics.com on 15th March 1985. Symbolics was the producer of special-purpose computer systems for running and developing state-of-the-art object-oriented programs in Lisp

2. The first defence company registered on the Internet was Nothrop Grumman

3. First R & D site was sri.com or Stanford Research Institute

4. Rosetta.com was registered in 1987. God.com was registered 1994.

5. SEX.com was not registered until 18th October 1995

6. sco.com was registered in 1987 whereas unix.com was not registered until 1993

Rank    Create date           Domain name
1.            15-Mar-1985          SYMBOLICS.COM
2.           24-Apr-1985           BBN.COM
3.           24-May-1985          THINK.COM
4.           11-Jul-1985             MCC.COM
5.           30-Sep-1985           DEC.COM
6.           07-Nov-1985          NORTHROP.COM
7.           09-Jan-1986           XEROX.COM
8.           17-Jan-1986           SRI.COM
go on reading »

Popularity: 19% [?]