Transfering Cloud to Localhost domain.

[PrestaAC]

I've been trying to transfer my cloud Prestashop to my own server but I keep having problem with my SQL database.

 

Error

Static analysis:

4 errors were found during analysis.

 

1. Unexpected beginning of statement. (near "eMagicOne" at position 0)
2. Unexpected beginning of statement. (near "Store" at position 10)
3. Unexpected beginning of statement. (near "Manager" at position 16)
4. Unrecognized statement type. (near "for" at position 24)

 

SQL query:

eMagicOne Store Manager for PrestaShop 2.28.0.1597 SET FOREIGN_KEY_CHECKS=0

MySQL said: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'eMagicOne Store Manager for PrestaShop 2.28.0.1597

SET FOREIGN_KEY_CHECKS=0' at line 1

 

This is what happens everytime I try to import the SQL database in PHPMYADMIN

 

This is the start of my SQL file:

 

# eMagicOne Store Manager for PrestaShop 2.28.0.1597

# ---------------------------------------

# Host     : 

# Port     : 0

# Database : cloud_www_***private***_com

 

 

SET FOREIGN_KEY_CHECKS=0;

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

 

 

 

DROP TABLE IF EXISTS `ps_access`;

 

CREATE TABLE `ps_access` (

 

 

Do you see anything weird ? Thanks for the support

 

[Guest]

Have you talked to Emagicone who provided the store manager module?

 

It may be that there is a difference between the cloud version and the self hosted versions of their software

[Iryna]

@PrestaAC

 

Hello, 

 

Store Manager for PrestaShop v.2.28.0.1597, you use to transfer data, is fully compatible with PrestaShop v.1.6.x as well as with Cloud-based PrestaShop stores. If your target self-hosted store is based on PrestaShop v.1.7.0.x, you'd better use the latest version of the application.

 

If the issue remains on the latest version, please contact Store Manager Support Team via email [email protected], describe your case and attach the screenshots of the error you get. We will gladly check your case if you provide us more details. 

Edited April 24, 2017 by Iryna (see edit history)