Hugo Comments - Answer Overflow

Hugo

Explore posts from servers

•Created by Hugo on 9/28/2023 in #help

Mysql Syntax error executing query

Well, Thank you for all your time, i really appreciate. I understand the purpose of a reproduction repo. Because of i am to much a beginner with full stacks and mysql, i mooved to prisma that si more easy to use at level

29 replies

DTDrizzle Team

•Created by Hugo on 9/28/2023 in #help

Mysql Syntax error executing query

By the way if i try to execute this query on phpmyadmin i get the same issue so i think it's a mysql issue depending on the version, but the probleme is i can't change the generated query from drizzle

29 replies

DTDrizzle Team

•Created by Hugo on 9/28/2023 in #help

Mysql Syntax error executing query

i do'nt know what is a repo repo i will check on googl

29 replies

DTDrizzle Team

•Created by Hugo on 9/28/2023 in #help

Mysql Syntax error executing query

i just added you. The query is here: https://github.com/Hrobitaillie/streeteats/blob/main/admin/hooks/getStore.ts

29 replies

DTDrizzle Team

•Created by Hugo on 9/28/2023 in #help

Mysql Syntax error executing query

i need your github tag to add you to the repo

29 replies

DTDrizzle Team

•Created by Hugo on 9/28/2023 in #help

Mysql Syntax error executing query

Hi !

29 replies

DTDrizzle Team

•Created by Hugo on 9/28/2023 in #help

Mysql Syntax error executing query

If you give me your github tag i will add you to my repo

29 replies

DTDrizzle Team

•Created by Hugo on 9/28/2023 in #help

Mysql Syntax error executing query

- error node_modules/mysql2/promise.js (94:21) @ PromiseConnection.query
- error Error: 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 '(select coalesce(json_arrayagg(json_array(`stores_categories`.`id_store`, `store' at line 1
null
- error node_modules/mysql2/promise.js (94:21) @ PromiseConnection.query
- error Error: 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 '(select coalesce(json_arrayagg(json_array(`stores_categories`.`id_store`, `store' at line 1
digest: "3833260066"
null

- error node_modules/mysql2/promise.js (94:21) @ PromiseConnection.query
- error Error: 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 '(select coalesce(json_arrayagg(json_array(`stores_categories`.`id_store`, `store' at line 1
null
- error node_modules/mysql2/promise.js (94:21) @ PromiseConnection.query
- error Error: 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 '(select coalesce(json_arrayagg(json_array(`stores_categories`.`id_store`, `store' at line 1
digest: "3833260066"
null

29 replies

DTDrizzle Team

•Created by Hugo on 9/28/2023 in #help

Mysql Syntax error executing query

this is what i got:

Query: select `stores`.`id_store`, `stores`.`cuid_store`, `stores`.`id_currency`, `stores`.`name`, `stores`.`baseline`, `stores`.`realtime_position`, `stores`.`last_position_updated`, `stores`.`profile_picture`, `stores`.`featured_label`, `stores`.`siret`, `stores`.`ape`, `stores`.`wrapping_enabled`, `stores`.`wrapping_price`, `stores`.`cutleries_enabled`, `stores`.`cutleries_price`, `stores`.`date_add`, `stores`.`date_update`, `stores_categories`.`data` as `categories`, `stores_pictures`.`data` as `pictures` from `stores` left join lateral (select coalesce(json_arrayagg(json_array(`stores_categories`.`id_store`, `stores_categories`.`id_category`)), json_array()) as `data` from `stores_categories` where `stores_categories`.`id_store` = `stores`.`id_store`) `stores_categories` on true left join lateral (select coalesce(json_arrayagg(json_array(`stores_pictures`.`id_picture`, `stores_pictures`.`id_store`, `stores_pictures`.`img_url`)), json_array()) as `data` from `stores_pictures` where `stores_pictures`.`id_store` = `stores`.`id_store`) `stores_pictures` on true
Query: select `id_customer`, `id_gender`, `id_lang`, `id_group`, `firstname`, `lastname`, `id_clerk`, `phone_number`, `email`, `password`, `last_password_gen`, `birthday`, `profile_picture`, `date_add`, `date_update` from `customers` where `customers`.`id_clerk` = ? -- params: ["user_2UTDrNFrpFYccEasywI5ZpKDQj0"]

Query: select `stores`.`id_store`, `stores`.`cuid_store`, `stores`.`id_currency`, `stores`.`name`, `stores`.`baseline`, `stores`.`realtime_position`, `stores`.`last_position_updated`, `stores`.`profile_picture`, `stores`.`featured_label`, `stores`.`siret`, `stores`.`ape`, `stores`.`wrapping_enabled`, `stores`.`wrapping_price`, `stores`.`cutleries_enabled`, `stores`.`cutleries_price`, `stores`.`date_add`, `stores`.`date_update`, `stores_categories`.`data` as `categories`, `stores_pictures`.`data` as `pictures` from `stores` left join lateral (select coalesce(json_arrayagg(json_array(`stores_categories`.`id_store`, `stores_categories`.`id_category`)), json_array()) as `data` from `stores_categories` where `stores_categories`.`id_store` = `stores`.`id_store`) `stores_categories` on true left join lateral (select coalesce(json_arrayagg(json_array(`stores_pictures`.`id_picture`, `stores_pictures`.`id_store`, `stores_pictures`.`img_url`)), json_array()) as `data` from `stores_pictures` where `stores_pictures`.`id_store` = `stores`.`id_store`) `stores_pictures` on true
Query: select `id_customer`, `id_gender`, `id_lang`, `id_group`, `firstname`, `lastname`, `id_clerk`, `phone_number`, `email`, `password`, `last_password_gen`, `birthday`, `profile_picture`, `date_add`, `date_update` from `customers` where `customers`.`id_clerk` = ? -- params: ["user_2UTDrNFrpFYccEasywI5ZpKDQj0"]