- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2015
04:30 AM
07-22-2015
04:30 AM
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?
Labels:
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2016
11:07 PM
06-12-2016
11:07 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2016
01:47 AM
06-13-2016
01:47 AM
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
ProperHost.com - The Magento Hosting Experts