cancel
Showing results for 
Search instead for 
Did you mean: 

Error in installing sample data 1.9.sql

SOLVED
   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Error in installing sample data 1.9.sql

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

 

MySQL said: Documentation

#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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Error in installing sample data 1.9.sql

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

 

View solution in original post

5 REPLIES 5

Re: Error in installing sample data 1.9.sql

Does this line of code right?

`session_expires` int(10) unsigned NOT NULL DEFAULT '0

Re: Error in installing sample data 1.9.sql

Hi

Yes the code is right

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

Re: Error in installing sample data 1.9.sql

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

 

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