#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2015
    Posts
    1
    Rep Power
    0

    Error import : #1064 -You have an error in your SQL syntax;


    I am very new to this Forum....

    I've UwAmp and I develop a Prestashop in local environment. Then, I try to upload my prestashop to my server (a VPS Cloud from OVH). So I export my database from my UwAmp PhpMyAdmin and after, I try to upload to my Server PhpMyAdmin but I've the following error :

    __________

    #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 'CREATE TABLE `ps_ye_mail` (
    `id_mail` int(11) unsigned NOT NULL,
    `recipient` v' at line 98
    __________

    If I separate my export in two parts (one from the begin to the n132, before ps_ye_mail, and the second from the ps_ye_mail to the end) my import has no error. BUT my e-shop has the following error if I try to access to my cart page :
    __________
    [PrestaShopDatabaseException]

    Subquery returns more than 1 row

    UPDATE `ps_ye_cart_product`
    SET `id_address_delivery` = (
    SELECT `id_address_delivery` FROM `ps_ye_cart`
    WHERE `id_cart` = 0 AND `id_shop` = 1
    )
    WHERE `id_cart` = 0
    __________

    Look at the code from PhpMyAdmin export of the corresponding table :

    CREATE TABLE `ps_ye_mail` (
    `id_mail` int(11) unsigned NOT NULL,
    `recipient` varchar(126) NOT NULL,
    `template` varchar(62) NOT NULL,
    `subject` varchar(254) NOT NULL,
    `id_lang` int(11) unsigned NOT NULL,
    `date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



    Have you an idea for help me to resolve this problem ?

    I hope that I was quite understandable... If is not, let me know.
    I'm looking forward to looking from you and I thank you for your help!
    Last edited by requinix; December 22nd, 2015 at 04:34 AM. Reason: removing fake signature with spammy links
  2. #2
  3. Lazy Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    16,436
    Rep Power
    9645
    Please confirm you are a human. And that your name is Dave/David. And that when you asked this question on a couple other forums last month you didn't get the answers you needed.

    Comments on this post

    • Will-O-The-Wisp agrees : Thank you! I'll keep an eye on this one.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2006
    Posts
    2,632
    Rep Power
    1811
    Hello Dave, would you like to play a game of chess?

    Comments on this post

    • Will-O-The-Wisp agrees : lol
    The moon on the one hand, the dawn on the other:
    The moon is my sister, the dawn is my brother.
    The moon on my left and the dawn on my right.
    My brother, good morning: my sister, good night.
    -- Hilaire Belloc

IMN logo majestic logo threadwatch logo seochat tools logo