B@ptiste Posted August 3, 2020 Share Posted August 3, 2020 (edited) Bonjour, J'utilise PS 1.7.5 et j'ai un soucis de requête SQL. Je veux récupérer plus de données lors de l'export CSV des commandes, mais j'ai uen erreur "FROM" n'existe pas, alors qu'il est bien présent. Voici ma requête. SELECT d.id_order, o.date_add, CONCAT_WS(' ', g.firstname, g.lastname) AS customer, g.email, os.name AS state, d.product_name, d.product_reference, d.product_quantity, d.product_price, o.payment, c.name AS carrier_name, CONCAT_WS(' ', a.lastname, a.firstname, a.address1, a.address2, a.postcode, a.city) AS address_delivery, CONCAT_WS(' ', a.lastname, a.firstname, a.address1, a.address2, a.postcode, a.city) AS address_invoice, REPLACE(IFNULL(GROUP_CONCAT(cd.value), ''), '"', '\'') AS customized_data FROM pre2162_order_detail d LEFT JOIN pre2162_orders o ON (d.id_order = o.id_order) LEFT JOIN pre2162_customer g ON (o.id_customer = g.id_customer) LEFT JOIN pre2162_carrier c ON (o.id_carrier = c.id_carrier) LEFT JOIN pre2162_order_state_lang os ON (o.current_state = os.id_order_state) LEFT JOIN pre2162_address a ON (a.id_address = o.id_address_delivery) LEFT JOIN pre2162_address ab ON (ab.id_address = o.id_address_invoice) LEFT JOIN pre2162_customization cu ON (cu.id_cart = o.id_cart) LEFT JOIN pre2162_customized_data cd ON (cd.id_customization = cu.id_customization) GROUP BY d.id_order ORDER BY d.id_order DESC Merci. Edited August 4, 2020 by B@ptiste (see edit history) Link to comment Share on other sites More sharing options...
doekia Posted August 3, 2020 Share Posted August 3, 2020 si FROM n'existe pas c'est que ton prefixe est invalide (pre2162_). Corriges-le, tout rentrera dans l'ordre. Link to comment Share on other sites More sharing options...
B@ptiste Posted August 3, 2020 Author Share Posted August 3, 2020 Si ça pouvait être aussi simple 😁, mais non... J'ignore comment j'ai "résolu" le soucis du FROM, j'ai juste tout repris et réécrit depuis le début à l'dientique, et il y a une nouvelle erreur maintenant, Erreur non définie "checkedForm", et le soucis viendrait seulement des ON, j'ai vu que beaucoup avait ce soucis de checkedForm sur ce forum, mais aucune solution n'a l'air de fonctionner. Link to comment Share on other sites More sharing options...
B@ptiste Posted August 4, 2020 Author Share Posted August 4, 2020 Bon, le problème a été résolu en mettant à jour PS en 1.7.6. 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