cancel
Showing results for 
Search instead for 
Did you mean: 

Error in installing sample data 1.9.sql

SOLVED

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?

5 REPLIES

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.

--

Community Manager, Magento
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!

--

Community Manager, Magento
Problem solved? Click Accept as Solution!
Still stuck? Check out our documentation: https://magento.com/resources/technical