Categories
Tips

Remove Microsoft Office 2008/2011 Completely from Mac

If you are feeling your Mac is running “slow” AND if you have Microsoft Office installed, then you can try removing Microsoft Office. I removed it (Microsoft Office) and my Mac got all its speed back. To confirm this, my other friends also noticed considerable speed improvement for Mac, when they removed Microsoft office.

Microsoft Office 2008

For Microsoft Office 2008, Microsoft provides a small tool called “Remove Office” under /Applications/Microsoft Office 2008/Additional Tools. At first, it may look like it does remove office completely as its name suggest but that is not true. You need to follow official 2008 uninstallation instructions posted by Microsoft here.

Microsoft Office 2011

ADVERTISEMENT

For Office 2011, Microsoft doesn’t provide any “Remove Office” tools! You need to follow official 2011 uninstallation instructions posted by Microsoft here. I know instructions are quite lengthy and cumbersome for average users but that only official way.

(Unofficial) Uninstaller for Microsoft office 2011

Unofficially, you can use a third party tool I found here – http://www.fixkb.com/downloads?did=9 I found it after my job was done so I could not test it. But it seem to work as you can see from comments on this post.

Alternatives to Microsoft Office…

ADVERTISEMENT

For Mac, there are many alternatives. I found all of them very disappointing to be honest.

Its not speed-issue only about Microsoft Office.They have many more issues so no votes for Microsoft Office anyway!

For word files, I use Mac’s “Preview” application as default application to “open” documents. 99% of the time I need to “read” only word files I come across.

If I need to “write”, I prefer Google Docs. In cases where I need to “edit” existing word files, I either upload them on Google Docs or open with them on LibreOffice. I use LibreOffice for opening Powerpoint as well as Excel files also.

Sometimes LibreOffice breaks formatting but this occasional breaking of formatting is better than using a slow Mac always! 🙂

Categories
Tips

How to reset your BlackBerry ID password [Direct Link]

Are you trying to login to your BlackBerry ID from your smartphone and getting a wrong username/password error again and again? Then it’s always a good idea to reset you password after 2 or 3 unsuccessful attempts or else your ID will be blocked. We will tell you how you can reset your Blackberry ID password in just few steps.

  1. Click on this link for your PC or Phone’s browser. This will open the password reset page. Alternatively you can click “Forget Password” link given on the login page.
  2. Enter your username i.e. your BlackBerry ID E-mail and then enter the image verification code. After that click submit.
  3. Now check your E-mail mailbox by logging in to your E-mail account and open the password reset mail. Don’t forget to check your spam/junk mails if it’s not there in your inbox.
  4. Click on the “Password Reset Link” given in that E-Mail after the text “To change your BlackBerry ID password, simply visit”. This will open a new page. Enter your new password twice on that page and click Submit.
  5. Now try logging in with your new password. In case you’re getting an error please drop a comment below.
(via BB Help Blog)

For more tech tips and tricks, subscribe to our E-mail feeds. Thank you for reading. 🙂

 

Categories
Tutorial

Using grep to removing comments, newlines/whitespace from config files

As configuration files are often full with comments and blank lines reading them inside shell become tedious! Sometimes you just want to quickly recap active configuration option only.

Mostly, comments starts with “#“(hash) or “;” (semicolon).

Below is a command I often use while debugging various configuration files.

For files having comment starting with “;” e.g. php.ini

egrep -v "^([[:space:]]?$|;)" /path/to/file

For files having comment starting with “#” e.g. my.cnf

egrep -v "^([[:space:]]?$|#)" /path/to/file

For lazy bumps… Following can take care of both of above! 

egrep -v "^([[:space:]]?$|;|#)" /path/to/file

You may create a local alias for above command! 😉

Just in case you want to save output in a file… just add " > newfilename" to above commands. Passing original filename may not work (and it will be risky too!)

Categories
Tutorial

Change WordPress Permalink Structure With IIS 6 Server

WordPress Permalink structure is important with respect to the Search Engine Optimization (SEO). I observed that most of the WordPress blogs have a Permalink Structure which looks like /index.php/%postname%/. This post will help you to change your permalink structure using the Microsoft IIS 6 server.

  1. Create a “php” file, say ‘404_wp.php’, paste the below code and upload it to your wordpress root folder (i.e., in same folder/directory where “wp-config.php” file is located.
  2. <?php
    // Default file for WordPress site, generally "index.php"
    $wpdefault = 'index.php';
    // The name of this file.
    $tempfile = '404_wp.php';
    $_SERVER['SCRIPT_FILENAME'] = str_replace($tempfile, $wpdefault, $_SERVER['SCRIPT_FILENAME']);
    $_SERVER['ORIG_PATH_INFO'] = str_replace($tempfile, $wpdefault, $_SERVER['ORIG_PATH_INFO']);
    $_SERVER['SCRIPT_NAME'] = str_replace($tempfile, $wpdefault, $_SERVER['SCRIPT_NAME']);
    $_SERVER['PHP_SELF'] = str_replace($tempfile, $wpdefault, $_SERVER['PHP_SELF']);
    $_SERVER['PATH_INFO'] = false;
    $querystr =& $_SERVER['QUERY_STRING']; $requesturl =& $_SERVER['REQUEST_URI'];
    $position = strrpos($querystr, '://');
    $position = strpos($querystr, '/', $position + 4);
    $_SERVER['URL'] = $requesturl = substr($querystr, $position);
    $querystr = trim(stristr($requesturl, '?'), '?');
    // Required for WordPress 2.8+
    $_SERVER['HTTP_X_ORIGINAL_URL'] = $requesturl;
    // Fix GET vars
    foreach ( $_GET as $var => $val ) {
    if ( substr($var, 0, 3) == '404') {
    if ( strstr($var, '?') ) {
    $nv = substr($var, strpos($var, '?') + 1);
    $_GET[$nv] = $val;
    }
    unset($_GET[$var]);
    }
    break;
    include($wpdefault);
    ?>

  3. Download and Install Internet Information Services (IIS) 6.0 Manager for Windows XP from Microsoft Site. Alternatively, you can install this from your Windows XP Installation CD.
    Download Link
  4. Go to your Windows Control Panel -> Administrative Tools and open Internet Information Services (IIS6) Manager
  5. Right click Internet Information Services and select Connect
  6. “Connect to Computer” dialog box will open, enter your IIS 6 Server IP Address, and Login Credentials
    (In case, you can’t find the IP Address, you can open Command Prompt from Start Menu and ping your site to find IP Address) i.e. ping wpveda.com

  7. Click OK, so as to connect to your server. The IIS manager will open as shown below.
  8. On left-hand side navigation, click on [+] before Your Server’s IP Address to expand
  9. Click on [+] to expand Web Sites
  10. Right click the name of website on which pretty permalinks need to be enable, and select Properties, which would open the Properties dialog box.
  11. Select Custom Error tabs, and find 404 from the grid.
  12. Click Edit button, you will be greeted by another dialog box. Select “URL” from Message Type Drop-Down, and for URL field, write relative path to “404_wp.php” file, that you have created and uploaded on your server (in step 1) and click OK.
  13. You can see the new “404” URL in Custom-Error Tab Grid. Close the dialog-box.
  14. Right click the web-site that you have connected to and select Disconnect and then close the Internet Information Services (IIS6) Manager
  15. Login to your WordPress Admin-Panel and change your permalink structure to  /%postname%/ or any other structure as shown below.

This is how you can easily change your permalink structure using the Microsoft IIS server for a good SEO for your blog. Do write your feedback through your comments.

Categories
Tips

Repair and optimize WordPress database

It is always good practice to optimize your blog’s database to improve blog’s performance. Many are not aware about WordPress’s built-in database repair and optimize functionality, as it is not available in admin back-end.

You can check this by visiting http://yourdomain.com/wp-admin/maint/repair.php (replace http://yourdomain.com/ with your actual blog/site url ).

Below is a step by step guide on how to optimize WordPress database :

  1. First login to admin section of WordPress blog by visiting http://yourdomain.com/wp-login.php .
  2. Then go to http://yourdomain.com/wp-admin/maint/repair.php .You can see screen as show below. It ask you to add a line of code to WordPress’s wp-config.php file.
  3. Add below code to your WordPress wp-config.php file and reload/refresh page.
  4. define('WP_ALLOW_REPAIR', true);


  5. After refreshing you can see page with options to ‘Repair Database’ and to ‘Repair and Optimize Database’. Just click on one of the option.
  6. If you click on ‘Repair Database’ button,  WordPress can automatically look for some common database problems and repair them. Internally it executes two sql queries on each WordPress database tables in loop and these queries are CHECK TABLE  table_name and REPAIR TABLE  table_name .
  7. If you click on ‘Repair and Optimize Database’ button, WordPress can also attempt to optimize the database. This improves performance in some situations. Repairing and optimizing the database can take a long time and the database will be locked while optimizing. Internally it executes four sql queries along with above two queries on each WordPress database tables in loop and other two queries are ANALYZE TABLE  table_name and OPTIMIZE TABLE  table_name .

Hope this will improve your WordPress blog’s performance. Drop in your comments!

(P.S. : Please take backup of your WordPress database before making any action on database)

Categories
Tips

[Solved] Homepage Redirecting to The Latest Page Issue

There is an issue with Redirection plugin for wordpress. Redirection plugin is used to create redirect rules without any technical knowledge.

About the issue…

Whenever you create a latest page inside wordpress, all visitors to your homepage get redirected to the newly created page. This used to happen before also, but seems like the issue has become severe after wordpress 3.0 release.

There may be some bug in the plugin, which results in a rule being added to its (plugin) database as you can see in screenshot below. You can see following screen by going to “WordPress Dashboard >> Tools >> Redirection” menu and then clicking on “Modified posts” group.

As you might have noticed, there is rule with URL ‘/’ (slash) being added under “Modified posts” module in Redirection Plugin. This rule is responsible for homepage redirection.

Temporary Solution

  1. Just select all rules made for ‘/’ (slash) as highlighted in below screenshot. Yes, there can be more than 1 rule for ‘/’ (slash) i.e. homepage redirection.
  2. Click on “Delete” option. You will be asked for confirmation. Just click“Yes” and you are done!

Now, this will solve problem only temporarily. Next time you create a new page, chances are this issue will surface again. So if you edit/create pages quite frequently, you may like to go for permanent solution listed below.

Permanent Solution

  1. On Redirection Plugins’ Settings page, click on “Modules” links.
  2. You will see 3 modules as shown in above screenshot. Click on “WordPress” module.
  3. On next screen you will see 2 groups – “Redirection” and “Modified Posts”. Click on “edit group” link, next to the “Modified Posts” group. (see screenshot)
  4. When you will click on “edit group” link, you will see few more options. Uncheck option saying, “Disabling a group will disable all items contained within it” (see screenshot)
  5. Just click Save button and you will no longer face this issue again.

This solution actually disables a feature of Redirection Plugin, which is being used by many of us unknowingly.

Every-time we manually edit slug of a published wordpress post or page, Redirection plugin create necessary rules inside “Modified Posts” group.

Summary

This issue is already open as a bug in Redirection plugin’s bug-tracker. Hopefully, this will be solved in near future.

By the way, those weird redirections rules don’t get added all the time. But if they do, you can use solutions mentioned above. 🙂

Categories
Tips

Details about Orkut’s javasript:void(0), temporarily block and other errors

I get a lot of questions asking about javasript:void(0), temporarily block and few related error on Orkut. Even though these error are old now, some users still gets confused. There is no quick solution to this. But you might be interesting in knowing reasons and workaround for it.

Possible reasons:

  1. Sending large number of scraps in short duration using some scrapbook flooder
  2. Deleting many scraps, pending friend requests, messages etc using scripts
  3. Use of automated login sites like powerscrap.com
  4. Using ‘Scrap All’ script

In short, you might have knowingly or unknowingly used some third-party service, tool, script which increased load on Orkut’s server. So basically to balance load on their server, your account gets temporarily blocked.

ADVERTISEMENT

While in blocked state, you may see any of the following error messages…

  1. javasript:void(0);
  2. You are temporarily unable to perform this action. Try again later.
  3. We’re sorry…but your query looks similar to automated requests
  4. Page not found.

Workaround…

As we said earlier, there is no quick solution for this. Once you get “banned”, you will be disallowed from performing many actions for 8-10 hours.

ADVERTISEMENT

Best way to avoid such banning, is NOT to use third party automation scripts at all. If you can not avoid them, then try to minimize your usage.

It may happen that you haven’t used any script knowingly. In that case, please

  1. Change password for your Orkut account
  2. If you still get banned and if you use same PC to access Orkut, scan it for malwares, viruses, etc.

There is nothing to worry about such bans. Normally, your account can survive from multiple bans.

But do not abuse Orkut’s service too much or you may risk loosing your Orkut account permanently.

Useful Orkut Help Pages

Related: Adding of Comments Temporarily Disabled on Orkut [FAQ]