Fixing WordPress Database Illegal Mix of Collation Error

I’ve been trying to fix the database error of the sites hosted by my VPS account and none of the steps I made is successful. This error is making every account’s error_log bigger everyday which resulted to server crashes.

One of the error says:

WordPress database error Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘like’ for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%Princess%’) OR (wp_posts.post_content LIKE ‘%Princess%’)) AND ((wp_posts.post_title LIKE ‘%Velasco%’) OR (wp_posts.post_content LIKE ‘%Velasco%’)) AND ((wp_posts.post_title LIKE ‘%â��%’) OR (wp_posts.post_content LIKE ‘%â��%’)) AND ((wp_posts.post_title LIKE ‘%Lonely%’) OR (wp_posts.post_content LIKE ‘%Lonely%’)) AND ((wp_posts.post_title LIKE ‘%Night%’) OR (wp_posts.post_content LIKE ‘%Night%’)) AND ((wp_posts.post_title LIKE ‘%mediafire%’) OR (wp_posts.post_content LIKE ‘%mediafire%’))) AND (wp_posts.post_password = ”) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’) AND (wp_posts.post_status = ‘publish’) ORDER BY wp_posts.post_date DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

There are several variations of the statement the main point is that there has been an illegal mix of collations between latin1.shwedish_ci and utf8_general_ci.

After examining the databases, I learned these things:

  1. The default collation on sql server is latin1_swedish while the existing database tables are using the utf8 collation which is based on my understanding is the default collation used by WordPress.

The World Against Senator Vicente “Tito” Sotto III

The report about several personalities filing complaint against Senator Tito Sotto III has been circulating the web. But the issue has shifted from RH Bill to Plagiarism.

First three US-based bloggers, Peter C. Engelman, Janice Formichella and Sarah Couture Pope, revealed that they intent to file complaints before a Senate Committee on Ethics and Privileges over the alleged plagiarism committed by the Senator during his speeches in the Senate of their works published on their own blogs.

Then, the daughter of the late Robert F. Kennedy, Kerry Kennedy wrote her letter revealing that she was offended when she learned that a Philippine Senator lifted a passage of his Father’s famous speech without proper citation and that she will be filing complaint before the same Senate Committee.

Now, it was reported that the academics will file their complaint on the same Senate Committee against the Senator on the same plagiarism issues. These people are:

  1. Dr. Sylvia Estrada Claudio –  Director, UP Center for Women’s Studies
  2. Dr. Antonio P. Contreras – former Dean of College of Liberal Arts, De La Salle University
  3. Dr. Lisandro Claudio – Department of Political Science, Ateneo De Manila University

If the Senator and his staffs who prepared his speeches were very careful, this actually won’t happen. But the problem is that Senator Sotto disregarded the writings of the bloggers just because they are bloggers not print media journalists.

Sources:

  1. Three US bloggers set to file plagiarism complaint vs Sen. Sotto, GMANetwork News
  2. Academics to join bloggers in Sotto plagiarism complaint in Senate, GMANetwork News
  3. Robert Kennedy’s daughter offended by Sotto’s theft of her dad’s speech; wants an apology, Raissa Robles

Incoming Visitors

  • Powered by Article Dashboard political science questions
  • Powered by Article Dashboard how long are television commercials
  • Powered by Article Dashboard politics issues

November 2012 Fuel Price Rollback

It has been reported that Petron and Chevron slashed gasoline (Premium and Unleaded) prices by 40 cents and Shell and other companies dropped gasoline  (Premium and Unleaded) prices by 35 cents effective 12AM this day.

The prices of Regular Gasoline and Diesel are unchanged but the price of kerosene was slashed by 20 cents

By the way, I am actually engaged in the gasoline tingi-tingi business. I bought stocks from the nearest shell station and sold it in tingi-tingi at a price of 1 Peso higher than the price at pump.

Now, with this recent rollback, I was thinking what to do since I still have 200 liters of premium gasoline bought at the previous price. My wife suggested retaining its price up to the last drop of the stock.

Post All Souls Day 2012 Earthquake

At 2AM today, Saturday November 3, 2012, we were awaken by weak but long earthquake that shook our home. My sister in San Agustin, Surigao del Sur texted me immediately after the quake telling me that they were shaken by a strong quake and their neighbor went out of their houses for safety

The center of this quake according to the “Seismological Observation and Earthquake Prediction Division” is located at 022 km North 58° East of Tandag, Surigao del Sur with the magnitude of 6.5 at the depth of 78 kilometers.

November 2012 Riyadh Gas Tanker Explosion Photo

At least 23 people were killed and more than a hundred others were injured when a fuel tanker crashed on a flyover in Riyadh, Saudi Arabia, and exploded, collapsing an industrial building, particularly, Zahid Tractor company’s showroom and warehouse, and destroying nearby cars on Thursday, November 1, 2012 at about 7AM.

Among those killed was Florentino Santiago, an OFW. Injured people, 10 of which are Filipinos, were brought to National Guard Hospital, the Habib Hospital, the Jazira Clinic and Shumaisi.

According to reports, the truck was taking the flyover or bridge on a junction in Khurays Road when the driver was surprised by the road accident losing control of his truck that eventually crashed on the railings of the bridge. As the fuel it transported leaked and spread out, explosion immediately followed.

The mentioned warehouse which has several storeys has been collapsed by the explosion. Most of the Filipino victims are working inside the compound.

 Explosion Photo

Ofel Leaves Philippines with Damages and Casualties

Ofel which is also called with its international name as Son-Tinh had made its landfall in Siargao on Wednesday in Siargao October 24, 2012, passed by the Panaon Island in Southern Leyte and made its way to Luzon bringing with her heavy rains. Now, she’s leaving the Philippine and is going to Vietnam, but she made havoc as she moves on the lands of the country.

As of today, it was reported that the number of casualties has reached 24 while the damages in Bicol region alone is estimated at more than 4 million pesos or more than 36 million pesos in Southern Luzon including Bicol. Three areas have been declared under the State of Calamities and many areas in Visayas and Luzon are still submerged in flood.

Among those reported dead are:

  1. Sophia Recto. She died of hypothermia
  2. Princess Najera from Barangay Ugong, San Juan Batangas. She was hit by debris.
  3. Rigel Saycon, 18, of Dumanjug, Cebu;. He died by drowning.
  4. Solustiano Fabellon, 77, of Concepcion, Romblon
  5. Olive Belyn Luna, 18, of Mansalay, Oriental Mindoro
  6. Roberto Manongsong, of Batangas City. He died by drowning.
  7. Jonnie Fronda Ocson
  8. Muhammad Kanape Guiamad
  9. Rolando Chavez
  10. Bonifacio Caran
  11. Jony Barrientos

Azana Salon and Spa in Brookfield Shooting

A 45-year old former marine entered Azana Salon and Spa in Brookfield on Sunday October 21, 2012 where his wife was working as beautician, gunned down seven women, killing three of them including his wife, before killing his own.

Background

Authorities said that they have responded to calls at the Houghton household of complaints related to animal and household abuse.

Neighbors also said that they frequently heard the couple arguing. They also knew that the couple are in the process of divorcing.

According to court records, Radcliffe Houghton, a 45-year old former marine allegedly terrorized his wife for years.

Last year, he was charged with disorderly conduct after authorities responded a 911 call which accused him of pointing a gun against his wife. The authorities’ respond resulted to a stand-off but ended peacefully. Later, the charge was dropped because police officers failed to show in court.

On October 4, 2012, Zina asked the assistance of police officers in getting her things from their house. Then when she drove her car into work at Azana Salon and Spa, she saw Radcliffe waiting in a car. Then while Zina was inside the spa, Radcliffe slashed her car’s tires. Zina and her co-workers saw what he did.

Radcliffe was later arrested and sent to Waukesha County Jail on misdemeanor allegations of criminal damage to property and disorderly conduct-domestic violence. He, however, bailed out paying $350.

On October 8, 2012, Zina got a four-year restraining order against her husband by telling the court that her husband had threatened to kill her if she ever left him. Zina revealed also in court that He threatened to throw acid on her face and burn her and her family with gas.

The restraining order ordered Radcliffe to surrender all his gun to the authorities.

A Day Before Up To The Day of Shooting

Two days after his estranged wife obtained a restraining order against him, Radcliffe Haughton bought a .40-caliber semiautomatic handgun from a private owner on Saturday, October 20, 2012.

The next day, Sunday, October 21, 2012 at around 11AM, he went inside the Azana Salon and Spa with the gun he bought. He pointed the gun the receptionist and shouted, “Everybody Down!”

Zina who was preparing a cup of coffee for her client, walked to the reception area and asked the Radcliffe, “what do you want?… Anything we can give you? Anything you want?”

Radcliffe pulled Zina through her arm away from the reception area and shouted again, “everybody down!” He took Zina around the wall where other women were and then started shooting. He then took the stair to the second floor, started a fire, and then shot himself to death.

The next day, he used this gun in shooting 7 women who are all licensed beautician of the spa, killing three of them including his wife, before killing himself.

The fatalities are:

  1. Zina Houghton (Radcliffe’s estranged wife, beautician of the spa)
  2. Cary Robuck ( 35 of Racine, a beautician of the spa)
  3. Maelyn Lind (38 of Oconomowoc, a beautician of the spa)

 References

  1. Wis. shooting brings call for new law on guns, Associate Press.
  2. Alleged spa shooter had history of threats against wife, Chicago Tribune
  3. Wisconsin police: After domestic violence arrest, suspect kills 3 — and himself, CNN
  4. Wife in Wisconsin spa shooting saved others’ lives, witness says, LA Times

Incoming Visitors

  • Powered by Article Dashboard tulsa television news
  • Powered by Article Dashboard animal art prints
  • Powered by Article Dashboard anime shower
  • the azana shooting records

Powered by CDN (Content Delivery / Distribution Network)

My expulsion from the Google Adsense program has really challenged me. Those who are following me through this blog since 2006 knew that Adsense is my main source of income in the sense that 80 percent of my total income is coming from Google Adsense and the remaining 20 percent is a combination of my income from other sources. In other words, now that I am kicked from Google Adsense, my overall income is 80 percent less than my previous income when I was still publishing Google Adsense ads.

So, I was forced to find a cheaper VPS for all my sites which are previously hosted in a dedicated server from “The Planet” webhost now owned by Softlayer. However, we all knew that a cheap VPS oftentimes equal to slow speed. And that is true to the current performance of all my sites hosted by my current webhost compared to time when they were still hosted by a dedicated server.

While hosted by the Softlayer’s dedicated server, this blog’s load time according to Pingdom Website Speed tool, is just more or less 2 seconds. It’s still slower compared to other websites that load in just a fraction of a second. However, previous load time is already fast compared to a 60 seconds load time as measured by Pingdom during the time when the site is already hosted by the current webhost.

You can tell the drop of this blog’s speed performance by simply considering the graph shown above.

Google Hate Slow Loading Sites

Having a slow loading site has brought headache to me. It’s bounce rate increased and its ranking performance from the SERP especially with Google’s has dropped.

These two are actually few of the effects if your blog or website is so slow to load. Its visitors will surely be disappointed upon learning that a site they are opening takes a hell of time loading. This feeling of disappointment is also true to a search engine like Google.

You see, the site’s loading speed is already added to the Google’s algorithm as one of the signal used in ranking websites or webpages on its search result pages. So, if you have a slow-loading website, then expect that Google will list your website at the last pages of its SERP. And who wants his website be listed at the last pages of the SERP?

Remedy… Speeding Up Your Website

So, the first thing to do to speed up your website which is hosted on a slow machine is to optimize your website. You can do the following:

  1. Make your CSS small.
  2. Use fewer scripts.
  3. Optimize the images used by your site.
  4. If you are using WordPress as your site’s engine, use few and important plugins.

But of course, these steps will not really speed up your site if your host machine is already slow. However, they can help your machine work smoothly as long as the other websites hosted by that machine are not giving more loads into it.

After that, you need to find a better CDN (Content Delivery / Distribution Network). CDN will speed up your blog since it will host the copy of your website into its own servers in different regions of the earth which will later be served to the visitors of your site.

A CDN makes sure that its server installed near the location of your visitor is the one that will serve the content of your site to your visitor. For example: If the visitor of your blog is coming from the Philippines, a server of a CDN installed in Hong Kong or Singapore is the one that will serve the content of your blog to that visitor from the Philippines. However, if the visitor of your blog is coming from Canada, then the CDN’s server installed in Canada will be the one to serve the content of your blog to that visitor in Canada. With this the loading of your blog in front of a certain visitor will be faster since the visitor is actually accessing a server near him.

So, now what’s next?

Choosing a CDN

Of course the next thing to do is to choose a CDN to use for your website. There are many CDN available today.

Actually, I really want to use the Amazon’s Cloud Network. But, just like what you already knew, I am currently in a budget. So, the best thing that I need to do is to try a free CDN first, and there is only one free CDN that I knew and it is the CloudFlare.

As of writing this post, I am currently testing the CloudFlare. I am still observing if CloudFlare is effective in speeding up this blog or not. I will be updating this blog with information about my observations regarding my use of CloudFlare services with this blog.

Incoming Visitors

  • Powered by Article Dashboard western regional network
  • legacy assured delivery prize notice
  • Powered by Article Dashboard western regional

Philippines Hero Dog, Kabang, in the US for Facial Repair

Kabang, a dog from the Philippines who became hero when she saved two children on the road accident, is currently at the University of California for a special surgery that will attempt to repair her face which is disfigured while saving the children. She is brought to the US by her vet in the Philippines, Anton Lim, and through the initiative of Karen Kenngott, a nurse, who raised funds online.

The fundraising campaign collected $20,000 from various donors and is being used to finance Kabang’s operation.

Kabang has underwent already an hour-long examination by the vets from the  Davis Veterinary Medical Teaching Hospital as preparations for the operation.

According to the Associate Press report, Kabang will undergo two operations: The first operation will focus on her dental function and the Second will treat her wounds on the face. There’s no plan, however, on replacing her upper jaw with a prosthetic.

Kabang became popular after saving two young girls, the daughter and niece of its owner, by leaping into the speeding motorcycle which is about to hit the kids. The incident had removed the whole upper jaw of the dog.

Incoming Visitors

  • kabang
  • philippines dog hero
  • the hero dog kabang

October 26, 2012 Declared Regular Holiday for Muslims’ Fiest Eidul Adha

President Benigno S. Aquino III signed Proclamation 488 on October 9, 2012 declaring October 26, 2012 as regular holiday in observance of the Eidul Adha.

Eidul Adha is declared Regular Holiday through the Republic Act No. 9849 signed into law by former President Gloria Macapagal Arroyo in 2009. But the date of it is movable and it is the National Commission on Muslim Filipinos (NCMF) that recommends the exact date of the holiday based on the declaration made by the Saudi government regarding the said feast.

Incoming Visitors

  • october 26 2012 declared holiday
  • Movie yousjiz com
  • www video yousjiz com
  • holiday on October 26 for muslims
  • october 26 2012 declared as Muslim holiday
  • october 26 2012 Eidul Adha
  • proclamation 488
  • special holiday october 26 2012