Reminder: Download and install Magento security patches. Download now.

You need to download two files from https://www.magentocommerce.com/products/downloads/magento/ 1) SUPEE-5344 2) SUPEE-1533 These two are security patches for magento that addresses potential remote code execution exploits. To execute these two files you need to download both files and upload to root directory of your Magento Installation. Then through ssh execute below commands: sh name-of-file1.sh sh name-of-file2.sh Replace "name-of-file1.sh" and "name-of-file2.sh" with the real filenames downloaded.

Magento #1146 - Table doesn't exist

Magento #1146 - Table doesn't exist. I faced a very irritating issue. When i logged in phpmyadmin and looked at a table in left column the table shows. But when i try to open that table by clicking on it , it throws error "#1146 - Table `DB NAME.tag_summary` doesn't exist "

I tried to drop the table and create the table agian but it throws same error "#1146 - Table `DB NAME.tag_summary` doesn't exist".

Below is the solution:

You would need to access the server via SSH and after that navigate to /var/lib/mysql and go to the database folder.

For eg: cd /var/lib/mysql/DATABASE Folder and then delete the table using

rm -rf DB NAME.tag_summary

rm -rf DB NAME.tag_summary.ibd

rm -rf DB NAME.tag_summary.frm

Then connect to mysql by using the command mysql and follow the below steps:

use DB NAME;

DROP TABLE DB NAME.tag_summary;

Magento CE 1.9.0.0 Released

While we are eagerly waiting for Magento 2.0 , Magento has released its latest CE Magento CE 1.9.0.0 . Most store owners used to complain about why Magento donot provide responsive theme by default. To an extent this was a question that often haunted my mind too. With this release Magento has addressed to this requirement and provided default Responsive theme. The changelog of the latest version can be viewed Here .
With the launch of new version now there will be rush to upgrade all magento stores to latest version and rightly it should be as many security updates are  also added  to make Magento more secure.

Why we use Antivirus?

Why we use Antivirus?

Many users think that we can get viruses by downloading files,visiting wrong websites and clicking irresponsible things.It's true-this is how we pick viruses, but it is not the only way we pick up viruses,but it is not the only way viruses spread out.Our computer sometime may be infected just from visiting a website or by putting some other external devices e.g.U.S.B,Harddisk etc.

 

In the leading world of globalisation people trust on computers and internet to send,receive and manage their valuable informations.The term protection is prior word which comes to their mind when using interne, as the informations sent over network has many risks from the devil malwares who are responsible for hampering the information on internet.So it is important for the user to protect their computers from risk.

One of the best solution  to this problem is antivirus.An antivirus programs protects your computer from the viruses by identifying and removing it.Now these days antivivirus more often comes with firewall packages that blocks the unwanted things and ptotects your computer.Antivirus automatically scans your files downloaded from the web,email attachments and all types of removable cables  inserted in the computer.It also removes  malicious .malwares like viruses.Thus making you to feel free to send all your informations.

 

To prevent our system from the unwanted malware or viruses,we need a software that is know as antivirus.It is used to prevent,detect and remove malicious computer viruses from your computer.Software described viruses from computer.Software described as antivirus also works against different types of malware e.g rootkit,trojan horses,worms and spywares etc.

Updating the antivirus programs regularly is important because it will download an new virus definitation that have been added since last update

 

 

Lamp install on Ubuntu with few clicks

Easiest way to install Lamp Server i have found after googling for 2 hours.
I thought to share with you so you can also get benefit from it.

sudo apt-get install tasksel
sudo tasksel install lamp-server

After you will be prompted to enter mysql root password . Enter the root password for Mysql and press enter.

It will install most rexommended php modules.

If you want to install phpmyadmin run below command:
sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin

-----------------------------------------Enjoy-----------------------------------------------------

Excel extarct words before and after a specific word

Excel extarct words before and after a specific word

For example, you have the following text in a cell “A1″ and you’d like to extract the text before the comma (the last name):
“Alam, Afroz”
To extract the last name before the comma “Alam” from A1, use one of the following formula:
=LEFT(A1,(FIND(",",A1,1)-1))
The result: Alam
To extract the first name after the comma from A1, use one of the following formula:
=MID(A1,FIND(",",A1)+2,256)
The result: Afroz

Compare data in Excel in two columns to find duplicates

Compare data in Excel in  two columns to find duplicates

To use a formula to compare the data in two columns:

1. In a new worksheet, enter the following data (leave column B empty):

   X1: 1   Y1:     Z1: 3
   X2: 2   Y2:     Z2: 5
   X3: 3   Y3:     Z3: 8
   X4: 4   Y4:     Z4: 2
   X5: 5   Y5:     Z5: 0
        

2. Type the following formula in cell B1:
   =IF(ISERROR(MATCH(X1,$Z$1:$Z$5,0)),"",X1)
3. Select cells Y1:Y5.
4. The duplicate numbers are displayed in column B, as in the following example:

   X1: 1   Y1:      Z1: 3
   X2: 2   Y2:2     Z2: 5
   X3: 3   Y3:3     Z3: 8
   X4: 4   Y4:      Z4: 2
   X5: 5   Y5:5     Z5: 0