Grafyx89 Posted March 13, 2019 Share Posted March 13, 2019 (edited) Hello à tous, J'utilise le module pour migrer de Woocommerce vers Prestashop, quand j'importe les produits, ce dernier me trouve l'erreur suivante. J'ai beau regarder dans la base de donnée (de prestashop), il n'y a pas ses données. J'ai modifié dans le back-office de Woocommerce, l'attribut "Plat à cake "Ikat" ", j'ai retiré les guillemets, logiquement, il aurais du mettre à jour la base de donnée ?. J'ai retenté une import, toujours la même erreur. Suis-je à côté de la plaque ? Merci beaucoup de votre aide, 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 'Ikat"" and a.id_attribute_group=2 and al.id_lang =1 LIMIT 1' at line 1 SELECT a.id_attribute from ps_attribute as a join ps_attribute_lang as al on a.id_attribute=al.id_attribute where al.name = "Plat à cake "Ikat"" and a.id_attribute_group=2 and al.id_lang =1 LIMIT 1 Edited March 15, 2019 by Grafyx89 (see edit history) Link to comment Share on other sites More sharing options...
doekia Posted March 13, 2019 Share Posted March 13, 2019 Je ne sais pas ce que tu as changé, mais visible cela n'a rien changé coté extraction, donc, même erreur, logique. Vois avec l'auteur du module d'où il extrait les données exactement Link to comment Share on other sites More sharing options...
ksaan Posted March 13, 2019 Share Posted March 13, 2019 Et si tu exécutes cette requête SQL dans ta database, elle s'exécute correctement ou tu as une erreur ? Link to comment Share on other sites More sharing options...
doekia Posted March 14, 2019 Share Posted March 14, 2019 8 hours ago, ksaan said: Et si tu exécutes cette requête SQL dans ta database, elle s'exécute correctement ou tu as une erreur ? Cette directive SQL n'est pas valide. Elle ne s'exécutera nulle part ! Link to comment Share on other sites More sharing options...
MigrationPro Posted March 14, 2019 Share Posted March 14, 2019 5 16 hours ago, Grafyx89 said: Hello everyone, I use the module to migrate from Woocommerce to Prestashop, when I import the products, the latter finds the following error. I look in the database (prestashop), there is no data. I modified in the back office of Woocommerce, the attribute "Ikat" cake plate "", I removed the quotation marks, logically, it should have updated the database. I retried an import, always the same mistake. Am I next to the plate? Thank you very much for your help, 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 'Ikat "" and a.id_attribute_group = 2 and al.id_lang = 1 LIMIT 1' at line 1 Hello Grafyx89, We have asked the necessary information to fix the issue you have faced. Just send us what we need and we will fix your faced problem quickly. Regards, MigrationPro - Technical Team Link to comment Share on other sites More sharing options...
Grafyx89 Posted March 14, 2019 Author Share Posted March 14, 2019 3 hours ago, doekia said: Cette directive SQL n'est pas valide. Elle ne s'exécutera nulle part ! Effectivement, cette requête ne s'éxécute pas, mais si on enlève les guillemets autour de "Ikat", elle s'éxécute. Link to comment Share on other sites More sharing options...
MigrationPro Posted March 14, 2019 Share Posted March 14, 2019 1 hour ago, Migration Pro said: 1 hour ago, Migration Pro said: avez-vous lu mon message précédent? Link to comment Share on other sites More sharing options...
Grafyx89 Posted March 14, 2019 Author Share Posted March 14, 2019 Hello @Migration Pro I sent you a message from prestashop addons with the account that bought the module, with the necessary access. ! I send you a private message Link to comment Share on other sites More sharing options...
MigrationPro Posted March 14, 2019 Share Posted March 14, 2019 Understood let me check Link to comment Share on other sites More sharing options...
MigrationPro Posted March 14, 2019 Share Posted March 14, 2019 Fixed the SQL error 1 Link to comment Share on other sites More sharing options...
Grafyx89 Posted March 14, 2019 Author Share Posted March 14, 2019 Cool! it works Thx you very much ! 1 Link to comment Share on other sites More sharing options...
MigrationPro Posted March 14, 2019 Share Posted March 14, 2019 You are most Welcome! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now