- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
I use magento CE 1.9 on xampp 3.2.1 server, my OS is windows 7 64 bit
I want to import magento_sample_data_for_1.9.1.0.sql.zip to mysql, after 3 or 4 minutes the error appears
Error
SQL query:
CREATE TABLE `core_session` ( `session_id` varchar(255) NOT NULL COMMENT 'Session Id', `session_expires` int(10) unsigned NOT NULL DEFAULT '0
#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 ''0' at line 3
what should I do?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
tnx, the error was about partial import in phpmyadmin, when I uncheck this option and increase php timeout the script imported after 10 minutes successfuly
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Error in installing sample data 1.9.sql
Does this line of code right?
`session_expires` int(10) unsigned NOT NULL DEFAULT '0
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Error in installing sample data 1.9.sql
Hi
Yes the code is right
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Error in installing sample data 1.9.sql
Just to clarify, your code isn't cutting off at '0 is it?
The full block where that is should look like this:
DROP TABLE IF EXISTS `core_session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `core_session` ( `session_id` varchar(255) NOT NULL COMMENT 'Session Id', `session_expires` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Date of Session Expiration', `session_data` mediumblob NOT NULL COMMENT 'Session Data', PRIMARY KEY (`session_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Database Sessions Storage'; /*!40101 SET character_set_client = @saved_cs_client */;
Also, did you have a fresh database when you installed the sample data? It needs to be imported before installing Magento.
Developer Relations, Adobe Experience Cloud
Problem solved? Click Accept as Solution!
Still stuck? Check out our documentation: https://magento.com/resources/technical
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Error in installing sample data 1.9.sql
Glad to hear it, thanks for reporting back @hadiDeveloper!
Developer Relations, Adobe Experience Cloud
Problem solved? Click Accept as Solution!
Still stuck? Check out our documentation: https://magento.com/resources/technical