SEO/SEM News

This Wordpress Blog website is going to transfer to a new host, and just to be sure of the transition process, another blog of ours was transfered earlier. Files were simply compied and the MySQL database was backed up as an SQL dump file and imported on the new web host.

Everything seemed to work fine, until we got this error that appears everytime a post is made:

WordPress database error: [Duplicate entry '0' for key 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (’0′,’_pingme’,'1′)

WordPress database error: [Duplicate entry '0' for key 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (’0′,’_encloseme’,'1′)

Warning: Cannot modify header information - headers already sent by (output started at /XXX/wp-includes/wp-db.php:102) in /XXX/wp-admin/post.php on line 60

And I did a search and ended up at an unresolved thread on Wordpress Support Pages.

Problem is, I moved the site to a hosting company with MySQL 3.23 only. And my blog was originally running on MySQL 4.1.19. My initial problem was importing the data into the new MySQL database, and when I noticed the version differences, I decided to export the data to be MySQL 3.23 compatible. And this is where the problem occured. The Auto-Increment field was disabled in all tables that need it. And that is the cause of the problem.

I had to install phpMyAdmin manually since it was not installed by default of the new host and they do not allow SSH access as well by default and I edited the following tables:

wp_categories: Edited cat_ID to auto_increment
wp_comments: Edited comment_ID to auto_crement
wp_linkcategories: Edited cat_id to auto_crement
wp_links: Edited link_id to auto_crement
wp_options: Edited option_id to auto_crement
wp_post2cat: Edited rel_id to auto_increment
wp_postmeta: Edited meta_id to auto_increment
wp_post: Edited ID to auto_increment
wp_usermeta: Edited umeta_id to auto_increment
wp_users: Edited ID to auto_increment

After doing that, the problem should dissapear.

As the roll out of the latest Google Page Rank unfolded last two days ago, everyone got excited in the Isulong SEOph SEO Keyword Ranking Contest and started checking everything.

Let’s go over the top 7 Isulong SEOph Website once again after the latest Google PR update

Gio Castro’s isulongseophil.com

He’s back at number 1, will he stay at number 1? Pinoynets.com/isulong-seoph/ has been number 1 for quite some time with that 39,000+ backlink power compared to Gio’s 1,600+ backlinks. Is it because Gio has been doing something lately more efficient making him go back up? Or is it because of the too fast inbound links created by Pinoynets making it go back down? What do you think?

The Numbers

• Indexed Pages: 14 (G), 11 (Y), 12 (M)
• Backlinks: 53 (G), 1700 (Y), 1,163 (M), 0 (A)
• Alexa Traffic Rank: 119,466
• Google PR: 4

Janjalani’s pinoynets.com/isulong-seoph/

Many were surprised when he appeared suddenly on the first page and took out Gio’s website in the number 1 spot for a quite long period. Currently with whopping numbers of a PR6 and backlinks near 40,000. For some reason, when someone gets kicked out of contention by someone that seemed to come out of nowhere, they tend to say all sorts of stuff. As people started to probe into his site and some calling him someone resorting to blackhat techniques. True or not, how he got there is still interesting and with the latest update from Google, more of his secrets are being revieled. If you did not see it, better do you research. But some of his secrets are now out in the open.

The Numbers

• Indexed Pages: 1 (G), n/a (Y), 1 (M)
• Backlinks: 258 (G), 41,800 (Y), 6,774 (M), 0 (A)
• Alexa Traffic Rank: 416,496
• Google PR: 6

Rostum Hernandez’ isulongseoph.org

I believe Rustom’s site is a bit newer than the others since his PR has not reflected yet on the toolbar, probably also a PR4, 5 or 6. Unlike the other linking powers of others, at the number 3 spot on Google, detected backlinks are around 700+

The Numbers

• Indexed Pages: 17 (G), 9 (Y), 74 (M)
• Backlinks: 0 (G), 821 (Y), 189 (M), 0 (A)
• Alexa Traffic Rank: 439,486
• Google PR: 0

Elymar Apao’s isulong-seoph.net

As predicted in the earlier report, Jozzua, the SEO Comics author will climb the SERPs. Has a PR5 securing him a 4th spot.

The Numbers

• Indexed Pages: 82 (G), 68 (Y), 364 (M)
• Backlinks: 3 (G), 545 (Y), 848 (M), 0 (A)
• Alexa Traffic Rank: 215,980
• Google PR: 5

Jedi Dancel’s isulongseoph.ph

Also using power of his many websites secures him a fifth spot.

The Numbers

• Indexed Pages: 78 (G), 79 (Y), 426 (M)
• Backlinks: 13 (G), 516 (Y), 1,453 (M), 0 (A)
• Alexa Traffic Rank:
• Google PR: 4

J. Angelo Racoma’s go-ogle.com.ph/isulong-seoph

Not his first time on page 1, he goes in and out. Currently with a PR5, he places 6th.

The Numbers

• Indexed Pages: 29 (G), 19 (Y), 140 (M)
• Backlinks: 105 (G), 3,320 (Y), 3,286 (M), 153 (A)
• Alexa Traffic Rank: 892,548
• Google PR: 5

Eligio Tapiador Jr.’s blueseo.com

I did not really notice when Eligio came in, and I believe others may have not noticed either as eyes are still kept on the top 2 entries. Currently packing a power of about 2,000 backlinks, he slides into the 7th spot to wrap up this weeks top 7.

The Numbers

• Indexed Pages: 525 (G), 51 (Y), 152 (M)
• Backlinks: 105 (G), 1,830 (Y), 2,070 (M), 0 (A)
• Alexa Traffic Rank: 322,040
• Google PR: 4

Personal Predictions

It’s really hard to say. isulongseoph.offshoreoutsourcingphilippines.com who I know will still work hard to get to the top 3 positions that he once had. isulong.seoph.org with the power of many top blogs and forums could possibly slide in the top results as well. kotrapelo.com seems to be working hard. And all the rest in page 2 still seems to be in a striking distance to get top spots who are currently: blog4charity.org/isulong-seoph, noels-isulong-seoph.com, bicolbusinessdirectory.com/isulong-seoph, isulongseoph.com, isulong-seoph.info, isulong-seoph.org/, isulongseoph.joomlamoro.com, isulong-seophil.com, isulongseoph.com.ph and peksman.com. Not that everyone starts to come up with very strong websites in contention, it is hard to come up with any prediction. And I believe the winner of this competition is not only a question of who can be more creative in their link building strategies, but also the one that has many time to invest in the contest. Good luck to all Isulong SEOph competitors.

Google and Stop Words

It is common knowledge to many SEOs that there are what we call stop words. These words are words that are not given much weight by SEs. Examples of these are word like: a, an, the, or, if, is, are and a lot more. The most probably reason why SEs do this is to save a lot on processing time, get the gist of the webpage and saving a lot more time. If ever Google and other search engines need to read these stop words, it would probably be for checking patterns in liguistics to see a natural flow of words to detect spammy content and with further understanding of natural flow of words, Google bought Applied Semantics in 2003. But just how much Google knows? Will the stop words we recognized even if they are in another language?

Google and the Tagalog Language

Being a speaker of another language, I personal know Tagalog by heart which is the language of the Philippines. Tagalog was said to be first derived from the Indian Sanskrit language and since the Philippines was colonized by many countries in its history, the Tagalog language also has many Spanish words and every Filipino can understand and speak fairly well English which is totally embedded into the Philippine educational system and mixed with everyday conversational Tagalog. With the existence of Tagalog websites and more of them coming out, one advantage I see in Google understanding Tagalog over other languages is Tagalog has very similar sentence patterns with the English language. A subject and predicate that can have active and passive voice. You have past, present and future tenses. Although singular and plural are implemented slightly different, there is still a visible pattern that is similar to spoken English.

What is Isulong SEOPh anyway?

It is actually my first time to play around with a Tagalog website after joining the Isulong SEOPh contest. On the first day of the contest, Isulong SEOph was zero results in search engines. Although there were a few websites with the words Isulong and they were oftenly a Filipino Website. And Seoph totaly meant nothing in the English dictionary and also in the Tagalog dictionary. Isulong, when translated really means to advance, to progress, to move forward, to improve. SEOPh was nothing but SEO and Ph for Philippines.

Thus I decided to give Isulong SEOPh a meaning then promote viralness to it and promote it well. That gave rise to isulong-seoph.com, using the word isulong as how it normally meant as found in some websites that were often nationalistic, political-related Tagalog websites. This gave me a notion Google already knows what isulong is and to not be in conflict with it, I used the same meaning and invented a person named Seoph! Original plan is to make it viral enough that people will link to it naturally. Did it work? The viralness? Yes it did. In fact it is the highest traffic Isulong SEOph website I have. Did the people that visit the site take the bait? Nope, I guess not, inbound links were not increasing as fast as other sites were doing.

Teach Google a New Meaning

As more people blogged about their entries, posted forums and in all forms of link building, all of the entries were about an SEO Contest. Today, Isulong SEOph is really related to an SEO contest. Their occurence together and proximity of words just happens so often in� so many isulong seoph competitor’s websites and this has overpowered my futile attempts to give Isulong Seoph a new meaning. Thus isulong-seoph.com has never significantly done well in the serps for the keyphrases Isulong SEOPH. And isulongseoph.com has been doing better moving back and forth on page 2 and 3 in the SERPs and staying only brief moments on page 1. And with the new meaning of Isulong SEOPh, it has been more difficult to get inbound links going to isulong-seoph.com from websites about SEO. The strategy of isulong-seoph.com was a mistake but it can be overcome of course with linking power but I do not have that power at the moment to augment the SEO ranking strategy of isulong-seoph.com. Thus isulong-seoph.com is probably an Isulong SEOph Failure unless I can generate enough link juice which I doubt I can do enough to catch up with the rest of the competition.

How Much Tagalog does Google Know?

Below is a portion of a screenshot from isulong-seoph.com from the Pinoy OPM MP3 page. Take note of the Google Adsense on the page.

I am not familiar what from what language Iklan oleh was taken, but it obviously means Ads by. You can see Google’s efforts in trying to understand the language on isulong-seoph.com and serving appropriate contextual ads.

But after looking at the site statistics of isulong-seoph.com, I noticed the following inbound traffic search terms are paquiao larious, mga salawikain about dalaga, paquiao vs. larius and a lot more but one of them is:

chinobela/ koreanobela naging bahagi sa pilipinas

That term above means: Chinobela/Koreanobela became a part of the Philippines. These phrases come from my statistics software AWStats and these are actual search phrases people typed to get to the site. I tried it out in Google and this is what Google suggested:

Chinobelas and Koreanobelas are Chinese and Korean soap TV series in the Philippines that are hits in the country. Even if I typed in the search phrase chinobela/ koreanobela naging bahagi sa pilipinas, It is suggesting the word buhay instead of bahagi.

chinobela/ koreanobela naging bahagi sa pilipinas
means: Chinobela/Koreanobela became a part of the Philippines

chinobela/ koreanobela naging buhay sa pilipinas
means: Chinobela/Koreanobela became life in the Philippines

Could this just be an algorithm on spelling suggestion since bahagi and buhay both have start with “b”, has an “a” and “h” and in the Google database there seem to be a lot of occurences of buhay than bahagi in similar sentences? Or is Google trying to study linguistics and after seeing many sentence patterns in the Tagalog language a common sentence may be:

Chinobela/Koreanobela became a part of life in the Philippines

When translated is:

Chinobela/Koreanobela naging bahagi ng buhay sa Pilipinas.

And is Google trying to arrive to somewhat this sentence after it has based many search queries with a whole load of phrases that may have mentioned similar lines like this? What do you think?