cson Posted May 13, 2014 Share Posted May 13, 2014 Hi Need to install Presta Shop on new domain. I get this error trying to import my Data base backup. into a new DB via PHP admin. Can anyone please tell me hov to solve it? INSERT INTO `ps_address` VALUES ('1','21','0','0','1','0','0','manufacturer',NULL,'JOBS','STEVE','1 Infinite Loop',NULL,'95014','Cupertino',NULL,'(800) 275-2273',NULL,NULL,NULL,'2013-08-27 18:29:07','2013-08-27 18:29:07','1','0'), ('2','8','0','1','0','0','0','Mon adresse','My Company','DOE','John','16, Main street','2nd floor','75002','Paris ',NULL,'0102030405',NULL,NULL,NULL,'2013-08-27 18:29:07','2013-11-10 18:59:56','1','1'), ('3','21','32','0','0','1','0','supplier','Apple','supplier','supplier','767 Fifth Ave.',NULL,'10153','New York',NULL,'(212) 336-1440',NULL,NULL,NULL,'2013-08-27 18:29:07','2013-08-27 18:29:07','1','0'), ('4','21','13','0','0','2','0','supplier','Shure','supplier','supplier','5800 W. Touhy Ave',NULL,'60714','Niles',NULL,'800-434-3350',NULL,NULL,NULL,'2013-08-27 18:29:07','2013-08-27 18:29:07','1','0'), ('6','20','0','3','0','0','0','Min adresse','bfdfg','mig','mig','gggfg2',NULL,'3333','drhbergeg',NULL,'44444444',NULL,NULL,NULL,'2013-10-11 12:53:33','2013-10[...] MySQL returnerede: Dokumentation #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 'DROP TABLE IF EXISTS `ps_address_format`' at line 24 Regards Carsten Link to comment Share on other sites More sharing options...
Recommended Posts