Hugo
Hugo
Explore posts from servers
NNuxtRRefineDTDrizzle Team
PostsComments
DTDrizzle Team
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"]
29 replies
DTDrizzle Team
Created by Hugo on 9/28/2023 in #help
Mysql Syntax error executing query
i can give you the git repo, how can i see the query dat got generated ?
29 replies
DTDrizzle Team
Created by Hugo on 9/26/2023 in #help
Select Entry in db with relational tables
hie ! do you know why it still give me this error ?
24 replies
DTDrizzle Team
Created by Hugo on 9/26/2023 in #help
Select Entry in db with relational tables
so i will stay with your first tips
24 replies
DTDrizzle Team
Created by Hugo on 9/26/2023 in #help
Select Entry in db with relational tables
sorry it's in french
24 replies
DTDrizzle Team
Created by Hugo on 9/26/2023 in #help
Select Entry in db with relational tables
No description
24 replies
DTDrizzle Team
Created by Hugo on 9/26/2023 in #help
Select Entry in db with relational tables
and the i can import * from index.ts
24 replies
DTDrizzle Team
Created by Hugo on 9/26/2023 in #help
Select Entry in db with relational tables
No description
24 replies
DTDrizzle Team
Created by Hugo on 9/26/2023 in #help
Select Entry in db with relational tables
like that ?
24 replies
DTDrizzle Team
Created by Hugo on 9/26/2023 in #help
Select Entry in db with relational tables
well than you for this method !
24 replies
DTDrizzle Team
Created by Hugo on 9/26/2023 in #help
Select Entry in db with relational tables
No description
24 replies
DTDrizzle Team
Created by Hugo on 9/26/2023 in #help
Select Entry in db with relational tables
i try to follow the docs, but if i have my db connection withour passing schema in it inside a index.ts file for main db connection, i have to create a new one inside this file where i whant to get this formated data
24 replies