Sunday, June 7, 2009

WORDPRESS DATABASE ERROR MYSQL SERVER HAS GONE AWAY FOR QUERY IN WORDPRESS 2.7


ico_wp_databaseRecently i optimize my Wordpress for performance with many tweaks like deleting useless tables from database. Installed WP-Super cache, etc.
I was checking the error_log file in my Filemanager i was shocked due to its size, it was 14MB large !. I download it and opened it, all the errors were related to Database.
Almost all lines were starting with
“WordPress database error MySQL server has gone away for query…..”
and few were like this
“WordPress database error Lost connection to MySQL server during query for query…..”

As per the Error statement, the error clearly notifies that the connection between the Wordpress and MySQL database was not proper. I just searched Google and seen many results, then i got the idea that its a General problem for many wordpress users.

Rob given a solution for this problem with few patched files to be replaced, You can read his article “Workaround for WordPress database error“. The article give detailed information about this problem. He also given files to be replaced to solve this problem.

According to him, This error is cause due to improper coordination between database and Wordpress PHP commands.

According to Rob ,

When someone tries to view one of your Wordpress web pages, the PHP code first opens a connection to the MySQL server. Subsequent queries to the MySQL server rely on the connection remaining open, and do not re-open the connection. If the connection to the server happened to have shut down before a query is made, then Wordpress will display this error.

So for that you need to change the value of “wait_timeout” variable, either ask your hosting admin to do it for your else you can do it by your self by tweaking your wordpress file named wp-db.php.

Rob given replacement files for Wordpress upto version 2.6.1 but recently Wordpress 2.7 is released so how to do the patch for Wordpress 2.7 ?

Here i am including the file to be replaced by original “wp-db.php” file for Wordpress 2.7.

Original wp-db.php
Workaround wp-db.php

Make sure you Backup your database and other files.

In above Workaround file, i just added

$this->query("set session wait_timeout=600");

in line number 334 in original file.

So do Check your Error log file today, else this may cause increase in your site loading time.

MY NEW GADGET SONY ERICSSON K810I - CYBERSHOT


SE K810iJust few days ago i brought the new Sony Ericsson k810i - Cybershot mobile handset.As a Cybershot its camera is amazing. It has 3.2 Megapixel camera with Autofocus and XENON Flash. My prevoius handset was Nokia N72, which was 2Megapixel with LED flash and without Autofocus.

Overall the camera is superb, Its Autofocus takes bit time to focus but its very accurate and gives superb and clear clicks.Now i am sharing Few of the most amazing features of my SE K810i.

PROS

of Sony Ericsson k810i
1. Autofocus - Good, It was absent in my Nokia N72.
2. Xenon Flash - Bright picks at night.
3. Bestpick™ - can take 9 High quality images in just 1 second !!
4. Dedicated camera keys, including keys from changing the various settings of camera such as turning ON/OFF the flash, changing the scenes.
5. Amazing sound - Though its not walkman series handset, its sound quality is much better, and louder.
6. Faster menus and navigation
7. Specious keyboard - for Very high speed and accurate SMS typing., :D
8. Radio sound is amazing and louder (When compared to Nokia devices)
9. Supports Stereo Bluetooth audio streaming.
10. i will add more here…..

CONS

of Sony Ericsson k810i
Now after many pros few cons about K810i
1. Battery seems weaker after taking too many picks using Xenon flash.
2. Joystick may cause problem after few years of use.
3. Only 1000 contacts can be stored :(
4. Shooting video quality is VERY VERY Poor compared to other Nokia devices. (XVGA)
5. After sending SMS, when it gives the SMS delivery report or shows the cost of SMS you must press OK to remove that notification from screen, until and unless you remove it, your handset will NOT receive any new SMS !!!
6. Dont want to write more here but if got something will surely add……

with handset i got one 128MB SanDisk Memory stick which was inside the mobile handset and another Original 2GB SONY Memory stick M2 with handset.Currently i am using SanDisk card for contacts backup.

Sony Ericsson k810i keys

NERO ALTERNATIVE - CDBURNERXP - FREEWARE - 3MB SOFTWARE


Burning CD or DVDNero burning ROM is widely used and one of the most popular disk burning software. Nero’s latest release i.e. Nero 9 is huge software (380MB Full , 50MB Lite version)with lots of addons which we never use. Recently i came across a software which works same as Nero burning rom but its Free and just 3MB in size !!..

CDBurnerXP is a Free utility i.e. Freeware. CDBurnerXP is amazingalternative for paid burning softwares like Nero, Alcohol, etc. Its just 3MB software capable of writing CD, DVD, and even Blu-Ray disks and HD-DVDs too.

KEY FEATURES OF CDBURNERXP

  • burn/write all kinds of discs (CD, DVD, Blu-Ray and HD DVD)
  • audio-CDs with or without gaps between tracks
  • burn and create ISO files
  • data verification after burning process
  • create bootable discs
  • multi-language interface
  • bin/nrg → ISO converter, simple cover printing and much more!
  • Operating Systems: Windows 2000/XP/2003 Server/Vista/Windows 7

Download

from CDBurnerXP Home page
Remember its FREEWARE
Size : 3.04MB

If you are using such free softwares, which are alternative for some paid softwares then you can send me information about that software through the contact page so that i can share that information with all my readers.

ENCY SYMBOL AND WIN PRIZE.


currency symbolsMost of the international countries have there own currency symbol like $ (US Dollar), £ (Great Britain pound), € (Euro), ¥ (Japanese Yen), etc etc. There is no official or special symbol for our Indian currency. Generally we use Rs., or INR, or रु or रुपया (Hindi) to represent the Indian rupees. What if you get a chance to design the Indian currency symbol ?

Ministry of Finance, India, recently started a competition for designers or general public to design the Indian currency symbol. So if you have artist in you then start designing the symbol.

To get more detailed information about this competition just download this PDF fromwebsite of the Ministry of Finance, India.

DOWNLOAD PDF
Source : Ministry of Finance, India.

Last date for submittion of entries is 15th April 2009.

According to PDF,

The symbol has to be either in the Indian National Language Script or a visual representation but should be applicable to the standard computer keyboard.

So be ready for new symbol, will it change the current structure of keyboards ? or it will be assigned through ASCII codes !!
This will be interesting to see for people like me :) . As this may create evolution in keyboards system.

NEW APPLE IPOD SHUFFLE 2009 - PROBLEMS


ipod shuffle 2009, apple ipod newRecently Apple Inc. launched the next version or generation of there basic product “iPod Shuffle“.The first iPod shuffle was launched in 2005 and after 1year in 2006 they launched 2nd generation. This is the third generation of iPod which is launched in March 2009,nearly after 3year.

I do not own iPod, but still after looking at its features i can write this post easily :D .
The new iPod shuffle have amazing features like,
VoiceOver technology that allows song names, artist names, album names and playlist contents and names to be spoken in 14 different languages.
Slick design , cool looks, etc etc.

BUT, here are the few problem that i observed in new iPod shuffle.

CONTROLS

Is older iPod Shuffle the controls were built on the device itself, but here in this new version the controls are on the headsets !!

So if you pluged any third party headsets onto your new iPod shuffle then it will still a allow you to listen to songs as as you start iPod, its starts playing the songs. But this time (using third party headsets) you cant control the iPod shuffle. No next, no pause, no volume up-down… nothing ,…

Some future third-party headphones and headphone adapters will include full support for the iPod shuffle. These headphones contain a special Apple authentication chip. Without this chip, third-party headphones are not allowed to interact with the iPod. - Wikipedia

COLORS OPTIONS

The new iPod shuffle comes in only two colors !!old ipod in different colors
Silver and black.. while the older iPod shuffle was available in pink, Green, Blue ,Lavender, Red, Orange, Turquoise, Mint….ooo !!

MEMORY

This iPod shuffle comes only in one memory option which is 4GB while the older iPod was available in 1 and 2 GB options, though this is not the problem but still… :)

But still the looks of new iPod shuffle is really cool, and stylish. Its slick and smart.iPod shuffle is known for its superb sound quality. The brand Apple itself is a identity of trust and the innovations. I hope, soon the Apple will try to remove all those restrictions and problems from there device.

I recommend all iPod lovers to wait before buying this new edition of iPod, soon you will see the iPod with many other colors. :)

If you are not aware of the new iPod features take a look at this video (or visitApple.com/iPodShuffle/).


HOW TO INCREASE SPEED OF BSNL BROADBAND UL750 PLAN.

Router LightsBSNL - India’s number one Telecommunications Company. I am using UL750 plan of BSNL. UL750 means Unlimited plan with monthly rental of 750INR (taxes extra). It provides speed of 256kbps, which is good for normal surfing and small downloads.

I received many e-mails through the contact page about how to increase the speed of this UL750 plan. Even on Orkut many people ask me how to speed up the connection of BSNL.

Today i am not going to tell you any secret or something different here.I will give you few details about how BSNL or any ISP (Internet service provider) calculate the speed of there connections.

According to plan specifications of 750 UL plan, it is provided that the plan will provide bandwidth of 256kbps (note the small kbps).Means you will get the speed around 32KBps (now note the capital KBps).

If you are aware of storage conventions and about the TB,GB,KB,kb etc. Then you must ware of the table below.

Data conversion table :
Bite: 8 bits = 1 byte
Bytes: 1024 bytes = 1 KB
Kilobytes: 1024 KB = 1 MB
Megabytes: 1024 MB = 1 GB…….

THE FACT :

So as BSNL is providing speed of 256kbps which is equivalent to 32KBps !! So if you are getting speed around 30-32KBps while downloading then you are getting best for what you are paying. If you want any such conversions in broadband plans just divide the number by eight. i.e. 256/8 = 32.

DOWNLOAD A FREE IMAGE RESIZER - A SMALL SOFTWARE BY MICROSOFT.

image-resizedNow a days the camera resolutions are increasing just like cost of petrol. 2MP - 3.2 MP —– 10MP….12MP .. !! ohh… The size of such images is also very huge ranging from 1 MB to more than 10MB. E-mailing such huge images is really hectic task, upload that huge image and the receiver will download that huge image.

Even for storage you need small images from your collection of high resolution images, if the resolution of images is smaller then you can store maximum images in your CD or Pendrive or computer, etc.

Some times u need to resize images for your other needs like resizing images for small device screens like cell phones wallpapers, etc. Webmaster, bloggers also need software to resize images to post them into there websites or blogs. So for many purpose we need a good image resizer software.

Microsoft, worlds largest and most popular software firm, yes.. the owner of Windows operating system which most of us use. So this software is a power toy for your windows operating system, developed by Microsoft and yes Its free !!

Its very tiny software, just 521 KB in size and works super fine for resizing the image for home use.You can resize images at specific size of according to standards like 1024×768, 640×480 etc etc.

DOWNLOAD
Microsoft Image Resizer
(.exe file) Direct link from Microsoft.com
Size : 512 KB
Purpose : to resize images.

After installing the software, just right click the image and click on “Resize pictures” you will get the options to resize your images as per your needs.