Impact of Ranking by Deleting Posts by Mistake in WordPress

Recently we were cleaning up our blog – TechBuzz . TechBuzz was started in 2007 and has been a pet project since then.

In between, the blog was filled up with – not so important – content, which was irrelevant now (old or technology was outdated), written just for the sake of it and a few were – rants :).

Content Clean Up

I decided to ‘clean’ up the content and keep, as much as possible, relevant and updated information on the blog.

What I did

This is what I did :

  1. Went through old posts which I felt were unnecessary. This was really a tough task and boring too. (Haven’t completed this task, and will gradually do it, as and when I find time)
  2. Logged into Google Analytics and made a list of all those posts, which have got less than 10 page-views and exported them to an excel-sheet.
  3. Logged into TechBuzz as admin and deleted the posts that were in the excel-sheet.

What Went Wrong

This is where few things went wrong. While deleting, I somehow managed to get a few good performing posts deleted (can add myself to Indian Superheros list here).  Some of them which were deleted by mistake are :

Resuming indexing services in windows,  Solve WhatsApp stuck at initializing problem and if you have iPhone – use multiple instances of WhatsApp, play a prank on your friends by flipping their windows screen, find and trace vehicle numbers and details.

If teamviewer commercial use is suspected then you have an option to reinstall teamviewer after trial has expired and you can get your teamviewer partners password.

These changes were made last week – somewhere between March 2nd, 2017 and March 4th, 2017. I was too involved in learning about Home Automaton in India at Internet of Everything Event.

Impact of Deleting WordPress Posts by Mistake

Cleaning up unnecessary post will have a long term, hopefully positive, effect. I hope for positive results because, we are making our blog more relevant, and ‘present’ in terms of data.

However, deleting posts that were performing well, has resulted in loss of traffic. Some of the posts mentioned above were deindexed in a matter of 2 –  3 days after deleting them (by mistake).

Lesson to be learnt here is that, we need to be extra cautious while deleting the data, and ensure we do not scrap good posts.

Way Forward

For time being, I’ve restored all the posts. As I was unsure, which posts had brought the traffic down, first off, I restored all the posts.

Now, I have a fair idea, which were the posts that were pulled down, due to which traffic went down (Google Analytics helped me get this data by doing a simple comparison with relative period last week), I’m hoping that these posts will be re-indexed as soon as I can hope.

I’ll make a list of posts that need to be deleted, and will delete each one of them gradually. Though it’s a time consuming process, I’m sure that it’s well worth the time spent.


Do share your experiences, if any in similar conditions and how you were able to solve the issue.

Home Automation in India

Home Automation

Home Automation, is still fairly a new concept in India, mainly because of less awareness about it in general public, and also because of it’s high pricing.

Those who experiment with it are mostly techies, and / or the not so ‘aam janta’ from the upper middle class. However, this is set to change in the coming days with increasing competition in this niche, which will force price competition and the ‘aam janta’ will benefit from it.

IoTShow.in – IOT event in Bangalore(2017)

IoT and Home Automation will change your lives, by making our lives easier, more convenient, and more comfortable.

So far, hadn’t felt the need for Home Automation (as I live in a rented space), and hence it really doesn’t make sense for me to invest in it, and hence hadn’t looked into available options. However, when I met Sanath and his co-founder partner (can’t recall his name), at IoT event in Bangalore (02 – 04 March, 2017), I was really impressed by their Home Automation products.

I plan to implement some of Sanaths products at home, and review them.

Home Automation in India

In coming days, I’ll review other home automation products currently available in market and hopefully help buyers make informed choice (it’s quite an investment and you’d not want to make a wrong choice 🙂 ).

Stay tuned to this space (book mark this page for future reference).

Feel free to drop a message if you are looking for Home Automation solutions in India, and I’ll be able to help you with info I’ve gathered over time.

Save webpage to PDF in Google Chrome

Sometimes, I have to save webpages in order to retrieve information or for viewing at a later date. However, the webpages get saved in .html format which is not the best format to view later. A PDF option is better because it is easier to use. Learn how to save webpage to PDF in Google Chrome.

webpage to pdf

Save webpage to PDF in Google Chrome – How To

Open the webpage you want to save. Let it load completely.

Once the webpage has finished loading, press ctrl+p (command+p in Mac).

The print options menu will appear on your screen. You can setup your pdf according to your preferred choice for saving. (destination, pages etc)

Simplify your page options via the Simplify page options tab. (You can choose to remove all distractions from your webpage)

Click on save and the entire webpage will be saved as a pdf.

That’s it! That is how your save the webpage from Google Chrome (or any other web browser) in PDF format. Use a pdf reader software such as Foxit or Adobe reader for viewing your pdf files.

Safari runs slow on iOS10 – Fix

Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.contrib.serde2.RegexSerDe

java.lang.RuntimeException: Error in configuring object
at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:93)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:64)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:431)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:371)
at org.apache.hadoop.mapred.Child$4.run(Child.java:259)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1059)
at org.apache.hadoop.mapred.Child.main(Child.java:253)

Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:88)
… 9 more

Caused by: java.lang.RuntimeException: Error in configuring object
at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:93)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:64)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
at org.apache.hadoop.mapred.MapRunner.configure(MapRunner.java:34)
… 14 more

Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:88)
… 17 more

Caused by: java.lang.RuntimeException: Map operator initialization failed
at org.apache.hadoop.hive.ql.exec.ExecMapper.configure(ExecMapper.java:121)
… 22 more

Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassNotFoundException: org.apache.hadoop.hive.contrib.serde2.RegexSerDe
at org.apache.hadoop.hive.ql.exec.MapOperator.setChildren(MapOperator.java:406)
at org.apache.hadoop.hive.ql.exec.ExecMapper.configure(ExecMapper.java:90)
… 22 more

Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.contrib.serde2.RegexSerDe
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:247)
at org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:819)
at org.apache.hadoop.hive.ql.exec.MapOperator.initObjectInspector(MapOperator.java:233)
at org.apache.hadoop.hive.ql.exec.MapOperator.setChildren(MapOperator.java:366)
… 23 more

 

1> Check if hive-contrib jar is in the hive-shell’s classpath –> http://www.techbuzz.in/how-to-check-the-list-of-jars-included-in-hive-classpath.php

2> If it’s not in the class path then add the jar to the classpath –> add jar <relative-classpath or absolute-classpath>/hive-contrib-0.8.1.jar

This will solve your problem.

How to Check the List of Jars Included in Hive ClassPath

At times you’ll need to be aware of all the jars that are available in Hive Classpath. The Query to get a list of all jars that are included in the ClassPath of Hive, run the following Query:

hive> list jars;

This will list all the jars, the ones that are added explicitly by you, and the ones that are available by default.

The output will look like:

/usr/local/…..*.jar

/usr/local/…..*.jar

file:/usr/local/…..*.jar

/usr/local/…..*.jar

The jar location with file: prefix is the one which was available in the ClassPath by default. The others were added explicitly by users using the “add jar <absolute / relative class path>

“Return Code 1 from org.apache.hadoop.hive.ql.exec.DDLTask” Error

While trying to execute a Hive query you can end up with the following error:

return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

Try re-running the same query, and if that doesn’t work, then Start Hadoop if it’s not running or restart Hadoop if it’s already up and if Hadoop’s running in cluster mode, check if DataNode is running.

This should solve the problem.

reCaptcha And Verification Image Problems

Website of all kind use reCaptchas due to the increase of spam, bots, and other automated processes that come their way. Sites such as forums, blogs, online games, and even regular websites are often target for spammers who try to utilize automated programs for some advantage or gain. This is why reCaptchas and verification images have become increasingly popular because they make it near impossible for anything automated to get through.

Unfortunately reCaptchas and verification images can also block people as well. If you have a problem with your computer then the reCaptchas may not appear and you could be prevented from entering the site, or going any further. This problem can be infuriating because you often aren’t told there is a captcha that you need to fill out!

So if you have finally discovered that there is a hidden or blocked reCaptcha then the first thing you need to do is make sure it is not something in your browser.

If you have Firefox the try switching over to Internet Explorer, and vice versa to see if the verification image works on the other. If it does, then you can assume that the problem is due to an add-on of some sorts, more than likely a pop up blocker that has its filters set incorrectly. Once that add-on is disabled then your reCaptcha should work perfectly after you refresh the page.

Unfortunately the above solution doesn’t always work however there is another simple thing that could be the culprit here: your firewall/anti-virus system. Some of the settings can be set so that they blog entirely too much, or they could have reverted back to the original settings through a glitch. Simply try turning the firewall/antivirus off for a few minutes, refreshing the page, and seeing if this works.

For those of you who have not had any luck with the first two solutions then perhaps this last one will remedy your problem.

The problem might be because you need an update for your computer so first try installing the latest Adobe Flashplayer update here: http://get.adobe.com/flashplayer/ also try installing the latest Java update here: http://java.com/en/ Once those are both updated, refresh your page and it should work now.

IF ALL ELSE FAILS and the reCaptcha is STILL not working, then it is probably something on their side however this is very rare. If you cannot bypass the captcha then either have a friend or relative try on their computer at home, or wait for about an hour or two and try it yourself again.

Slow PC? Fragmentation Could Be a Reason

If you are a daily user of computers then a slow running computer is the last thing you want during your day to day activity. There could be many reasons for your PC slowing down. One of them can be fragmentation of disks. Fragmentation occurs when your files are scattered all over your disk in no particular format.

What exactly is Fragmentation?

To keep it simple, your hard disk consists of blocks of memory. Whatever you store in your hard disk gets stored in these blocks according to the size of the object being stored. Different files occupy different number of these memory blocks. When you use a computer, you may not need a file tomorrow that you need today. So you delete the unwanted files.

When you delete these unwanted files, the memory blocks occupied by them is freed and remain empty. Thus as you go on adding and deleting files the newly added files will occupy new blocks of memory and those of the deleted files remain empty. Once all the new memory blocks are occupied by new files, there are no more new blocks for new files to get stored. Thus these files now look for empty blocks left by the deleted files.

This is a time consuming process as all the free blocks many not be large enough to accommodate this new file. This is called fragmentation. You might have enough memory to store many more files in your hard disk but since they are scattered, those files might not be able to get stored or might take a lot of time to find a space large enough for it to get stored.

How do we get rid of fragmentation?

A solution to fragmentation is defragmentation. Defragmentation means to congregate free and occupied blocks of memory separately. When you defragment your disk the blocks of memory occupied by files are grouped together and those that are free are grouped separately in the memory. Now the new files can get easily get stored in the memory without taking much time of yours.

For a normal user it is advisable to perform defragmentation once in a month. When you experience problems while saving a word document or an image file, fragmentation might have occurred and it means that you need to check for fragmented segments in your memory.

How do we perform defragmentation?

To perform defragmentation is not a task at all. You can easily do it even if you are not a computer expert. A lot of defragmentation tools are available within the operating system you use. Windows comes with a built in Disk Defragmenter. If you need advanced functionality, you can also use Auslogics Disk Defrag or O&O, both of which can be downloaded free of cost.

When you use Disk Defragmenter for Windows, you just have to follow some simple steps. You’ll find the application in your start menu’s programs. Just start the application and then you’ll find the option to analyze your disk and see which of the files are already defragmented and which of them need defragmentation. Here is a step by step tutorial to defragment your hard drive using the built in defragmenter.

Extra Software Could Be the Reason behind Your Slow PC

It often gets annoying when you are working on something important and your PC slows down. There could be many factors behind this. One of the reasons for your PC slowing down could be installation of extra software. Software requires some amount of memory to get started. Thus, the more number of software you install on your PC the more memory they need.

For an individual who uses computer for most of his jobs might certainly require separate software for each job. This does not imply that he needs all the programs installed by the software. While installing software one must carefully go through the installation process and see which programs are being installed along with the software.

So what is important and what is not?

Most of the software you use, provide you with three options during installation –

  1. To install the complete software
  2. To install the most commonly used programs in the software
  3. To choose the programs you want to install.

It is advisable to choose the third option if you use advanced software as you would have a better idea of which programs you want to install. If you are a new user, the second choice is better as that option installs programs that are commonly needed by new users. The first option is advisable only if you want to study the software or know its complete usage.

Also, software comes with additional programs that you might not need at all. For example, when you download a YouTube downloader, it comes with additional anti-virus software. You do not need this software if you are a typical PC user as you would have advanced anti-virus software already installed on your PC. It is important to take care to check what is getting downloaded along with the software and if it is something you do not need, avoid them.

What if we need all the software that is installed?

There might be times when your PC gets too slow because of installing too much software but you need all of them. A solution to this problem is to increase your RAM memory. Whenever you start any software, it gets loaded onto your RAM memory. Thus, the more software you have, the more RAM memory you need.

You can check the specifications of software installed on your PC and find out the maximum amount of RAM required for the software to run smoothly. If you do not have enough RAM memory for software to run, your PC tends to run slow. Even if you manage to start the software, you cannot use any other application while running that software. If you try to do so, neither of your applications would work and your PC may hang.

For example, Oracle database software requires 1 MB of RAM to get started while a Visual Studio can do with 512 MB. This means that your PC needs minimum 1MB RAM if you are using both of these software. If you try to run Oracle using a 512 MB RAM it won’t work. Anti-virus software that uses powerful scanning tools also requires more RAM memory to scan your PC completely and effectively.

RIP Megaupload

As the United States flails about with their banhammer trying desperately to eradicate the net of all traces of piracy, another casualty has been added to the list and this time it is a major blow to pirateers. Megaupload, one of the world’s largest file sharing sites, has been taken down by the Department of Justice on Thursday January 19, 2012 thanks to an indictment by the Justice Department.

This indictment states that Megaupload Limited is part of a group of individuals and corporations that have cost copyright holders over $500 million in lost revenue. Now those involved with Megaupload are being arrested and face extensive charges. These charges include: 20 years max prison sentence for racketeering, 5 years prison for copyright infringement conspiracy, 20 years in prison for money laundering, and another 5 years on other related charges.

Megaupload is one….was one of the most popular media uploading sites in the world and it gained a ton of exposure thanks to several celebrities who endorsed it. Some celebrities include Kim Kardashian, Swizz Beatz, Kanye West, and more. No news yet on whether or not the celebrities who endorsed the site will face any legal charges however the executives at Megaupload are being rounded up by the authorities.

Kim Schmitz (aka Kim Tim Jim Vestor, or Kim Dotcom) was Megaupload’s founder was arrested for the above charges as well as several other executives at Megaupload. Despite prior felony charges on a “conspiracy” he continues to deny any copyright infringement involvement.

This assault against Megaupload and its executives began just one day after the massive internet protest on the 18th against SOPA and PIPA. The protest was spearheaded by Wikipedia and involved several other large sites (Google and Craigslist) in an attempt to get internet users to contact the United States congress and voice their opinion. Could be just a coincidence that the Justice Department staged this massive takedown of Megaupload right after the blackout of Wikipedia but that’s doubtful.

As you may expect, there are thousands upon thousands of incredibly angry and outraged Megaupload users that are taking the initiative. The infamous hacking group called Anonymous has taken up the voice of the general public in an attempt to fight back at the United States Justice Department. Anonymous has used their hacking skillz to take down sites that belong both to the United States government and to the Recording Industry. Some sites include Justice.gov, NPAA.org, RIAA.com, UniversalMusic.com, and more.

Anonymous stated via a Twitter account that they are staging their largest attack yet in response to the United States current actions. Expect to see more and more sites being taken down by Anonymous as they take up the fight against SOPA and PIPA in their own way.