Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

[Solved] Challenges uploading Sample SQL file
 
tjanta
Jr. Member
 
Total Posts:  3
Joined:  2012-06-30
 

When I want to upload the SQL sample file, its getting interupted.
My installation is all done directly to the server.

I created my database using plesk.
Then opened Pphmyadmin.

I see there is a maximum upload limit. So its not uploading the files correctly.
I dunno if it shud work, but when I try to upload it within a compressed zip file, I’m getting these errors:

SQL-query:

CREATE TABLE `tag` ( `tag_idint(10unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tag Id', `namevarchar(255) DEFAULT NULL COMMENT 'Name', `statussmallint(6NOT NULL DEFAULT '0' COMMENT 'Status', `first_customer_idint(10unsigned DEFAULT NULL COMMENT 'First Customer Id', `first_store_idsmallint(5unsigned DEFAULT NULL COMMENT 'First Store Id'PRIMARY KEY (`tag_id`) USING BTREEKEY `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`first_customer_id`), KEY `FK_TAG_FIRST_STORE_ID_CORE_STORE_STORE_ID` (`first_store_id`), CONSTRAINT `FK_TAG_FIRST_STORE_ID_CORE_STORE_STORE_IDFOREIGN KEY (`first_store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE NO ACTIONCONSTRAINT `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_IDFOREIGN KEY (`first_customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE NO ACTION ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[...]

MySQL retourneerde: Documentatie
#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 '
USING BTREE,
  
KEY `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`first' at line 7

I also tried a different method, using a PHP uploader into MySQL.
There I’m also getting errors.

https://dl.dropbox.com/u/30478272/error.png

Is there something what I’m doing wrong?
Is there an alternative?

HELP!

 
Magento Community Magento Community
Magento Community
Magento Community
 
tjanta
Jr. Member
 
Total Posts:  3
Joined:  2012-06-30
 

Problem solved by editing the SQL file:

solved this problem by changing:

PRIMARY KEY (`tag_id`) USING BTREE,
changed into
PRIMARY KEY USING BTREE (`tag_id`),

PRIMARY KEY (`tag_relation_id`) USING BTREE ,
changed into
PRIMARY KEY USING BTREE (`tag_relation_id`),

smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
pmha
Jr. Member
 
Total Posts:  1
Joined:  2013-08-11
 

Thank you! it works

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top