{"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":21220,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-15T14:45:14.103Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":21748,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-16T05:47:11.219Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24664,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-16T05:49:34.433Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":8484,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-16T05:50:22.180Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":10964,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-16T05:57:59.780Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":10056,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-16T06:01:53.655Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20388,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-16T08:50:42.654Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":17396,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-16T08:51:35.013Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":16692,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-16T08:59:16.935Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12668,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-16T08:59:37.006Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":13368,"level":50,"err":{"message":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'gbakos.magento.com' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'gbakos.magento.com' (using password: YES)","time":"2023-06-16T09:01:39.089Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'supplier' } \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:19:21.106Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:19:21.110Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'supplier' }","time":"2023-06-16T09:19:21.111Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-06-16T09:19:21.113Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'client' } \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:19:21.415Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:19:21.419Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'client' }","time":"2023-06-16T09:19:21.421Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-06-16T09:19:21.422Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"Product.containModels 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 ':property_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Product.count (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:649:26)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async ProductsService.getTotal (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:44:17)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:63:37 {\n message: \"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 ':property_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(products.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM products \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN categories ON (categories.id = products.category_id) LEFT JOIN properties ON (properties.id = products.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (products.property_id = :property_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':property_id)' at line 4\"\n} { property_id: '1' } \nParams: null { property_id: '1' } [ '*' ] { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } count undefined","time":"2023-06-16T09:19:46.221Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"Product.containModels RestError [InternalError]: 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 ':property_id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: null { property_id: '1' } [ '*' ] { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } count undefined","time":"2023-06-16T09:19:46.223Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"ProductsService.getTotal RestError [InternalError]: 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 ':property_id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: No property { property_id: '1' }","time":"2023-06-16T09:19:46.224Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"err":{"message":"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 ':property_id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':property_id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':property_id)' at line 4","time":"2023-06-16T09:19:46.225Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'client' } \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:19:50.464Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:19:50.467Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'client' }","time":"2023-06-16T09:19:50.468Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-06-16T09:19:50.472Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'client' } \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:19:53.064Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:19:53.066Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'client' }","time":"2023-06-16T09:19:53.067Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":12512,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-06-16T09:19:53.068Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":14460,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'supplier' } \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:21:45.229Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":14460,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:21:45.233Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":14460,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'supplier' }","time":"2023-06-16T09:21:45.235Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":14460,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-06-16T09:21:45.237Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":14460,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'supplier' } \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:25:42.290Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":14460,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:25:42.293Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":14460,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'supplier' }","time":"2023-06-16T09:25:42.294Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":14460,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-06-16T09:25:42.295Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":9944,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'client' } \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:28:20.217Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":9944,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:28:20.221Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":9944,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'client' }","time":"2023-06-16T09:28:20.223Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":9944,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-06-16T09:28:20.225Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":9944,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'supplier' } \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:28:27.757Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":9944,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-06-16T09:28:27.759Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":9944,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'supplier' }","time":"2023-06-16T09:28:27.760Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":9944,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-06-16T09:28:27.761Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Order.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Order.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT orders.*, (orders.total - (orders.total * (orders.discount / 100))) AS total, businesses.*, clients.*, properties.id, properties.name\\n' +\n '\\t\\t\\t\\t\\tFROM orders \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses ON (businesses.id = orders.business_id) LEFT JOIN businesses AS clients ON (clients.id = orders.client_id) LEFT JOIN properties ON (properties.id = orders.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (orders.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2535 } \nParams: null { id: 2535 } [\n '*',\n '(orders.total - (orders.total * (orders.discount / 100))) AS total'\n] { businesses: [ '*' ], clients: [ '*' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-08T10:47:36.468Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Order.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Order.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: null { id: 2535 } [\n '*',\n '(orders.total - (orders.total * (orders.discount / 100))) AS total'\n] { businesses: [ '*' ], clients: [ '*' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-08T10:47:36.472Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"OrdersService.getSingle RestError [InternalError]: 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 ':id)' at line 4\n at Order.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-08-08T10:47:36.475Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Category.containModels 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 ':property_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Category.count (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:649:26)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async CategoriesService.getTotal (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:44:17)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:386:33 {\n message: \"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 ':property_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(categories.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM categories \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN properties ON (properties.id = categories.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (categories.property_id = :property_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':property_id)' at line 4\"\n} { property_id: '1' } \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2023-08-08T10:47:41.109Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Category.containModels RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2023-08-08T10:47:41.111Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"CategoriesService.getTotal RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: No property { property_id: '1' }","time":"2023-08-08T10:47:41.112Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"err":{"message":"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 ':property_id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':property_id)' at line 4","time":"2023-08-08T10:47:41.113Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Product.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Product.get (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:687:25)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async ProductsService.getSingle (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:73:18)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:158:20 {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT products.*, categories.id, categories.name, properties.id, properties.name\\n' +\n '\\t\\t\\t\\t\\tFROM products \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN categories ON (categories.id = products.category_id) LEFT JOIN properties ON (properties.id = products.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (products.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 53 } \nParams: null { id: 53 } null { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-08T10:47:41.115Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Product.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: null { id: 53 } null { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-08T10:47:41.115Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"ProductsService.getSingle RestError [InternalError]: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: 53 No property","time":"2023-08-08T10:47:41.116Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"err":{"message":"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 ':id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':id)' at line 4","time":"2023-08-08T10:47:41.116Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Category.containModels 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 ':property_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Category.count (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:649:26)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async CategoriesService.getTotal (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:44:17)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:386:33 {\n message: \"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 ':property_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(categories.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM categories \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN properties ON (properties.id = categories.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (categories.property_id = :property_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':property_id)' at line 4\"\n} { property_id: '1' } \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2023-08-08T11:23:32.803Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Category.containModels RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2023-08-08T11:23:32.807Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"CategoriesService.getTotal RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: No property { property_id: '1' }","time":"2023-08-08T11:23:32.808Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"err":{"message":"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 ':property_id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':property_id)' at line 4","time":"2023-08-08T11:23:32.811Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Product.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Product.get (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:687:25)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async ProductsService.getSingle (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:73:18)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:158:20 {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT products.*, categories.id, categories.name, properties.id, properties.name\\n' +\n '\\t\\t\\t\\t\\tFROM products \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN categories ON (categories.id = products.category_id) LEFT JOIN properties ON (properties.id = products.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (products.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 66 } \nParams: null { id: 66 } null { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-08T11:23:32.815Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Product.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: null { id: 66 } null { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-08T11:23:32.816Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"ProductsService.getSingle RestError [InternalError]: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: 66 No property","time":"2023-08-08T11:23:32.817Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"err":{"message":"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 ':id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':id)' at line 4","time":"2023-08-08T11:23:32.818Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Report.query RestError [InternalError]: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n at Report.query (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:105:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async Report.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\repositories\\Report.js:94:29)\n at async ReportsService.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\services\\ReportsService.js:24:26)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\routes\\ReportsRouter.js:52:28 {\n jse_shortmsg: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n jse_info: {},\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n body: {\n code: 'Internal',\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\"\n }\n} \nParams: \n SELECT\n clients.gh_id AS 'GH ID',\n clients.NAME AS 'ΕΠΩΝΥΜΙΑ',\n clients.vat_id AS 'ΑΦΜ',\n clients.code AS 'ΚΩΔ',\n clients.address AS 'ΔΙΕΥΘΥΝΣΗ',\n property_groups.name AS 'GROUP',\n #order_items.product_id,\n products.name AS 'ΠΡΟΪΟΝ',\n ROUND(order_items.price, 2) AS 'ΤΙΜΗ',\n CONCAT(order_items.discount,' ','%') AS 'ΕΚΠΤΩΣΗ',\n SUM(order_items.quantity) AS 'ΠΟΣΟΤΗΤΑ',\n ROUND(SUM(order_items.gross_value), 2) AS 'ΣΥΝΟΛΟ (χωρίς ΦΠΑ)',\n IF(order_items.is_gift, 'ΝΑΙ', 'ΟΧΙ') AS 'ΔΩΡΟ',\n suppliers.name AS 'ΠΡΟΜΗΘΕΥΤΗΣ'\n FROM\n order_items\n LEFT JOIN orders ON order_items.order_id = orders.id \n LEFT JOIN products ON order_items.product_id = products.id\n LEFT JOIN businesses AS clients ON orders.client_id = clients.id \n LEFT JOIN businesses AS suppliers ON orders.business_id = suppliers.id \n LEFT JOIN property_groups ON clients.property_group_id = property_groups.id \n WHERE\n orders.property_id = :property_id\n AND orders.cancelled_date IS NULL \n #AND clients.vat_id = '997469046'\n #AND orders.business_id = 6791\n AND DATE_FORMAT(CONVERT_TZ(orders.created,'+00:00','+02:00'), '%Y-%m-%d') BETWEEN :fromd AND :tod\n GROUP BY\n order_items.is_gift, products.id, clients.id, suppliers.id\n ORDER BY\n clients.name ASC;\n { fromd: '2023-02-08', tod: '2023-08-08', property_id: undefined }","time":"2023-08-08T11:29:04.898Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Report.getProductsPerClient RestError [InternalError]: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n at Report.query (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:105:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async Report.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\repositories\\Report.js:94:29)\n at async ReportsService.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\services\\ReportsService.js:24:26)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\routes\\ReportsRouter.js:52:28 {\n jse_shortmsg: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n jse_info: {},\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n body: {\n code: 'Internal',\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\"\n }\n}","time":"2023-08-08T11:29:04.905Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"ReportsService.getProductsPerClient RestError [InternalError]: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n at Report.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\repositories\\Report.js:101:91)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n jse_info: {},\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n body: {\n code: 'Internal',\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\"\n }\n}","time":"2023-08-08T11:29:04.907Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'client' } \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-08-08T11:30:20.876Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-08-08T11:30:20.880Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'client' }","time":"2023-08-08T11:30:20.881Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-08-08T11:30:20.882Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'supplier' } \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-08-08T11:30:22.156Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-08-08T11:30:22.161Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'supplier' }","time":"2023-08-08T11:30:22.163Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-08-08T11:30:22.164Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'client' } \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-08-08T12:43:55.030Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'client' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-08-08T12:43:55.039Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'client' }","time":"2023-08-08T12:43:55.040Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-08-08T12:43:55.041Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Business.containModels 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 ':business_type)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':business_type)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(businesses.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = businesses.supplier_id) LEFT JOIN property_groups ON (property_groups.id = businesses.property_group_id) LEFT JOIN properties ON (properties.id = businesses.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.business_type = :business_type)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_type)' at line 4\"\n} { business_type: 'supplier' } \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-08-08T12:43:56.353Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: null { business_type: 'supplier' } [ '*' ] {\n suppliers: [ 'id', 'name' ],\n property_groups: [ 'id', 'name' ],\n properties: [ 'id', 'name' ]\n} count undefined","time":"2023-08-08T12:43:56.356Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"msg":"BusinessesService.getTotal RestError [InternalError]: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_type)' at line 4\",\n jse_info: {},\n message: \"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 ':business_type)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_type)' at line 4\"\n }\n} \nParams: No property { business_type: 'supplier' }","time":"2023-08-08T12:43:56.358Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":32276,"level":50,"err":{"message":"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 ':business_type)' at line 4","name":"InternalError","stack":"InternalError: 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 ':business_type)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':business_type)' at line 4","time":"2023-08-08T12:43:56.359Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Category.containModels 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 ':property_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Category.count (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:649:26)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async CategoriesService.getTotal (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:44:17)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:386:33 {\n message: \"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 ':property_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(categories.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM categories \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN properties ON (properties.id = categories.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (categories.property_id = :property_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':property_id)' at line 4\"\n} { property_id: '1' } \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2023-08-10T06:52:40.663Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Category.containModels RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2023-08-10T06:52:40.667Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"CategoriesService.getTotal RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: No property { property_id: '1' }","time":"2023-08-10T06:52:40.668Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"err":{"message":"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 ':property_id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':property_id)' at line 4","time":"2023-08-10T06:52:40.670Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Product.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Product.get (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:687:25)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async ProductsService.getSingle (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:73:18)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:158:20 {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT products.*, categories.id, categories.name, properties.id, properties.name\\n' +\n '\\t\\t\\t\\t\\tFROM products \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN categories ON (categories.id = products.category_id) LEFT JOIN properties ON (properties.id = products.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (products.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 53 } \nParams: null { id: 53 } null { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-10T06:52:40.674Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Product.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: null { id: 53 } null { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-10T06:52:40.675Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"ProductsService.getSingle RestError [InternalError]: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: 53 No property","time":"2023-08-10T06:52:40.675Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"err":{"message":"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 ':id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':id)' at line 4","time":"2023-08-10T06:52:40.676Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Category.containModels 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 ':property_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Category.count (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:649:26)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async CategoriesService.getTotal (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:44:17)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:386:33 {\n message: \"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 ':property_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(categories.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM categories \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN properties ON (properties.id = categories.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (categories.property_id = :property_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':property_id)' at line 4\"\n} { property_id: '1' } \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2023-08-10T06:52:50.953Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Category.containModels RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2023-08-10T06:52:50.956Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"CategoriesService.getTotal RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: No property { property_id: '1' }","time":"2023-08-10T06:52:50.957Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"err":{"message":"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 ':property_id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':property_id)' at line 4","time":"2023-08-10T06:52:50.958Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Product.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Product.get (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:687:25)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async ProductsService.getSingle (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:73:18)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:158:20 {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT products.*, categories.id, categories.name, properties.id, properties.name\\n' +\n '\\t\\t\\t\\t\\tFROM products \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN categories ON (categories.id = products.category_id) LEFT JOIN properties ON (properties.id = products.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (products.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 66 } \nParams: null { id: 66 } null { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-10T06:52:50.960Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Product.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: null { id: 66 } null { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-10T06:52:50.961Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"ProductsService.getSingle RestError [InternalError]: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: 66 No property","time":"2023-08-10T06:52:50.961Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"err":{"message":"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 ':id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':id)' at line 4","time":"2023-08-10T06:52:50.962Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Product.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Product.get (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:687:25)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async ProductsService.getSingle (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:73:18)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:158:20 {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT products.*, categories.id, categories.name, properties.id, properties.name\\n' +\n '\\t\\t\\t\\t\\tFROM products \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN categories ON (categories.id = products.category_id) LEFT JOIN properties ON (properties.id = products.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (products.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 66 } \nParams: null { id: 66 } null { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-10T07:11:34.753Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Product.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: null { id: 66 } null { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-10T07:12:40.250Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"ProductsService.getSingle RestError [InternalError]: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: 66 No property","time":"2023-08-10T07:12:40.265Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"err":{"message":"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 ':id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':id)' at line 4\n at Product.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':id)' at line 4","time":"2023-08-10T07:12:40.268Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Category.containModels 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 ':property_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Category.count (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:649:26)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async CategoriesService.getTotal (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:44:17)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:386:33 {\n message: \"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 ':property_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(categories.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM categories \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN properties ON (properties.id = categories.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (categories.property_id = :property_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':property_id)' at line 4\"\n} { property_id: '1' } \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2023-08-10T07:12:40.273Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"Category.containModels RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2023-08-10T07:12:40.278Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"msg":"CategoriesService.getTotal RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: No property { property_id: '1' }","time":"2023-08-10T07:12:40.280Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20680,"level":50,"err":{"message":"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 ':property_id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':property_id)' at line 4","time":"2023-08-10T07:12:40.283Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":26260,"level":50,"err":{"message":"Unknown database 'vikos_b2b_db1'","name":"Error","stack":"Error: Unknown database 'vikos_b2b_db1'\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_BAD_DB_ERROR"},"msg":"Unknown database 'vikos_b2b_db1'","time":"2023-08-10T07:46:06.283Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":26260,"level":50,"msg":"Product.count RestError [InternalError]: Unknown database 'vikos_b2b_db1'\n at Product.count (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:659:11)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"Unknown database 'vikos_b2b_db1'\",\n jse_info: {},\n message: \"Unknown database 'vikos_b2b_db1'\",\n body: { code: 'Internal', message: \"Unknown database 'vikos_b2b_db1'\" }\n} \nParams: null {} [ '*' ] { categories: [ 'id', 'name' ], properties: [ 'id', 'name' ] } undefined","time":"2023-08-10T07:46:09.144Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":26260,"level":50,"msg":"ProductsService.getTotal RestError [InternalError]: Unknown database 'vikos_b2b_db1'\n at Product.count (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:659:11)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"Unknown database 'vikos_b2b_db1'\",\n jse_info: {},\n message: \"Unknown database 'vikos_b2b_db1'\",\n body: { code: 'Internal', message: \"Unknown database 'vikos_b2b_db1'\" }\n} \nParams: No property {}","time":"2023-08-10T07:46:09.146Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":26260,"level":50,"err":{"message":"Unknown database 'vikos_b2b_db1'","name":"InternalError","stack":"InternalError: Unknown database 'vikos_b2b_db1'\n at Product.count (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:659:11)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"Unknown database 'vikos_b2b_db1'","time":"2023-08-10T07:46:09.147Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-08-30T11:43:20.202Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-08-30T11:48:01.913Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-08-30T11:48:01.913Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-08-30T11:48:02.051Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-08-30T11:48:02.054Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-08-30T11:48:02.056Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"BusinessSupplier.containModels 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 ':business_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at BusinessSupplier.findAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:612:26)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async UsersService.login (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\users\\services\\UsersService.js:63:39)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\users\\routes\\UsersRouter.js:78:18 {\n message: \"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 ':business_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT business_suppliers.*, suppliers.id, suppliers.name, suppliers.email, suppliers.vat_id, suppliers.gh_id, suppliers.tel, suppliers.mobile, suppliers.location, suppliers.code\\n' +\n '\\t\\t\\t\\t\\tFROM business_suppliers \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = business_suppliers.supplier_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (business_suppliers.business_id = :business_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_id)' at line 4\"\n} { business_id: 2044 } \nParams: 1 { business_id: 2044 } [ '*' ] {\n suppliers: [\n 'id', 'name',\n 'email', 'vat_id',\n 'gh_id', 'tel',\n 'mobile', 'location',\n 'code'\n ]\n} all undefined","time":"2023-08-30T11:48:02.059Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"BusinessSupplier.containModels RestError [InternalError]: 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 ':business_id)' at line 4\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_id)' at line 4\",\n jse_info: {},\n message: \"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 ':business_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_id)' at line 4\"\n }\n} \nParams: 1 { business_id: 2044 } [ '*' ] {\n suppliers: [\n 'id', 'name',\n 'email', 'vat_id',\n 'gh_id', 'tel',\n 'mobile', 'location',\n 'code'\n ]\n} all undefined","time":"2023-08-30T11:48:02.062Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':business_id)' at line 4\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_id)' at line 4\",\n jse_info: {},\n message: \"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 ':business_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_id)' at line 4\"\n }\n}","time":"2023-08-30T11:48:02.063Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"Report.query RestError [InternalError]: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n at Report.query (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:105:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async Report.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\repositories\\Report.js:94:29)\n at async ReportsService.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\services\\ReportsService.js:24:26)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\routes\\ReportsRouter.js:52:28 {\n jse_shortmsg: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n jse_info: {},\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n body: {\n code: 'Internal',\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\"\n }\n} \nParams: \n SELECT\n clients.gh_id AS 'GH ID',\n clients.NAME AS 'ΕΠΩΝΥΜΙΑ',\n clients.vat_id AS 'ΑΦΜ',\n clients.code AS 'ΚΩΔ',\n clients.address AS 'ΔΙΕΥΘΥΝΣΗ',\n property_groups.name AS 'GROUP',\n #order_items.product_id,\n products.name AS 'ΠΡΟΪΟΝ',\n ROUND(order_items.price, 2) AS 'ΤΙΜΗ',\n CONCAT(order_items.discount,' ','%') AS 'ΕΚΠΤΩΣΗ',\n SUM(order_items.quantity) AS 'ΠΟΣΟΤΗΤΑ',\n ROUND(SUM(order_items.gross_value), 2) AS 'ΣΥΝΟΛΟ (χωρίς ΦΠΑ)',\n IF(order_items.is_gift, 'ΝΑΙ', 'ΟΧΙ') AS 'ΔΩΡΟ',\n suppliers.name AS 'ΠΡΟΜΗΘΕΥΤΗΣ'\n FROM\n order_items\n LEFT JOIN orders ON order_items.order_id = orders.id \n LEFT JOIN products ON order_items.product_id = products.id\n LEFT JOIN businesses AS clients ON orders.client_id = clients.id \n LEFT JOIN businesses AS suppliers ON orders.business_id = suppliers.id \n LEFT JOIN property_groups ON clients.property_group_id = property_groups.id \n WHERE\n orders.property_id = :property_id\n AND orders.cancelled_date IS NULL \n #AND clients.vat_id = '997469046'\n #AND orders.business_id = 6791\n AND DATE_FORMAT(CONVERT_TZ(orders.created,'+00:00','+02:00'), '%Y-%m-%d') BETWEEN :fromd AND :tod\n GROUP BY\n order_items.is_gift, products.id, clients.id, suppliers.id\n ORDER BY\n clients.name ASC;\n { fromd: '2023-02-28', tod: '2023-08-30', property_id: undefined }","time":"2023-08-30T12:09:01.999Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"Report.getProductsPerClient RestError [InternalError]: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n at Report.query (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:105:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async Report.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\repositories\\Report.js:94:29)\n at async ReportsService.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\services\\ReportsService.js:24:26)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\routes\\ReportsRouter.js:52:28 {\n jse_shortmsg: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n jse_info: {},\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n body: {\n code: 'Internal',\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\"\n }\n}","time":"2023-08-30T12:09:02.004Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"ReportsService.getProductsPerClient RestError [InternalError]: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n at Report.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\repositories\\Report.js:101:91)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n jse_info: {},\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n body: {\n code: 'Internal',\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\"\n }\n}","time":"2023-08-30T12:09:02.006Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"Report.query RestError [InternalError]: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n at Report.query (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:105:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async Report.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\repositories\\Report.js:94:29)\n at async ReportsService.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\services\\ReportsService.js:24:26)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\routes\\ReportsRouter.js:52:28 {\n jse_shortmsg: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n jse_info: {},\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n body: {\n code: 'Internal',\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\"\n }\n} \nParams: \n SELECT\n clients.gh_id AS 'GH ID',\n clients.NAME AS 'ΕΠΩΝΥΜΙΑ',\n clients.vat_id AS 'ΑΦΜ',\n clients.code AS 'ΚΩΔ',\n clients.address AS 'ΔΙΕΥΘΥΝΣΗ',\n property_groups.name AS 'GROUP',\n #order_items.product_id,\n products.name AS 'ΠΡΟΪΟΝ',\n ROUND(order_items.price, 2) AS 'ΤΙΜΗ',\n CONCAT(order_items.discount,' ','%') AS 'ΕΚΠΤΩΣΗ',\n SUM(order_items.quantity) AS 'ΠΟΣΟΤΗΤΑ',\n ROUND(SUM(order_items.gross_value), 2) AS 'ΣΥΝΟΛΟ (χωρίς ΦΠΑ)',\n IF(order_items.is_gift, 'ΝΑΙ', 'ΟΧΙ') AS 'ΔΩΡΟ',\n suppliers.name AS 'ΠΡΟΜΗΘΕΥΤΗΣ'\n FROM\n order_items\n LEFT JOIN orders ON order_items.order_id = orders.id \n LEFT JOIN products ON order_items.product_id = products.id\n LEFT JOIN businesses AS clients ON orders.client_id = clients.id \n LEFT JOIN businesses AS suppliers ON orders.business_id = suppliers.id \n LEFT JOIN property_groups ON clients.property_group_id = property_groups.id \n WHERE\n orders.property_id = :property_id\n AND orders.cancelled_date IS NULL \n #AND clients.vat_id = '997469046'\n #AND orders.business_id = 6791\n AND DATE_FORMAT(CONVERT_TZ(orders.created,'+00:00','+02:00'), '%Y-%m-%d') BETWEEN :fromd AND :tod\n GROUP BY\n order_items.is_gift, products.id, clients.id, suppliers.id\n ORDER BY\n clients.name ASC;\n { fromd: '2023-02-28', tod: '2023-08-30', property_id: undefined }","time":"2023-08-30T12:09:19.931Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"Report.getProductsPerClient RestError [InternalError]: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n at Report.query (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:105:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async Report.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\repositories\\Report.js:94:29)\n at async ReportsService.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\services\\ReportsService.js:24:26)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\routes\\ReportsRouter.js:52:28 {\n jse_shortmsg: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n jse_info: {},\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n body: {\n code: 'Internal',\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\"\n }\n}","time":"2023-08-30T12:09:19.934Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"ReportsService.getProductsPerClient RestError [InternalError]: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\n at Report.getProductsPerClient (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\reports\\repositories\\Report.js:101:91)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n jse_info: {},\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\",\n body: {\n code: 'Internal',\n message: \"Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vikos_b2b_db.order_items.price' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\"\n }\n}","time":"2023-08-30T12:09:19.936Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"BusinessSupplier.containModels 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 ':business_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at BusinessSupplier.findAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:612:26)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async UsersService.login (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\users\\services\\UsersService.js:63:39)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\users\\routes\\UsersRouter.js:78:18 {\n message: \"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 ':business_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT business_suppliers.*, suppliers.id, suppliers.name, suppliers.email, suppliers.vat_id, suppliers.gh_id, suppliers.tel, suppliers.mobile, suppliers.location, suppliers.code\\n' +\n '\\t\\t\\t\\t\\tFROM business_suppliers \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = business_suppliers.supplier_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (business_suppliers.business_id = :business_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_id)' at line 4\"\n} { business_id: 2044 } \nParams: 1 { business_id: 2044 } [ '*' ] {\n suppliers: [\n 'id', 'name',\n 'email', 'vat_id',\n 'gh_id', 'tel',\n 'mobile', 'location',\n 'code'\n ]\n} all undefined","time":"2023-08-30T12:09:48.816Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"BusinessSupplier.containModels RestError [InternalError]: 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 ':business_id)' at line 4\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_id)' at line 4\",\n jse_info: {},\n message: \"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 ':business_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_id)' at line 4\"\n }\n} \nParams: 1 { business_id: 2044 } [ '*' ] {\n suppliers: [\n 'id', 'name',\n 'email', 'vat_id',\n 'gh_id', 'tel',\n 'mobile', 'location',\n 'code'\n ]\n} all undefined","time":"2023-08-30T12:09:48.818Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':business_id)' at line 4\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_id)' at line 4\",\n jse_info: {},\n message: \"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 ':business_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_id)' at line 4\"\n }\n}","time":"2023-08-30T12:09:48.819Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"BusinessSupplier.containModels 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 ':business_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at BusinessSupplier.findAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:612:26)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async UsersService.login (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\users\\services\\UsersService.js:63:39)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\users\\routes\\UsersRouter.js:78:18 {\n message: \"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 ':business_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT business_suppliers.*, suppliers.id, suppliers.name, suppliers.email, suppliers.vat_id, suppliers.gh_id, suppliers.tel, suppliers.mobile, suppliers.location, suppliers.code\\n' +\n '\\t\\t\\t\\t\\tFROM business_suppliers \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = business_suppliers.supplier_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (business_suppliers.business_id = :business_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_id)' at line 4\"\n} { business_id: 2044 } \nParams: 1 { business_id: 2044 } [ '*' ] {\n suppliers: [\n 'id', 'name',\n 'email', 'vat_id',\n 'gh_id', 'tel',\n 'mobile', 'location',\n 'code'\n ]\n} all undefined","time":"2023-08-30T12:10:00.292Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"BusinessSupplier.containModels RestError [InternalError]: 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 ':business_id)' at line 4\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_id)' at line 4\",\n jse_info: {},\n message: \"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 ':business_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_id)' at line 4\"\n }\n} \nParams: 1 { business_id: 2044 } [ '*' ] {\n suppliers: [\n 'id', 'name',\n 'email', 'vat_id',\n 'gh_id', 'tel',\n 'mobile', 'location',\n 'code'\n ]\n} all undefined","time":"2023-08-30T12:10:00.294Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':business_id)' at line 4\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_id)' at line 4\",\n jse_info: {},\n message: \"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 ':business_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_id)' at line 4\"\n }\n}","time":"2023-08-30T12:10:00.294Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"Order.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Order.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT orders.*, (orders.total - (orders.total * (orders.discount / 100))) AS total, businesses.*, clients.*, properties.id, properties.name\\n' +\n '\\t\\t\\t\\t\\tFROM orders \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses ON (businesses.id = orders.business_id) LEFT JOIN businesses AS clients ON (clients.id = orders.client_id) LEFT JOIN properties ON (properties.id = orders.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (orders.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2535 } \nParams: null { id: 2535 } [\n '*',\n '(orders.total - (orders.total * (orders.discount / 100))) AS total'\n] { businesses: [ '*' ], clients: [ '*' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-31T12:31:55.420Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"Order.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Order.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: null { id: 2535 } [\n '*',\n '(orders.total - (orders.total * (orders.discount / 100))) AS total'\n] { businesses: [ '*' ], clients: [ '*' ], properties: [ 'id', 'name' ] } all undefined","time":"2023-08-31T12:31:55.423Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24872,"level":50,"msg":"OrdersService.getSingle RestError [InternalError]: 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 ':id)' at line 4\n at Order.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-08-31T12:31:55.424Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20780,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T09:20:16.979Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20780,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T09:26:06.446Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20780,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T09:26:06.449Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20780,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T09:26:06.562Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20780,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T09:26:06.564Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20780,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T09:26:06.566Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":26564,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:07:57.630Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":26564,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:07:57.634Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":26564,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T10:07:57.635Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":21912,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:10:54.137Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":21912,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:10:54.141Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":21912,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T10:10:54.142Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":21912,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:11:44.829Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":21912,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:11:51.892Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":21912,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T10:11:51.899Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":13004,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:12:15.849Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":13004,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:12:15.852Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":13004,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T10:12:15.853Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20148,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:13:46.138Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20148,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:13:46.141Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20148,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T10:13:46.142Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20636,"level":50,"err":{"message":"Access denied for user 'root'@'localhost' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'localhost' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:22:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'localhost' (using password: YES)","time":"2023-09-15T10:16:44.083Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":5332,"level":50,"err":{"message":"Access denied for user 'root'@'localhost' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'localhost' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:23:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'localhost' (using password: YES)","time":"2023-09-15T10:16:50.955Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":15376,"level":50,"err":{"message":"Access denied for user 'root'@'localhost' (using password: YES)","name":"Error","stack":"Error: Access denied for user 'root'@'localhost' (using password: YES)\n at PromisePool.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:341:22)\n at Application.start (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\Application.js:23:25)\n at Object. (C:\\Sites\\vikos\\vikosb2b_api\\index.js:18:3)\n at Module._compile (internal/modules/cjs/loader.js:1157:30)\n at Object.Module._extensions..js (internal/modules/cjs/loader.js:1177:10)\n at Module.load (internal/modules/cjs/loader.js:1001:32)\n at Function.Module._load (internal/modules/cjs/loader.js:900:14)\n at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)\n at internal/main/run_main_module.js:18:47","code":"ER_ACCESS_DENIED_ERROR"},"msg":"Access denied for user 'root'@'localhost' (using password: YES)","time":"2023-09-15T10:18:14.180Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":23524,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:18:47.513Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":23524,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:18:47.517Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":23524,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T10:18:47.518Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":23524,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:19:15.006Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":23524,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:19:15.010Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":23524,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T10:19:15.011Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":23524,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:19:51.599Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":23524,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:19:51.603Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":23524,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T10:19:51.604Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24784,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:21:11.852Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24784,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:21:11.855Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24784,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T10:21:11.857Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24784,"level":50,"msg":"Business.containModels 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 ':id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n message: \"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 ':id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT businesses.*\\n' +\n '\\t\\t\\t\\t\\tFROM businesses \\n' +\n '\\t\\t\\t\\t\\t\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (businesses.id = :id)',\n sqlState: '42000',\n sqlMessage: \"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 ':id)' at line 4\"\n} { id: 2044 } \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:21:23.696Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24784,"level":50,"msg":"Business.containModels RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n} \nParams: undefined { id: 2044 } undefined undefined all undefined","time":"2023-09-15T10:21:23.701Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":24784,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':id)' at line 4\n at Business.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':id)' at line 4\",\n jse_info: {},\n message: \"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 ':id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':id)' at line 4\"\n }\n}","time":"2023-09-15T10:21:23.702Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":35672,"level":50,"msg":"Category.containModels 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 ':property_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at Category.count (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:649:26)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async CategoriesService.getTotal (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:44:17)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\products\\routes\\ProductsRouter.js:386:33 {\n message: \"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 ':property_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT COUNT(categories.id) AS total\\n' +\n '\\t\\t\\t\\t\\tFROM categories \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN properties ON (properties.id = categories.property_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (categories.property_id = :property_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':property_id)' at line 4\"\n} { property_id: '1' } \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2024-01-18T15:03:25.870Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":35672,"level":50,"msg":"Category.containModels RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: null { property_id: '1' } [ '*' ] { properties: [ 'id', 'name' ] } count undefined","time":"2024-01-18T15:03:25.875Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":35672,"level":50,"msg":"CategoriesService.getTotal RestError [InternalError]: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':property_id)' at line 4\",\n jse_info: {},\n message: \"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 ':property_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':property_id)' at line 4\"\n }\n} \nParams: No property { property_id: '1' }","time":"2024-01-18T15:03:25.876Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":35672,"level":50,"err":{"message":"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 ':property_id)' at line 4","name":"InternalError","stack":"InternalError: 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 ':property_id)' at line 4\n at Category.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)","code":"Error"},"msg":"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 ':property_id)' at line 4","time":"2024-01-18T15:03:25.877Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":35672,"level":50,"msg":"BusinessSupplier.containModels 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 ':business_id)' at line 4\n at PromisePoolConnection.query (C:\\Sites\\vikos\\vikosb2b_api\\node_modules\\mysql2\\promise.js:93:22)\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:440:47)\n at BusinessSupplier.findAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:612:26)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async UsersService.login (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\users\\services\\UsersService.js:63:39)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\users\\routes\\UsersRouter.js:78:18 {\n message: \"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 ':business_id)' at line 4\",\n code: 'ER_PARSE_ERROR',\n errno: 1064,\n sql: 'SELECT business_suppliers.*, suppliers.id, suppliers.name, suppliers.email, suppliers.vat_id, suppliers.gh_id, suppliers.tel, suppliers.mobile, suppliers.location, suppliers.code\\n' +\n '\\t\\t\\t\\t\\tFROM business_suppliers \\n' +\n '\\t\\t\\t\\t\\tLEFT JOIN businesses AS suppliers ON (suppliers.id = business_suppliers.supplier_id)\\n' +\n '\\t\\t\\t\\t\\t WHERE 1 = 1 AND (business_suppliers.business_id = :business_id)',\n sqlState: '42000',\n sqlMessage: \"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 ':business_id)' at line 4\"\n} { business_id: 2044 } \nParams: 1 { business_id: 2044 } [ '*' ] {\n suppliers: [\n 'id', 'name',\n 'email', 'vat_id',\n 'gh_id', 'tel',\n 'mobile', 'location',\n 'code'\n ]\n} all undefined","time":"2024-01-18T15:04:15.038Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":35672,"level":50,"msg":"BusinessSupplier.containModels RestError [InternalError]: 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 ':business_id)' at line 4\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_id)' at line 4\",\n jse_info: {},\n message: \"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 ':business_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_id)' at line 4\"\n }\n} \nParams: 1 { business_id: 2044 } [ '*' ] {\n suppliers: [\n 'id', 'name',\n 'email', 'vat_id',\n 'gh_id', 'tel',\n 'mobile', 'location',\n 'code'\n ]\n} all undefined","time":"2024-01-18T15:04:15.040Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":35672,"level":50,"msg":"UsersService.login RestError [InternalError]: 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 ':business_id)' at line 4\n at BusinessSupplier.containModels (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:489:23)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: \"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 ':business_id)' at line 4\",\n jse_info: {},\n message: \"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 ':business_id)' at line 4\",\n body: {\n code: 'Internal',\n message: \"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 ':business_id)' at line 4\"\n }\n}","time":"2024-01-18T15:04:15.041Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":22824,"level":50,"msg":"Order.insert RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.insert (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:934:11)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: {\n total: 32.9688,\n total_products: 26,\n items: [\n {\n discount: 0,\n gift_type: null,\n price: 0,\n gift_title: null,\n gift_id: null,\n quantity: 7,\n product_id: 53,\n step: 1,\n prev_quantity: 7,\n gift_quantity: null\n },\n {\n discount: 28,\n gift_type: 'discount',\n price: 2.41,\n gift_title: 'Έκπτωση 28% (αναψυκτικά 0,33L)',\n gift_id: 5,\n quantity: 14,\n product_id: 66,\n step: 1,\n prev_quantity: 14,\n gift_quantity: null\n },\n {\n discount: 28,\n gift_type: 'discount',\n price: 2.41,\n gift_title: 'Έκπτωση 28% (αναψυκτικά 0,33L)',\n gift_id: 5,\n quantity: 5,\n product_id: 60,\n step: 1,\n prev_quantity: 5,\n gift_quantity: null\n }\n ],\n discount: 0,\n business_id: 2044\n} 1 null","time":"2024-05-28T10:59:38.561Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":22824,"level":50,"msg":"Order.saveDeep RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: [\n {\n total: 32.9688,\n total_products: 26,\n items: [ [Object], [Object], [Object] ],\n discount: 0,\n business_id: 2044\n }\n] 1","time":"2024-05-28T10:59:38.568Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":22824,"level":50,"msg":"OrdersService.saveAll RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n}","time":"2024-05-28T10:59:38.568Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":22824,"level":50,"msg":"Order.insert RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.insert (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:934:11)\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: {\n total: 32.9688,\n total_products: 26,\n items: [\n {\n discount: 0,\n gift_type: null,\n price: 0,\n gift_title: null,\n gift_id: null,\n quantity: 7,\n product_id: 53,\n step: 1,\n prev_quantity: 7,\n gift_quantity: null\n },\n {\n discount: 28,\n gift_type: 'discount',\n price: 2.41,\n gift_title: 'Έκπτωση 28% (αναψυκτικά 0,33L)',\n gift_id: 5,\n quantity: 14,\n product_id: 66,\n step: 1,\n prev_quantity: 14,\n gift_quantity: null\n },\n {\n discount: 28,\n gift_type: 'discount',\n price: 2.41,\n gift_title: 'Έκπτωση 28% (αναψυκτικά 0,33L)',\n gift_id: 5,\n quantity: 5,\n product_id: 60,\n step: 1,\n prev_quantity: 5,\n gift_quantity: null\n }\n ],\n discount: 0,\n business_id: 2044\n} 1 null","time":"2024-05-28T10:59:48.305Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":22824,"level":50,"msg":"Order.saveDeep RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: [\n {\n total: 32.9688,\n total_products: 26,\n items: [ [Object], [Object], [Object] ],\n discount: 0,\n business_id: 2044\n }\n] 1","time":"2024-05-28T10:59:48.309Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":22824,"level":50,"msg":"OrdersService.saveAll RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n}","time":"2024-05-28T10:59:48.310Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":22824,"level":50,"msg":"Order.insert RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.insert (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:934:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: {\n total: 32.9688,\n total_products: 26,\n items: [\n {\n discount: 0,\n gift_type: null,\n price: 0,\n gift_title: null,\n gift_id: null,\n quantity: 7,\n product_id: 53,\n step: 1,\n prev_quantity: 7,\n gift_quantity: null\n },\n {\n discount: 28,\n gift_type: 'discount',\n price: 2.41,\n gift_title: 'Έκπτωση 28% (αναψυκτικά 0,33L)',\n gift_id: 5,\n quantity: 14,\n product_id: 66,\n step: 1,\n prev_quantity: 14,\n gift_quantity: null\n },\n {\n discount: 28,\n gift_type: 'discount',\n price: 2.41,\n gift_title: 'Έκπτωση 28% (αναψυκτικά 0,33L)',\n gift_id: 5,\n quantity: 5,\n product_id: 60,\n step: 1,\n prev_quantity: 5,\n gift_quantity: null\n }\n ],\n discount: 0,\n business_id: 2044\n} 1 null","time":"2024-05-28T11:02:48.119Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":22824,"level":50,"msg":"Order.saveDeep RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: [\n {\n total: 32.9688,\n total_products: 26,\n items: [ [Object], [Object], [Object] ],\n discount: 0,\n business_id: 2044\n }\n] 1","time":"2024-05-28T11:02:48.123Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":22824,"level":50,"msg":"OrdersService.saveAll RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n}","time":"2024-05-28T11:02:48.124Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"Order.insert RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.insert (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:934:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: {\n total: 10.411200000000001,\n total_products: 16,\n items: [\n {\n discount: 0,\n gift_type: null,\n price: 0,\n gift_title: null,\n gift_id: null,\n quantity: 10,\n product_id: 53,\n step: 1,\n prev_quantity: 10,\n gift_quantity: null\n },\n {\n discount: 28,\n gift_type: 'discount',\n price: 2.41,\n gift_title: 'Έκπτωση 28% (αναψυκτικά 0,33L)',\n gift_id: 5,\n quantity: 6,\n product_id: 66,\n step: 1,\n prev_quantity: 6,\n gift_quantity: null\n }\n ],\n business_id: 2044\n} 1 null","time":"2024-09-13T08:36:18.887Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"Order.saveDeep RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: [\n {\n total: 10.411200000000001,\n total_products: 16,\n items: [ [Object], [Object] ],\n business_id: 2044\n }\n] 1","time":"2024-09-13T08:36:18.895Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"OrdersService.saveAll RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n}","time":"2024-09-13T08:36:18.895Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"Order.insert RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.insert (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:934:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: {\n total: 63.89,\n total_products: 39,\n items: [\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 8,\n product_id: 66,\n step: 1,\n prev_quantity: 8,\n gift_quantity: 4\n },\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 4,\n product_id: 60,\n step: 1,\n prev_quantity: 4,\n gift_quantity: 2\n },\n {\n discount: 0,\n gift_type: null,\n price: 1.1,\n gift_title: null,\n gift_id: null,\n quantity: 7,\n product_id: 52,\n step: 1,\n prev_quantity: 7,\n gift_quantity: null\n },\n {\n discount: 0,\n gift_type: null,\n price: 2.6,\n gift_title: null,\n gift_id: null,\n quantity: 4,\n product_id: 55,\n step: 1,\n prev_quantity: 4,\n gift_quantity: null\n },\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 7,\n product_id: 63,\n step: 1,\n prev_quantity: 7,\n gift_quantity: 3\n },\n { product_id: 53, price: 0, quantity: 4, is_gift: true },\n { product_id: 53, price: 0, quantity: 2, is_gift: true },\n { product_id: 53, price: 0, quantity: 3, is_gift: true }\n ],\n business_id: 2044\n} 1 null","time":"2024-09-13T08:38:46.286Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"Order.saveDeep RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: [\n {\n total: 63.89,\n total_products: 39,\n items: [\n [Object], [Object],\n [Object], [Object],\n [Object], [Object],\n [Object], [Object]\n ],\n business_id: 2044\n }\n] 1","time":"2024-09-13T08:38:46.290Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"OrdersService.saveAll RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n}","time":"2024-09-13T08:38:46.291Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"Order.insert RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.insert (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:934:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: {\n total: 63.89,\n total_products: 39,\n items: [\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 8,\n product_id: 66,\n step: 1,\n prev_quantity: 8,\n gift_quantity: 4\n },\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 4,\n product_id: 60,\n step: 1,\n prev_quantity: 4,\n gift_quantity: 2\n },\n {\n discount: 0,\n gift_type: null,\n price: 1.1,\n gift_title: null,\n gift_id: null,\n quantity: 7,\n product_id: 52,\n step: 1,\n prev_quantity: 7,\n gift_quantity: null\n },\n {\n discount: 0,\n gift_type: null,\n price: 2.6,\n gift_title: null,\n gift_id: null,\n quantity: 4,\n product_id: 55,\n step: 1,\n prev_quantity: 4,\n gift_quantity: null\n },\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 7,\n product_id: 63,\n step: 1,\n prev_quantity: 7,\n gift_quantity: 3\n },\n { product_id: 53, price: 0, quantity: 4, is_gift: true },\n { product_id: 53, price: 0, quantity: 2, is_gift: true },\n { product_id: 53, price: 0, quantity: 3, is_gift: true }\n ],\n business_id: 6221\n} 1 null","time":"2024-09-13T08:38:55.660Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"Order.saveDeep RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: [\n {\n total: 63.89,\n total_products: 39,\n items: [\n [Object], [Object],\n [Object], [Object],\n [Object], [Object],\n [Object], [Object]\n ],\n business_id: 6221\n }\n] 1","time":"2024-09-13T08:38:55.666Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"OrdersService.saveAll RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n}","time":"2024-09-13T08:38:55.667Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"Order.insert RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.insert (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:934:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: {\n total: 63.89,\n total_products: 39,\n items: [\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 8,\n product_id: 66,\n step: 1,\n prev_quantity: 8,\n gift_quantity: 4\n },\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 4,\n product_id: 60,\n step: 1,\n prev_quantity: 4,\n gift_quantity: 2\n },\n {\n discount: 0,\n gift_type: null,\n price: 1.1,\n gift_title: null,\n gift_id: null,\n quantity: 7,\n product_id: 52,\n step: 1,\n prev_quantity: 7,\n gift_quantity: null\n },\n {\n discount: 0,\n gift_type: null,\n price: 2.6,\n gift_title: null,\n gift_id: null,\n quantity: 4,\n product_id: 55,\n step: 1,\n prev_quantity: 4,\n gift_quantity: null\n },\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 7,\n product_id: 63,\n step: 1,\n prev_quantity: 7,\n gift_quantity: 3\n },\n { product_id: 53, price: 0, quantity: 4, is_gift: true },\n { product_id: 53, price: 0, quantity: 2, is_gift: true },\n { product_id: 53, price: 0, quantity: 3, is_gift: true }\n ],\n business_id: 6221\n} 1 null","time":"2024-09-13T08:39:48.300Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"Order.saveDeep RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: [\n {\n total: 63.89,\n total_products: 39,\n items: [\n [Object], [Object],\n [Object], [Object],\n [Object], [Object],\n [Object], [Object]\n ],\n business_id: 6221\n }\n] 1","time":"2024-09-13T08:39:48.304Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"OrdersService.saveAll RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n}","time":"2024-09-13T08:39:48.305Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"Order.insert RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.insert (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:934:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5) {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: {\n total: 63.89,\n total_products: 39,\n items: [\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 8,\n product_id: 66,\n step: 1,\n prev_quantity: 8,\n gift_quantity: 4\n },\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 4,\n product_id: 60,\n step: 1,\n prev_quantity: 4,\n gift_quantity: 2\n },\n {\n discount: 0,\n gift_type: null,\n price: 1.1,\n gift_title: null,\n gift_id: null,\n quantity: 7,\n product_id: 52,\n step: 1,\n prev_quantity: 7,\n gift_quantity: null\n },\n {\n discount: 0,\n gift_type: null,\n price: 2.6,\n gift_title: null,\n gift_id: null,\n quantity: 4,\n product_id: 55,\n step: 1,\n prev_quantity: 4,\n gift_quantity: null\n },\n {\n discount: 0,\n gift_type: 'product',\n price: 2.41,\n gift_title: 'Δώρο νερό 24-Pack',\n gift_id: 3,\n quantity: 7,\n product_id: 63,\n step: 1,\n prev_quantity: 7,\n gift_quantity: 3\n },\n { product_id: 53, price: 0, quantity: 4, is_gift: true },\n { product_id: 53, price: 0, quantity: 2, is_gift: true },\n { product_id: 53, price: 0, quantity: 3, is_gift: true }\n ],\n business_id: 6221\n} 1 null","time":"2024-09-13T08:40:58.302Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"Order.saveDeep RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n} \nParams: [\n {\n total: 63.89,\n total_products: 39,\n items: [\n [Object], [Object],\n [Object], [Object],\n [Object], [Object],\n [Object], [Object]\n ],\n business_id: 6221\n }\n] 1","time":"2024-09-13T08:40:58.306Z","v":0} {"name":"VikosB2B Logger","hostname":"DESKTOP-G23F4LV","pid":20484,"level":50,"msg":"OrdersService.saveAll RestError [InternalError]: Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.\n at Order.saveDeep (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_repository.js:1321:11)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:97:5)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\infra\\database\\models\\base_service.js:104:27)\n at async OrdersService.saveAll (C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\services\\OrdersService.js:109:28)\n at async C:\\Sites\\vikos\\vikosb2b_api\\src\\app\\orders\\routes\\OrdersRouter.js:303:23 {\n jse_shortmsg: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n jse_info: {},\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.',\n body: {\n code: 'Internal',\n message: 'Παρακαλώ ολοκληρώστε τις ανοιχτές παραγγελίες σας σε κατάσταση ¨παραλήφθηκε¨ ώστε να μπορέσετε να παραγγείλετε ξανά.'\n }\n}","time":"2024-09-13T08:40:58.306Z","v":0}