Jump to content
  • 0
PrestaAC

Transfering Cloud to Localhost domain.

Question

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: dot.gif

#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
 

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites
  • 0

@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 contact@prestashopmanager.com, 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 by Iryna

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More