cancel
Showing results for 
Search instead for 
Did you mean: 

Error in installing sample data 1.9.sql

Error in installing sample data 1.9.sql

I followed this tutorial to install magento on my local computer, but I wasn't able to successfully import the sample data file, neither with Phpmyadmin nor with SQLWorkbench. I'm using the current xampp version (5.6.8) from ApacheFriends.

 

Both tools returned several sql errors and stopped the import.

 

INSERT INTO `core_url_rewrite` VALUES (50403,2,'55760400_1365403874','men/tees-knits-and-polos/chelsea-tee-521.html','men/tees-knits-and-polos/chelsea-tee-577.html',0,'RP',NULL,16,408),(50405,2,'56674900_1365403874','chelsea-tee-583.html','chelsea-tee-702.html',0,'RP',NULL,NULL,409),(50407,2,'57954300_1365403874','men/tees-knits-and-polos/chelsea-tee-522.html','men/tees-knits-and-polos/chelsea-tee-578.html',0,'RP',NULL,16,409),(50409,2,'58944500_1365403874','chelsea-tee-584.html','chelsea-tee-703.html',0,'RP',NULL,NULL,410),(50412,2,'60489200_1365403874','men/tees-knits-and-polos/chelsea-tee-523.html','men/tees-knits-and-polos/chelsea-tee-579.html',0,'RP',NULL,16,410),(50414,2,'61416300_1365403874','merino-v-neck-pullover-sweater-521.html','merino-v-neck-pullover-sweater-556.html',0,'RP',NULL,NULL,411),(50416,2,'62548000_1365403874','men/tees-knits-and-polos/merino-v-neck-pullover-sweater-453.html','men/tees-knits-and-polos/merino-v-neck-pullover-sweater-474.html',0,'RP',NULL,16,411),([...]

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''720908' at line 1

 

 

What did I wrong? How can I solve the errors?

2 REPLIES 2

Re: Error in installing sample data 1.9.sql

You have forgotten to share link which you followed for installation, will you please share the link or share the steps you have followed for installation?

Re: Error in installing sample data 1.9.sql

Did you attempt to import sample data before or after installing Magento? It is important that you do the sample data first.
Sindre M, CEO & Founder
ProperHost.com - The Magento Hosting Experts