{ "errorId": "ERR_1760346277200_4k8hn9b9b", "timestamp": "2025-10-13T09:04:37.200Z", "message": "Cannot read properties of undefined (reading 'findOne')", "stack": "TypeError: Cannot read properties of undefined (reading 'findOne')\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\quickSaleRoutes.js:196:39\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)", "name": "TypeError", "context": { "endpoint": "POST /api/v1/quick-sales", "requestBody": { "branchId": 1, "items": [ { "id": "PROD-001", "type": "product", "code": "PROD-001", "name": "مكابح أمامية تويوتا كامري", "price": 650, "quantity": 1, "discount": 0, "total": 650 }, { "id": "PROD-002", "type": "product", "code": "PROD-002", "name": "فلتر هواء هيونداي إلنترا", "price": 125, "quantity": 1, "discount": 0, "total": 125 }, { "id": "3", "type": "service", "code": "SVC-003", "name": "تغيير الإطارات", "price": 100, "quantity": 1, "discount": 0, "total": 100 }, { "id": "1", "type": "service", "code": "SVC-001", "name": "تغيير الزيت", "price": 150, "quantity": 1, "discount": 0, "total": 150 } ], "subtotal": 1025, "discountAmount": 0, "discountPercentage": 0, "taxAmount": 153.75, "taxPercentage": 15, "totalAmount": 1178.75, "paymentMethod": "cash" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 78884864, "heapTotal": 40677376, "heapUsed": 34555024, "external": 2389581, "arrayBuffers": 71746 }, "uptime": 2051.760678 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760346277583_p2dno152i", "timestamp": "2025-10-13T09:04:37.583Z", "message": "Cannot read properties of undefined (reading 'findOne')", "stack": "TypeError: Cannot read properties of undefined (reading 'findOne')\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\quickSaleRoutes.js:196:39\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)", "name": "TypeError", "context": { "endpoint": "POST /api/v1/quick-sales", "requestBody": { "branchId": 1, "items": [ { "id": "PROD-001", "type": "product", "code": "PROD-001", "name": "مكابح أمامية تويوتا كامري", "price": 650, "quantity": 1, "discount": 0, "total": 650 }, { "id": "PROD-002", "type": "product", "code": "PROD-002", "name": "فلتر هواء هيونداي إلنترا", "price": 125, "quantity": 1, "discount": 0, "total": 125 }, { "id": "3", "type": "service", "code": "SVC-003", "name": "تغيير الإطارات", "price": 100, "quantity": 1, "discount": 0, "total": 100 }, { "id": "1", "type": "service", "code": "SVC-001", "name": "تغيير الزيت", "price": 150, "quantity": 1, "discount": 0, "total": 150 } ], "subtotal": 1025, "discountAmount": 0, "discountPercentage": 0, "taxAmount": 153.75, "taxPercentage": 15, "totalAmount": 1178.75, "paymentMethod": "cash" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 79933440, "heapTotal": 40415232, "heapUsed": 34435152, "external": 2389292, "arrayBuffers": 71417 }, "uptime": 2052.143083 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760346279196_2sfmb3k34", "timestamp": "2025-10-13T09:04:39.196Z", "message": "Cannot read properties of undefined (reading 'findOne')", "stack": "TypeError: Cannot read properties of undefined (reading 'findOne')\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\quickSaleRoutes.js:196:39\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)", "name": "TypeError", "context": { "endpoint": "POST /api/v1/quick-sales", "requestBody": { "branchId": 1, "items": [ { "id": "PROD-001", "type": "product", "code": "PROD-001", "name": "مكابح أمامية تويوتا كامري", "price": 650, "quantity": 1, "discount": 0, "total": 650 }, { "id": "PROD-002", "type": "product", "code": "PROD-002", "name": "فلتر هواء هيونداي إلنترا", "price": 125, "quantity": 1, "discount": 0, "total": 125 }, { "id": "3", "type": "service", "code": "SVC-003", "name": "تغيير الإطارات", "price": 100, "quantity": 1, "discount": 0, "total": 100 }, { "id": "1", "type": "service", "code": "SVC-001", "name": "تغيير الزيت", "price": 150, "quantity": 1, "discount": 0, "total": 150 } ], "subtotal": 1025, "discountAmount": 0, "discountPercentage": 0, "taxAmount": 153.75, "taxPercentage": 15, "totalAmount": 1178.75, "paymentMethod": "cash" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 79933440, "heapTotal": 40415232, "heapUsed": 34782976, "external": 2392233, "arrayBuffers": 74358 }, "uptime": 2053.7565117 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760346470054_4w6g1guo9", "timestamp": "2025-10-13T09:07:50.054Z", "message": "Table 'meta.service_consumables' doesn't exist", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async ServiceConsumables.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\quickSaleRoutes.js:275:36", "name": "SequelizeDatabaseError", "sql": "SELECT `ServiceConsumables`.`id`, `ServiceConsumables`.`service_id` AS `serviceId`, `ServiceConsumables`.`consumable_id` AS `consumableId`, `ServiceConsumables`.`quantity`, `ServiceConsumables`.`unit`, `ServiceConsumables`.`is_optional` AS `isOptional`, `ServiceConsumables`.`notes`, `ServiceConsumables`.`is_active` AS `isActive`, `ServiceConsumables`.`created_at` AS `createdAt`, `ServiceConsumables`.`updated_at` AS `updatedAt`, `consumable`.`id` AS `consumable.id`, `consumable`.`code` AS `consumable.code`, `consumable`.`categoryId` AS `consumable.categoryId`, `consumable`.`nameAr` AS `consumable.nameAr`, `consumable`.`nameEn` AS `consumable.nameEn`, `consumable`.`unitId` AS `consumable.unitId`, `consumable`.`isActive` AS `consumable.isActive`, `consumable`.`description` AS `consumable.description`, `consumable`.`consumptionRate` AS `consumable.consumptionRate`, `consumable`.`unitCost` AS `consumable.unitCost`, `consumable`.`warehouseId` AS `consumable.warehouseId`, `consumable`.`shelfLocation` AS `consumable.shelfLocation`, `consumable`.`currentStock` AS `consumable.currentStock`, `consumable`.`minStock` AS `consumable.minStock`, `consumable`.`maxStock` AS `consumable.maxStock`, `consumable`.`reorderPoint` AS `consumable.reorderPoint`, `consumable`.`supplierId` AS `consumable.supplierId`, `consumable`.`endDate` AS `consumable.endDate`, `consumable`.`batchNumber` AS `consumable.batchNumber`, `consumable`.`storageConditions` AS `consumable.storageConditions`, `consumable`.`attachmentImage` AS `consumable.attachmentImage`, `consumable`.`branchId` AS `consumable.branchId`, `consumable`.`brandId` AS `consumable.brandId` FROM `service_consumables` AS `ServiceConsumables` LEFT OUTER JOIN `Consumables` AS `consumable` ON `ServiceConsumables`.`consumable_id` = `consumable`.`id` WHERE `ServiceConsumables`.`service_id` = '3' AND `ServiceConsumables`.`is_active` = true;", "parameters": {}, "context": { "endpoint": "POST /api/v1/quick-sales", "requestBody": { "branchId": 1, "items": [ { "id": "PROD-001", "type": "product", "code": "PROD-001", "name": "مكابح أمامية تويوتا كامري", "price": 650, "quantity": 1, "discount": 0, "total": 650 }, { "id": "PROD-002", "type": "product", "code": "PROD-002", "name": "فلتر هواء هيونداي إلنترا", "price": 125, "quantity": 1, "discount": 0, "total": 125 }, { "id": "3", "type": "service", "code": "SVC-003", "name": "تغيير الإطارات", "price": 100, "quantity": 1, "discount": 0, "total": 100 }, { "id": "1", "type": "service", "code": "SVC-001", "name": "تغيير الزيت", "price": 150, "quantity": 1, "discount": 0, "total": 150 } ], "subtotal": 1025, "discountAmount": 0, "discountPercentage": 0, "taxAmount": 153.75, "taxPercentage": 15, "totalAmount": 1178.75, "paymentMethod": "cash" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 80216064, "heapTotal": 32026624, "heapUsed": 30342216, "external": 2365010, "arrayBuffers": 47175 }, "uptime": 76.1886646 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760346470825_4gzk1isvi", "timestamp": "2025-10-13T09:07:50.825Z", "message": "Table 'meta.service_consumables' doesn't exist", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async ServiceConsumables.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\quickSaleRoutes.js:275:36", "name": "SequelizeDatabaseError", "sql": "SELECT `ServiceConsumables`.`id`, `ServiceConsumables`.`service_id` AS `serviceId`, `ServiceConsumables`.`consumable_id` AS `consumableId`, `ServiceConsumables`.`quantity`, `ServiceConsumables`.`unit`, `ServiceConsumables`.`is_optional` AS `isOptional`, `ServiceConsumables`.`notes`, `ServiceConsumables`.`is_active` AS `isActive`, `ServiceConsumables`.`created_at` AS `createdAt`, `ServiceConsumables`.`updated_at` AS `updatedAt`, `consumable`.`id` AS `consumable.id`, `consumable`.`code` AS `consumable.code`, `consumable`.`categoryId` AS `consumable.categoryId`, `consumable`.`nameAr` AS `consumable.nameAr`, `consumable`.`nameEn` AS `consumable.nameEn`, `consumable`.`unitId` AS `consumable.unitId`, `consumable`.`isActive` AS `consumable.isActive`, `consumable`.`description` AS `consumable.description`, `consumable`.`consumptionRate` AS `consumable.consumptionRate`, `consumable`.`unitCost` AS `consumable.unitCost`, `consumable`.`warehouseId` AS `consumable.warehouseId`, `consumable`.`shelfLocation` AS `consumable.shelfLocation`, `consumable`.`currentStock` AS `consumable.currentStock`, `consumable`.`minStock` AS `consumable.minStock`, `consumable`.`maxStock` AS `consumable.maxStock`, `consumable`.`reorderPoint` AS `consumable.reorderPoint`, `consumable`.`supplierId` AS `consumable.supplierId`, `consumable`.`endDate` AS `consumable.endDate`, `consumable`.`batchNumber` AS `consumable.batchNumber`, `consumable`.`storageConditions` AS `consumable.storageConditions`, `consumable`.`attachmentImage` AS `consumable.attachmentImage`, `consumable`.`branchId` AS `consumable.branchId`, `consumable`.`brandId` AS `consumable.brandId` FROM `service_consumables` AS `ServiceConsumables` LEFT OUTER JOIN `Consumables` AS `consumable` ON `ServiceConsumables`.`consumable_id` = `consumable`.`id` WHERE `ServiceConsumables`.`service_id` = '3' AND `ServiceConsumables`.`is_active` = true;", "parameters": {}, "context": { "endpoint": "POST /api/v1/quick-sales", "requestBody": { "branchId": 1, "items": [ { "id": "PROD-001", "type": "product", "code": "PROD-001", "name": "مكابح أمامية تويوتا كامري", "price": 650, "quantity": 1, "discount": 0, "total": 650 }, { "id": "PROD-002", "type": "product", "code": "PROD-002", "name": "فلتر هواء هيونداي إلنترا", "price": 125, "quantity": 1, "discount": 0, "total": 125 }, { "id": "3", "type": "service", "code": "SVC-003", "name": "تغيير الإطارات", "price": 100, "quantity": 1, "discount": 0, "total": 100 }, { "id": "1", "type": "service", "code": "SVC-001", "name": "تغيير الزيت", "price": 150, "quantity": 1, "discount": 0, "total": 150 } ], "subtotal": 1025, "discountAmount": 0, "discountPercentage": 0, "taxAmount": 153.75, "taxPercentage": 15, "totalAmount": 1178.75, "paymentMethod": "cash" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 80744448, "heapTotal": 32026624, "heapUsed": 29917416, "external": 2359977, "arrayBuffers": 42102 }, "uptime": 76.9594711 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760346472532_pjotn5fue", "timestamp": "2025-10-13T09:07:52.532Z", "message": "Table 'meta.service_consumables' doesn't exist", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async ServiceConsumables.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\quickSaleRoutes.js:275:36", "name": "SequelizeDatabaseError", "sql": "SELECT `ServiceConsumables`.`id`, `ServiceConsumables`.`service_id` AS `serviceId`, `ServiceConsumables`.`consumable_id` AS `consumableId`, `ServiceConsumables`.`quantity`, `ServiceConsumables`.`unit`, `ServiceConsumables`.`is_optional` AS `isOptional`, `ServiceConsumables`.`notes`, `ServiceConsumables`.`is_active` AS `isActive`, `ServiceConsumables`.`created_at` AS `createdAt`, `ServiceConsumables`.`updated_at` AS `updatedAt`, `consumable`.`id` AS `consumable.id`, `consumable`.`code` AS `consumable.code`, `consumable`.`categoryId` AS `consumable.categoryId`, `consumable`.`nameAr` AS `consumable.nameAr`, `consumable`.`nameEn` AS `consumable.nameEn`, `consumable`.`unitId` AS `consumable.unitId`, `consumable`.`isActive` AS `consumable.isActive`, `consumable`.`description` AS `consumable.description`, `consumable`.`consumptionRate` AS `consumable.consumptionRate`, `consumable`.`unitCost` AS `consumable.unitCost`, `consumable`.`warehouseId` AS `consumable.warehouseId`, `consumable`.`shelfLocation` AS `consumable.shelfLocation`, `consumable`.`currentStock` AS `consumable.currentStock`, `consumable`.`minStock` AS `consumable.minStock`, `consumable`.`maxStock` AS `consumable.maxStock`, `consumable`.`reorderPoint` AS `consumable.reorderPoint`, `consumable`.`supplierId` AS `consumable.supplierId`, `consumable`.`endDate` AS `consumable.endDate`, `consumable`.`batchNumber` AS `consumable.batchNumber`, `consumable`.`storageConditions` AS `consumable.storageConditions`, `consumable`.`attachmentImage` AS `consumable.attachmentImage`, `consumable`.`branchId` AS `consumable.branchId`, `consumable`.`brandId` AS `consumable.brandId` FROM `service_consumables` AS `ServiceConsumables` LEFT OUTER JOIN `Consumables` AS `consumable` ON `ServiceConsumables`.`consumable_id` = `consumable`.`id` WHERE `ServiceConsumables`.`service_id` = '3' AND `ServiceConsumables`.`is_active` = true;", "parameters": {}, "context": { "endpoint": "POST /api/v1/quick-sales", "requestBody": { "branchId": 1, "items": [ { "id": "PROD-001", "type": "product", "code": "PROD-001", "name": "مكابح أمامية تويوتا كامري", "price": 650, "quantity": 1, "discount": 0, "total": 650 }, { "id": "PROD-002", "type": "product", "code": "PROD-002", "name": "فلتر هواء هيونداي إلنترا", "price": 125, "quantity": 1, "discount": 0, "total": 125 }, { "id": "3", "type": "service", "code": "SVC-003", "name": "تغيير الإطارات", "price": 100, "quantity": 1, "discount": 0, "total": 100 }, { "id": "1", "type": "service", "code": "SVC-001", "name": "تغيير الزيت", "price": 150, "quantity": 1, "discount": 0, "total": 150 } ], "subtotal": 1025, "discountAmount": 0, "discountPercentage": 0, "taxAmount": 153.75, "taxPercentage": 15, "totalAmount": 1178.75, "paymentMethod": "cash" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 80838656, "heapTotal": 32026624, "heapUsed": 30163760, "external": 2368221, "arrayBuffers": 50346 }, "uptime": 78.6658128 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760356056408_wg9g9s0ft", "timestamp": "2025-10-13T11:47:36.408Z", "message": "Unknown column 'Shift.shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getAllShifts (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:18:20)", "name": "SequelizeDatabaseError", "sql": "SELECT `Shift`.`id`, `Shift`.`shiftName`, `Shift`.`startTime`, `Shift`.`endTime`, `Shift`.`branchId`, `Shift`.`isActive`, `Shift`.`description`, `Shift`.`color`, `Shift`.`createdAt`, `Shift`.`updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `Shifts` AS `Shift` LEFT OUTER JOIN `Branches` AS `branch` ON `Shift`.`branchId` = `branch`.`id` ORDER BY `Shift`.`startTime` ASC;", "parameters": {}, "context": { "endpoint": "GET /api/shifts" }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 79896576, "heapTotal": 32026624, "heapUsed": 29014432, "external": 2343268, "arrayBuffers": 25433 }, "uptime": 165.4007547 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760356445387_135kijxxt", "timestamp": "2025-10-13T11:54:05.387Z", "message": "Unknown column 'shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Shift.findOne (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1240:12)\n at async exports.createShift (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:94:30)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `shiftName`, `startTime`, `endTime`, `branchId`, `isActive`, `description`, `color`, `createdAt`, `updatedAt` FROM `Shifts` AS `Shift` WHERE (`Shift`.`startTime` BETWEEN '08:00' AND '20:00' OR `Shift`.`endTime` BETWEEN '08:00' AND '20:00') AND `Shift`.`branchId` IS NULL AND `Shift`.`isActive` = true LIMIT 1;", "parameters": {}, "context": { "endpoint": "POST /api/shifts", "requestBody": { "shiftName": "الصباحيه", "startTime": "08:00", "endTime": "20:00", "branchId": null, "description": "بثيب", "color": "#10b981" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 79208448, "heapTotal": 32288768, "heapUsed": 29983912, "external": 2351932, "arrayBuffers": 34097 }, "uptime": 227.002277 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760356482712_63oquv991", "timestamp": "2025-10-13T11:54:42.712Z", "message": "Unknown column 'shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Shift.findOne (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1240:12)\n at async exports.createShift (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:94:30)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `shiftName`, `startTime`, `endTime`, `branchId`, `isActive`, `description`, `color`, `createdAt`, `updatedAt` FROM `Shifts` AS `Shift` WHERE (`Shift`.`startTime` BETWEEN '08:00' AND '20:00' OR `Shift`.`endTime` BETWEEN '08:00' AND '20:00') AND `Shift`.`branchId` = 1 AND `Shift`.`isActive` = true LIMIT 1;", "parameters": {}, "context": { "endpoint": "POST /api/shifts", "requestBody": { "shiftName": "الصباحيه", "startTime": "08:00", "endTime": "20:00", "branchId": 1, "description": "بثيب", "color": "#10b981" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 80191488, "heapTotal": 32026624, "heapUsed": 30776240, "external": 2352301, "arrayBuffers": 34426 }, "uptime": 264.3269977 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760356558243_4eily5w7k", "timestamp": "2025-10-13T11:55:58.243Z", "message": "Unknown column 'shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Shift.findOne (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1240:12)\n at async exports.createShift (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:94:30)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `shiftName`, `startTime`, `endTime`, `branchId`, `isActive`, `description`, `color`, `createdAt`, `updatedAt` FROM `Shifts` AS `Shift` WHERE (`Shift`.`startTime` BETWEEN '08:00' AND '20:00' OR `Shift`.`endTime` BETWEEN '08:00' AND '20:00') AND `Shift`.`branchId` = 1 AND `Shift`.`isActive` = true LIMIT 1;", "parameters": {}, "context": { "endpoint": "POST /api/shifts", "requestBody": { "shiftName": "الصباحيه", "startTime": "08:00", "endTime": "20:00", "branchId": 1, "description": "بثيب", "color": "#10b981" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 81264640, "heapTotal": 34123776, "heapUsed": 31453344, "external": 2352277, "arrayBuffers": 34402 }, "uptime": 339.8593106 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760356603776_x3969k5bu", "timestamp": "2025-10-13T11:56:43.776Z", "message": "Unknown column 'shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Shift.findOne (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1240:12)\n at async exports.createShift (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:94:30)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `shiftName`, `startTime`, `endTime`, `branchId`, `isActive`, `description`, `color`, `createdAt`, `updatedAt` FROM `Shifts` AS `Shift` WHERE (`Shift`.`startTime` BETWEEN '08:00' AND '20:00' OR `Shift`.`endTime` BETWEEN '08:00' AND '20:00') AND `Shift`.`branchId` = 1 AND `Shift`.`isActive` = true LIMIT 1;", "parameters": {}, "context": { "endpoint": "POST /api/shifts", "requestBody": { "shiftName": "الصباحيه", "startTime": "08:00", "endTime": "20:00", "branchId": 1, "description": "بثيب", "color": "#10b981" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 81858560, "heapTotal": 34648064, "heapUsed": 32131632, "external": 2352402, "arrayBuffers": 34527 }, "uptime": 385.39068 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760356914048_zb5avti1t", "timestamp": "2025-10-13T12:01:54.048Z", "message": "Unknown column 'shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Shift.findOne (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1240:12)\n at async exports.createShift (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:94:30)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `shiftName`, `startTime`, `endTime`, `branchId`, `isActive`, `description`, `color`, `createdAt`, `updatedAt` FROM `Shifts` AS `Shift` WHERE (`Shift`.`startTime` BETWEEN '08:00' AND '20:00' OR `Shift`.`endTime` BETWEEN '08:00' AND '20:00') AND `Shift`.`branchId` = 1 AND `Shift`.`isActive` = true LIMIT 1;", "parameters": {}, "context": { "endpoint": "POST /api/shifts", "requestBody": { "shiftName": "الصباحيه", "startTime": "08:00", "endTime": "20:00", "branchId": 1, "description": "بثيب", "color": "#10b981" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 81301504, "heapTotal": 34648064, "heapUsed": 33127464, "external": 2352527, "arrayBuffers": 34652 }, "uptime": 695.663513 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760356936790_8j1kg6gxn", "timestamp": "2025-10-13T12:02:16.790Z", "message": "Unknown column 'Shift.shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getAllShifts (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:18:20)", "name": "SequelizeDatabaseError", "sql": "SELECT `Shift`.`id`, `Shift`.`shiftName`, `Shift`.`startTime`, `Shift`.`endTime`, `Shift`.`branchId`, `Shift`.`isActive`, `Shift`.`description`, `Shift`.`color`, `Shift`.`createdAt`, `Shift`.`updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `Shifts` AS `Shift` LEFT OUTER JOIN `Branches` AS `branch` ON `Shift`.`branchId` = `branch`.`id` ORDER BY `Shift`.`startTime` ASC;", "parameters": {}, "context": { "endpoint": "GET /api/shifts" }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 82243584, "heapTotal": 36483072, "heapUsed": 33821208, "external": 2360850, "arrayBuffers": 42975 }, "uptime": 718.4054197 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760357197871_jbdjfzr9m", "timestamp": "2025-10-13T12:06:37.871Z", "message": "Unknown column 'shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Shift.findOne (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1240:12)\n at async exports.createShift (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:94:30)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `shiftName`, `startTime`, `endTime`, `branchId`, `isActive`, `description`, `color`, `createdAt`, `updatedAt` FROM `Shifts` AS `Shift` WHERE (`Shift`.`startTime` BETWEEN '15:06' AND '17:06' OR `Shift`.`endTime` BETWEEN '15:06' AND '17:06') AND `Shift`.`branchId` = 1 AND `Shift`.`isActive` = true LIMIT 1;", "parameters": {}, "context": { "endpoint": "POST /api/shifts", "requestBody": { "shiftName": "يسسي", "startTime": "15:06", "endTime": "17:06", "branchId": 1, "description": "سييس", "color": "#3b82f6" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 78671872, "heapTotal": 31502336, "heapUsed": 29124840, "external": 2343615, "arrayBuffers": 25780 }, "uptime": 238.419937 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760357201417_f4i0703aj", "timestamp": "2025-10-13T12:06:41.417Z", "message": "Unknown column 'Shift.shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getAllShifts (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:18:20)", "name": "SequelizeDatabaseError", "sql": "SELECT `Shift`.`id`, `Shift`.`shiftName`, `Shift`.`startTime`, `Shift`.`endTime`, `Shift`.`branchId`, `Shift`.`isActive`, `Shift`.`description`, `Shift`.`color`, `Shift`.`createdAt`, `Shift`.`updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `Shifts` AS `Shift` LEFT OUTER JOIN `Branches` AS `branch` ON `Shift`.`branchId` = `branch`.`id` ORDER BY `Shift`.`startTime` ASC;", "parameters": {}, "context": { "endpoint": "GET /api/shifts" }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 78950400, "heapTotal": 31502336, "heapUsed": 29518752, "external": 2343732, "arrayBuffers": 25857 }, "uptime": 241.9654067 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760357315880_vm6cwn1ue", "timestamp": "2025-10-13T12:08:35.880Z", "message": "Unknown column 'Shift.shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getAllShifts (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:18:20)", "name": "SequelizeDatabaseError", "sql": "SELECT `Shift`.`id`, `Shift`.`shiftName`, `Shift`.`startTime`, `Shift`.`endTime`, `Shift`.`branchId`, `Shift`.`isActive`, `Shift`.`description`, `Shift`.`color`, `Shift`.`createdAt`, `Shift`.`updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `Shifts` AS `Shift` LEFT OUTER JOIN `Branches` AS `branch` ON `Shift`.`branchId` = `branch`.`id` ORDER BY `Shift`.`startTime` ASC;", "parameters": {}, "context": { "endpoint": "GET /api/shifts" }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 79704064, "heapTotal": 31764480, "heapUsed": 30167408, "external": 2343841, "arrayBuffers": 25966 }, "uptime": 356.4286023 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760357331813_5pbhukert", "timestamp": "2025-10-13T12:08:51.813Z", "message": "Unknown column 'shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Shift.findOne (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1240:12)\n at async exports.createShift (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:94:30)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `shiftName`, `startTime`, `endTime`, `branchId`, `isActive`, `description`, `color`, `createdAt`, `updatedAt` FROM `Shifts` AS `Shift` WHERE (`Shift`.`startTime` BETWEEN '15:08' AND '15:08' OR `Shift`.`endTime` BETWEEN '15:08' AND '15:08') AND `Shift`.`branchId` = 1 AND `Shift`.`isActive` = true LIMIT 1;", "parameters": {}, "context": { "endpoint": "POST /api/shifts", "requestBody": { "shiftName": "يسسي", "startTime": "15:08", "endTime": "15:08", "branchId": 1, "description": "يس", "color": "#3b82f6" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 80699392, "heapTotal": 33599488, "heapUsed": 31115488, "external": 2352152, "arrayBuffers": 34277 }, "uptime": 372.3615091 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760357333084_n9qctlfte", "timestamp": "2025-10-13T12:08:53.084Z", "message": "Unknown column 'shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Shift.findOne (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1240:12)\n at async exports.createShift (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:94:30)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `shiftName`, `startTime`, `endTime`, `branchId`, `isActive`, `description`, `color`, `createdAt`, `updatedAt` FROM `Shifts` AS `Shift` WHERE (`Shift`.`startTime` BETWEEN '15:08' AND '15:08' OR `Shift`.`endTime` BETWEEN '15:08' AND '15:08') AND `Shift`.`branchId` = 1 AND `Shift`.`isActive` = true LIMIT 1;", "parameters": {}, "context": { "endpoint": "POST /api/shifts", "requestBody": { "shiftName": "يسسي", "startTime": "15:08", "endTime": "15:08", "branchId": 1, "description": "يس", "color": "#3b82f6" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 81178624, "heapTotal": 33075200, "heapUsed": 31033976, "external": 2351799, "arrayBuffers": 33924 }, "uptime": 373.6327794 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760357334297_j0vrx5dju", "timestamp": "2025-10-13T12:08:54.297Z", "message": "Unknown column 'shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Shift.findOne (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1240:12)\n at async exports.createShift (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:94:30)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `shiftName`, `startTime`, `endTime`, `branchId`, `isActive`, `description`, `color`, `createdAt`, `updatedAt` FROM `Shifts` AS `Shift` WHERE (`Shift`.`startTime` BETWEEN '15:08' AND '15:08' OR `Shift`.`endTime` BETWEEN '15:08' AND '15:08') AND `Shift`.`branchId` = 1 AND `Shift`.`isActive` = true LIMIT 1;", "parameters": {}, "context": { "endpoint": "POST /api/shifts", "requestBody": { "shiftName": "يسسي", "startTime": "15:08", "endTime": "15:08", "branchId": 1, "description": "يس", "color": "#3b82f6" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 81178624, "heapTotal": 33075200, "heapUsed": 31276272, "external": 2351991, "arrayBuffers": 34116 }, "uptime": 374.8455536 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760357363648_0dbhal3rh", "timestamp": "2025-10-13T12:09:23.648Z", "message": "Unknown column 'shiftName' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Shift.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Shift.findOne (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1240:12)\n at async exports.createShift (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:94:30)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `shiftName`, `startTime`, `endTime`, `branchId`, `isActive`, `description`, `color`, `createdAt`, `updatedAt` FROM `Shifts` AS `Shift` WHERE (`Shift`.`startTime` BETWEEN '15:08' AND '15:08' OR `Shift`.`endTime` BETWEEN '15:08' AND '15:08') AND `Shift`.`branchId` = 1 AND `Shift`.`isActive` = true LIMIT 1;", "parameters": {}, "context": { "endpoint": "POST /api/shifts", "requestBody": { "shiftName": "يسسي", "startTime": "15:08", "endTime": "15:08", "branchId": 1, "description": "يس", "color": "#8b5cf6" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 81510400, "heapTotal": 33337344, "heapUsed": 31839864, "external": 2351976, "arrayBuffers": 34101 }, "uptime": 404.1967202 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359498809_6qjgzdgmo", "timestamp": "2025-10-13T12:44:58.809Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8", "if-none-match": "W/\"24-fDxFN8Mf1SgODCZgCVo8S9iW524\"" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:44:58.808Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 87502848, "heapTotal": 41201664, "heapUsed": 33498232, "external": 2372616, "arrayBuffers": 54781 }, "uptime": 571.6790134 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359501003_ya2ijryy3", "timestamp": "2025-10-13T12:45:01.003Z", "message": "Unknown column 'Booking.booking_date' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:45:01.003Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 88809472, "heapTotal": 41725952, "heapUsed": 33532040, "external": 2363406, "arrayBuffers": 45531 }, "uptime": 573.8730723 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359501202_jao22zcii", "timestamp": "2025-10-13T12:45:01.202Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8", "if-none-match": "W/\"24-fDxFN8Mf1SgODCZgCVo8S9iW524\"" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:45:01.202Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 88895488, "heapTotal": 41725952, "heapUsed": 34330344, "external": 2398326, "arrayBuffers": 80451 }, "uptime": 574.0722511 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359501885_waraczpb5", "timestamp": "2025-10-13T12:45:01.885Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:45:01.885Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 88915968, "heapTotal": 41725952, "heapUsed": 34245480, "external": 2402303, "arrayBuffers": 84428 }, "uptime": 574.7555671 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359501990_fi5xhjqrh", "timestamp": "2025-10-13T12:45:01.990Z", "message": "Unknown column 'Booking.booking_date' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:45:01.990Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 88952832, "heapTotal": 41725952, "heapUsed": 34657384, "external": 2410647, "arrayBuffers": 92772 }, "uptime": 574.8603566 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359502172_ayvgybt7m", "timestamp": "2025-10-13T12:45:02.172Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:45:02.171Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 89006080, "heapTotal": 41725952, "heapUsed": 33613944, "external": 2363391, "arrayBuffers": 45516 }, "uptime": 575.0425357 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359502588_pmoxfy2t6", "timestamp": "2025-10-13T12:45:02.588Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:45:02.588Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 89006080, "heapTotal": 41725952, "heapUsed": 34030088, "external": 2363536, "arrayBuffers": 45661 }, "uptime": 575.4586245 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359502738_4pvywf8g4", "timestamp": "2025-10-13T12:45:02.738Z", "message": "Unknown column 'Booking.booking_date' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:45:02.738Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 89006080, "heapTotal": 41725952, "heapUsed": 34442376, "external": 2371880, "arrayBuffers": 54005 }, "uptime": 575.6079483 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359502999_t894ksohh", "timestamp": "2025-10-13T12:45:02.999Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:45:02.999Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 89006080, "heapTotal": 41725952, "heapUsed": 34852792, "external": 2372029, "arrayBuffers": 54154 }, "uptime": 575.8691406 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359839028_r9d5xdp67", "timestamp": "2025-10-13T12:50:39.028Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:50:39.028Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 91713536, "heapTotal": 44347392, "heapUsed": 39530928, "external": 2402648, "arrayBuffers": 84773 }, "uptime": 911.8987528 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359840111_bdxcvipz6", "timestamp": "2025-10-13T12:50:40.111Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:50:40.111Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 91439104, "heapTotal": 40677376, "heapUsed": 31553736, "external": 2367899, "arrayBuffers": 51428 }, "uptime": 912.9901714 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359840291_x8pnkefmv", "timestamp": "2025-10-13T12:50:40.291Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:50:40.291Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 91729920, "heapTotal": 41725952, "heapUsed": 31339248, "external": 2355564, "arrayBuffers": 39093 }, "uptime": 913.1618124 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359840644_m598sryuk", "timestamp": "2025-10-13T12:50:40.644Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:50:40.644Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 91729920, "heapTotal": 40677376, "heapUsed": 31087008, "external": 2354949, "arrayBuffers": 38478 }, "uptime": 913.5146808 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359841353_vqz78i8b6", "timestamp": "2025-10-13T12:50:41.353Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:50:41.353Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 91729920, "heapTotal": 40677376, "heapUsed": 31453328, "external": 2355094, "arrayBuffers": 38623 }, "uptime": 914.2242187 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359842525_5mx7hesr8", "timestamp": "2025-10-13T12:50:42.525Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T12:50:42.525Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 91729920, "heapTotal": 40677376, "heapUsed": 31851568, "external": 2363435, "arrayBuffers": 46964 }, "uptime": 915.396287 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359872987_npvs7yfxn", "timestamp": "2025-10-13T12:51:12.987Z", "message": "Unknown column 'Booking.booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`booking_number` AS `bookingNumber`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `Booking`.`created_at` AS `createdAt`, `Booking`.`updated_at` AS `updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13' AND `Booking`.`booking_time` BETWEEN '15:08:00' AND '15:08:00';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 82763776, "heapTotal": 34455552, "heapUsed": 31813336, "external": 2353272, "arrayBuffers": 38293 }, "uptime": 945.8576611 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359898690_bbhi73r1s", "timestamp": "2025-10-13T12:51:38.690Z", "message": "Unknown column 'Booking.booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`booking_number` AS `bookingNumber`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `Booking`.`created_at` AS `createdAt`, `Booking`.`updated_at` AS `updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13' AND `Booking`.`booking_time` BETWEEN '15:08:00' AND '15:08:00';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 83677184, "heapTotal": 34979840, "heapUsed": 32507776, "external": 2361782, "arrayBuffers": 46803 }, "uptime": 971.5604653 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359954333_elm5mq4o7", "timestamp": "2025-10-13T12:52:34.333Z", "message": "Unknown column 'Booking.booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`booking_number` AS `bookingNumber`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `Booking`.`created_at` AS `createdAt`, `Booking`.`updated_at` AS `updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-14' AND `Booking`.`booking_time` BETWEEN '15:08:00' AND '15:08:00';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-14" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 84557824, "heapTotal": 37076992, "heapUsed": 32951296, "external": 2371129, "arrayBuffers": 53098 }, "uptime": 1027.2027229 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760359956714_4y4qlgiyn", "timestamp": "2025-10-13T12:52:36.714Z", "message": "Unknown column 'Booking.booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`booking_number` AS `bookingNumber`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `Booking`.`created_at` AS `createdAt`, `Booking`.`updated_at` AS `updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13' AND `Booking`.`booking_time` BETWEEN '15:08:00' AND '15:08:00';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 84557824, "heapTotal": 37076992, "heapUsed": 33443928, "external": 2379052, "arrayBuffers": 64073 }, "uptime": 1029.5838239 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360030819_youtur1j9", "timestamp": "2025-10-13T12:53:50.819Z", "message": "Unknown column 'Booking.booking_time' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`customer_name` AS `customerName`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`status`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13' AND `Booking`.`booking_time` BETWEEN '15:08:00' AND '15:08:00';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 80011264, "heapTotal": 31764480, "heapUsed": 29816456, "external": 2354164, "arrayBuffers": 36329 }, "uptime": 42.8724592 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360142306_5txgzvjga", "timestamp": "2025-10-13T12:55:42.306Z", "message": "Unknown column 'booking_time' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `booking_time` AS `bookingTime`, `customer_name` AS `customerName`, `final_amount` AS `finalAmount`, `status` FROM `BOOKINGS` AS `Booking` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131735552, "heapTotal": 87601152, "heapUsed": 34809448, "external": 2442901, "arrayBuffers": 125066 }, "uptime": 11.177159 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360161793_r93jgfwjl", "timestamp": "2025-10-13T12:56:01.793Z", "message": "Unknown column 'booking_time' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `booking_time` AS `bookingTime`, `customer_name` AS `customerName`, `final_amount` AS `finalAmount`, `status` FROM `BOOKINGS` AS `Booking` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 80793600, "heapTotal": 34123776, "heapUsed": 30672656, "external": 2345577, "arrayBuffers": 27702 }, "uptime": 30.6579875 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360176432_yazx93lx3", "timestamp": "2025-10-13T12:56:16.432Z", "message": "Unknown column 'booking_time' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `id`, `booking_time` AS `bookingTime`, `customer_name` AS `customerName`, `final_amount` AS `finalAmount`, `status` FROM `BOOKINGS` AS `Booking` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 83607552, "heapTotal": 35958784, "heapUsed": 32334048, "external": 2362269, "arrayBuffers": 44394 }, "uptime": 45.2968781 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360208278_og5mxj8n7", "timestamp": "2025-10-13T12:56:48.278Z", "message": "Unknown column 'booking_time' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:283:22)", "name": "SequelizeDatabaseError", "sql": "SELECT id, booking_time as bookingTime, customer_name as customerName, \n final_amount as finalAmount, status \n FROM BOOKINGS \n WHERE booking_date = '2025-10-13' \n AND status IN ('confirmed', 'completed')\n AND booking_time BETWEEN '15:08:00' AND '15:08:00'", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131207168, "heapTotal": 87076864, "heapUsed": 30629432, "external": 2366398, "arrayBuffers": 48563 }, "uptime": 3.8474976 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360209438_zcc3s1ppg", "timestamp": "2025-10-13T12:56:49.437Z", "message": "Unknown column 'booking_time' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:283:22)", "name": "SequelizeDatabaseError", "sql": "SELECT id, booking_time as bookingTime, customer_name as customerName, \n final_amount as finalAmount, status \n FROM BOOKINGS \n WHERE booking_date = '2025-10-13' \n AND status IN ('confirmed', 'completed')\n AND booking_time BETWEEN '15:08:00' AND '15:08:00'", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131457024, "heapTotal": 87076864, "heapUsed": 31157568, "external": 2369211, "arrayBuffers": 51336 }, "uptime": 5.0072747 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360215988_gvao4mlls", "timestamp": "2025-10-13T12:56:55.988Z", "message": "Unknown column 'booking_time' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:283:22)", "name": "SequelizeDatabaseError", "sql": "SELECT id, booking_time as bookingTime, customer_name as customerName, \n final_amount as finalAmount, status \n FROM BOOKINGS \n WHERE booking_date = '2025-10-13' \n AND status IN ('confirmed', 'completed')\n AND booking_time BETWEEN '15:08:00' AND '15:08:00'", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131891200, "heapTotal": 87601152, "heapUsed": 34448416, "external": 2430612, "arrayBuffers": 112737 }, "uptime": 11.5571842 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360234126_d1l5z0snb", "timestamp": "2025-10-13T12:57:14.126Z", "message": "Unknown column 'booking_time' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:283:22)", "name": "SequelizeDatabaseError", "sql": "SELECT id, booking_time as bookingTime, customer_name as customerName, \n final_amount as finalAmount, status \n FROM BOOKINGS \n WHERE booking_date = '2025-10-13' \n AND status IN ('confirmed', 'completed')\n AND booking_time BETWEEN '15:08:00' AND '15:08:00'", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 79220736, "heapTotal": 32550912, "heapUsed": 29831960, "external": 2354212, "arrayBuffers": 36337 }, "uptime": 29.6955344 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360282814_95i17hoy8", "timestamp": "2025-10-13T12:58:02.814Z", "message": "Unknown column 'Booking.booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`booking_number` AS `bookingNumber`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `Booking`.`created_at` AS `createdAt`, `Booking`.`updated_at` AS `updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13' AND `Booking`.`booking_time` BETWEEN '15:08:00' AND '15:08:00';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131440640, "heapTotal": 87601152, "heapUsed": 30891552, "external": 2368528, "arrayBuffers": 50693 }, "uptime": 7.9450743 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360289703_fzd9dyhg2", "timestamp": "2025-10-13T12:58:09.703Z", "message": "Unknown column 'Booking.booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`booking_number` AS `bookingNumber`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `Booking`.`created_at` AS `createdAt`, `Booking`.`updated_at` AS `updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13' AND `Booking`.`booking_time` BETWEEN '15:08:00' AND '15:08:00';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131735552, "heapTotal": 87863296, "heapUsed": 34319168, "external": 2421787, "arrayBuffers": 103912 }, "uptime": 14.8338829 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360406587_b5mim1tbl", "timestamp": "2025-10-13T13:00:06.587Z", "message": "Unknown column 'Booking.customer_name' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13' AND `Booking`.`booking_time` BETWEEN '15:08:00' AND '15:08:00';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131850240, "heapTotal": 87601152, "heapUsed": 33968904, "external": 2405220, "arrayBuffers": 87385 }, "uptime": 6.7955594 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360419946_ctysmjpug", "timestamp": "2025-10-13T13:00:19.946Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:19.946Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 132055040, "heapTotal": 88125440, "heapUsed": 40423888, "external": 2447761, "arrayBuffers": 129886 }, "uptime": 20.1549637 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360420054_yn6alvkqx", "timestamp": "2025-10-13T13:00:20.054Z", "message": "Unknown column 'Booking.booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Promise.all (index 1)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`booking_number` AS `bookingNumber`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `Booking`.`created_at` AS `createdAt`, `Booking`.`updated_at` AS `updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName`, `table`.`id` AS `table.id`, `table`.`name` AS `table.name`, `table`.`tableNumber` AS `table.tableNumber`, `table`.`capacity` AS `table.capacity` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13' ORDER BY `createdAt` DESC LIMIT 0, 50;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:20.054Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 132927488, "heapTotal": 88387584, "heapUsed": 43622312, "external": 2512362, "arrayBuffers": 194487 }, "uptime": 20.2628105 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360420342_k36oxgdm0", "timestamp": "2025-10-13T13:00:20.342Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:20.342Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 133824512, "heapTotal": 88911872, "heapUsed": 36730832, "external": 2351045, "arrayBuffers": 33170 }, "uptime": 20.5505324 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360420791_lmuwut9p6", "timestamp": "2025-10-13T13:00:20.791Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:20.791Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 133840896, "heapTotal": 88911872, "heapUsed": 37167304, "external": 2359386, "arrayBuffers": 41511 }, "uptime": 20.9998406 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360421672_v8z3d4tsm", "timestamp": "2025-10-13T13:00:21.672Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:21.672Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 133939200, "heapTotal": 88911872, "heapUsed": 37600760, "external": 2359535, "arrayBuffers": 41660 }, "uptime": 21.8811222 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360422109_m4j0a0vsa", "timestamp": "2025-10-13T13:00:22.109Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:22.109Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 133959680, "heapTotal": 88911872, "heapUsed": 38011896, "external": 2367872, "arrayBuffers": 49997 }, "uptime": 22.3177965 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360431972_p6k5by3gr", "timestamp": "2025-10-13T13:00:31.972Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:31.972Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 82325504, "heapTotal": 35434496, "heapUsed": 32613376, "external": 2343824, "arrayBuffers": 25949 }, "uptime": 32.180904 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360432418_shtd8qraj", "timestamp": "2025-10-13T13:00:32.418Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:32.418Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 82870272, "heapTotal": 36483072, "heapUsed": 32234840, "external": 2352161, "arrayBuffers": 34125 }, "uptime": 32.6263984 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360432906_okndoo208", "timestamp": "2025-10-13T13:00:32.906Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:32.906Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 83447808, "heapTotal": 36483072, "heapUsed": 32731368, "external": 2352149, "arrayBuffers": 34274 }, "uptime": 33.1143727 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360433601_2xmavi5oa", "timestamp": "2025-10-13T13:00:33.601Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:33.601Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 83972096, "heapTotal": 35696640, "heapUsed": 32390384, "external": 2352000, "arrayBuffers": 34125 }, "uptime": 33.8101185 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360433999_d156jhjo2", "timestamp": "2025-10-13T13:00:33.999Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:33.999Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 84013056, "heapTotal": 35696640, "heapUsed": 32806512, "external": 2360341, "arrayBuffers": 42466 }, "uptime": 34.2078578 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360434550_ognjuu4a9", "timestamp": "2025-10-13T13:00:34.550Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:00:34.550Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 83902464, "heapTotal": 35958784, "heapUsed": 32459936, "external": 2360196, "arrayBuffers": 42321 }, "uptime": 34.7584729 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360464079_3xyzpk1r1", "timestamp": "2025-10-13T13:01:04.079Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:01:04.079Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 87171072, "heapTotal": 38580224, "heapUsed": 36017888, "external": 2369823, "arrayBuffers": 51948 }, "uptime": 64.2874474 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360464100_qyp63y4c5", "timestamp": "2025-10-13T13:01:04.100Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:01:04.100Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 87347200, "heapTotal": 38580224, "heapUsed": 36232576, "external": 2379014, "arrayBuffers": 61139 }, "uptime": 64.3082805 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360464783_i42qdvqko", "timestamp": "2025-10-13T13:01:04.783Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:01:04.783Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 87220224, "heapTotal": 39890944, "heapUsed": 36296416, "external": 2379563, "arrayBuffers": 61688 }, "uptime": 64.9911454 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360465097_2ggexn73l", "timestamp": "2025-10-13T13:01:05.097Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:01:05.097Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 87482368, "heapTotal": 40153088, "heapUsed": 36171720, "external": 2386989, "arrayBuffers": 69114 }, "uptime": 65.3054616 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360465858_4pvhg4tje", "timestamp": "2025-10-13T13:01:05.858Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:01:05.858Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 87334912, "heapTotal": 40153088, "heapUsed": 36652256, "external": 2387138, "arrayBuffers": 69263 }, "uptime": 66.0661738 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360466063_b3vk0c5ps", "timestamp": "2025-10-13T13:01:06.063Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:01:06.063Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 87748608, "heapTotal": 40153088, "heapUsed": 36256952, "external": 2395177, "arrayBuffers": 77302 }, "uptime": 66.2711347 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360490636_0qfwc07z6", "timestamp": "2025-10-13T13:01:30.636Z", "message": "Unknown column 'Booking.customer_name' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13' AND `Booking`.`booking_time` BETWEEN '16:00:00' AND '04:00:00';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/3/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 88915968, "heapTotal": 40677376, "heapUsed": 37884528, "external": 2407049, "arrayBuffers": 89174 }, "uptime": 90.8443992 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360532083_9h6ima7yt", "timestamp": "2025-10-13T13:02:12.083Z", "message": "Unknown column 'Booking.customer_name' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async exports.getShiftRevenue (E:\\مشاريع 2025\\MetaCoffe\\backend\\controllers\\shiftController.js:282:22)", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` WHERE `Booking`.`status` IN ('confirmed', 'completed') AND `Booking`.`booking_date` = '2025-10-13' AND `Booking`.`booking_time` BETWEEN '15:08:00' AND '15:08:00';", "parameters": {}, "context": { "endpoint": "GET /api/shifts/1/revenue", "query": { "date": "2025-10-13" } }, "additionalInfo": {}, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131473408, "heapTotal": 87601152, "heapUsed": 32115160, "external": 2369905, "arrayBuffers": 52070 }, "uptime": 9.9599715 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360537503_m6uq9rx2y", "timestamp": "2025-10-13T13:02:17.503Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:02:17.503Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131653632, "heapTotal": 87863296, "heapUsed": 34337776, "external": 2370070, "arrayBuffers": 52195 }, "uptime": 15.3796264 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360537988_bs1ec8rky", "timestamp": "2025-10-13T13:02:17.988Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::ffff:127.0.0.1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:02:17.988Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131674112, "heapTotal": 87863296, "heapUsed": 34488608, "external": 2378395, "arrayBuffers": 60520 }, "uptime": 15.8648861 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360538340_9mfjp3tzg", "timestamp": "2025-10-13T13:02:18.340Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::ffff:127.0.0.1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:02:18.340Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131743744, "heapTotal": 87863296, "heapUsed": 35068200, "external": 2379496, "arrayBuffers": 61621 }, "uptime": 16.2169185 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360538955_pmae9fech", "timestamp": "2025-10-13T13:02:18.955Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::ffff:127.0.0.1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:02:18.955Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131809280, "heapTotal": 87863296, "heapUsed": 35552616, "external": 2387837, "arrayBuffers": 69962 }, "uptime": 16.8317485 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360539901_cozgx3ttz", "timestamp": "2025-10-13T13:02:19.901Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::ffff:127.0.0.1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:02:19.901Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131837952, "heapTotal": 87863296, "heapUsed": 35978640, "external": 2387982, "arrayBuffers": 70107 }, "uptime": 17.7776231 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360540105_865ncf5kq", "timestamp": "2025-10-13T13:02:20.105Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:02:20.105Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 131878912, "heapTotal": 88125440, "heapUsed": 36446848, "external": 2396323, "arrayBuffers": 78448 }, "uptime": 17.9816174 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360582510_772gcou63", "timestamp": "2025-10-13T13:03:02.510Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:02.510Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 85663744, "heapTotal": 37269504, "heapUsed": 35157728, "external": 2352528, "arrayBuffers": 34653 }, "uptime": 60.3868246 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360582643_0667tuj7z", "timestamp": "2025-10-13T13:03:02.643Z", "message": "Unknown column 'Booking.booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.select (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n at async Booking.findAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n at async Promise.all (index 1)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT `Booking`.`id`, `Booking`.`booking_number` AS `bookingNumber`, `Booking`.`customer_name` AS `customerName`, `Booking`.`customer_phone` AS `customerPhone`, `Booking`.`customer_email` AS `customerEmail`, `Booking`.`branch_id` AS `branchId`, `Booking`.`table_id` AS `tableId`, `Booking`.`booking_date` AS `bookingDate`, `Booking`.`booking_time` AS `bookingTime`, `Booking`.`status`, `Booking`.`total_price` AS `totalPrice`, `Booking`.`final_amount` AS `finalAmount`, `Booking`.`payment_status` AS `paymentStatus`, `Booking`.`notes`, `Booking`.`special_requests` AS `specialRequests`, `Booking`.`created_at` AS `createdAt`, `Booking`.`updated_at` AS `updatedAt`, `branch`.`id` AS `branch.id`, `branch`.`arabicName` AS `branch.arabicName`, `branch`.`englishName` AS `branch.englishName`, `table`.`id` AS `table.id`, `table`.`name` AS `table.name`, `table`.`tableNumber` AS `table.tableNumber`, `table`.`capacity` AS `table.capacity` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13' ORDER BY `createdAt` DESC LIMIT 0, 50;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:02.643Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 85946368, "heapTotal": 38580224, "heapUsed": 35238368, "external": 2364220, "arrayBuffers": 46345 }, "uptime": 60.5195391 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360583326_sopry1g25", "timestamp": "2025-10-13T13:03:03.326Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:03.325Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 86376448, "heapTotal": 37793792, "heapUsed": 35331400, "external": 2369601, "arrayBuffers": 51726 }, "uptime": 61.2029641 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360583678_aksvj3xhj", "timestamp": "2025-10-13T13:03:03.678Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:03.678Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 86380544, "heapTotal": 37793792, "heapUsed": 35699688, "external": 2369746, "arrayBuffers": 51871 }, "uptime": 61.5547859 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360585316_u43qbzj1t", "timestamp": "2025-10-13T13:03:05.316Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:05.316Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 86446080, "heapTotal": 37793792, "heapUsed": 35384224, "external": 2377761, "arrayBuffers": 59886 }, "uptime": 63.1927938 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360585457_wtmux4sma", "timestamp": "2025-10-13T13:03:05.457Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:05.457Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 86446080, "heapTotal": 37793792, "heapUsed": 35763976, "external": 2377906, "arrayBuffers": 60031 }, "uptime": 63.3331027 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360618154_uwc0ib860", "timestamp": "2025-10-13T13:03:38.154Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:38.154Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 89243648, "heapTotal": 40677376, "heapUsed": 38546296, "external": 2386505, "arrayBuffers": 68630 }, "uptime": 96.0301624 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360618735_2ic8a28ps", "timestamp": "2025-10-13T13:03:38.735Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:38.735Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 89255936, "heapTotal": 40677376, "heapUsed": 38713360, "external": 2394830, "arrayBuffers": 76955 }, "uptime": 96.6117801 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360619469_bkii5ddq5", "timestamp": "2025-10-13T13:03:39.469Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:39.469Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 89726976, "heapTotal": 42250240, "heapUsed": 39000968, "external": 2395418, "arrayBuffers": 77543 }, "uptime": 97.3452324 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360619621_n0pg4awmk", "timestamp": "2025-10-13T13:03:39.621Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:39.621Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 89923584, "heapTotal": 41463808, "heapUsed": 38691672, "external": 2395334, "arrayBuffers": 77459 }, "uptime": 97.4970139 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360620376_jmnlmtuft", "timestamp": "2025-10-13T13:03:40.376Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:40.376Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 89948160, "heapTotal": 41463808, "heapUsed": 39071152, "external": 2395479, "arrayBuffers": 77604 }, "uptime": 98.2520173 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360620682_nr1cj6wte", "timestamp": "2025-10-13T13:03:40.682Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:03:40.682Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 89804800, "heapTotal": 41463808, "heapUsed": 38755768, "external": 2395338, "arrayBuffers": 77463 }, "uptime": 98.5583436 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360648290_kfwjtxb27", "timestamp": "2025-10-13T13:04:08.290Z", "message": "Unknown column 'booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.insert (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:308:21)\n at async model.save (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:2490:35)\n at async Booking.create (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1362:12)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:468:21", "name": "SequelizeDatabaseError", "sql": "INSERT INTO `BOOKINGS` (`id`,`booking_number`,`customer_name`,`customer_phone`,`customer_email`,`branch_id`,`table_id`,`booking_date`,`booking_time`,`status`,`total_price`,`final_amount`,`payment_status`,`notes`,`special_requests`,`created_at`,`updated_at`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);", "parameters": [ "BK1760360648270", "mahmoud SABER MAHMOUD BAHNSI KHAMIS", "01028454790", "mido10sb@gmail.com", 1, 1, "2025-10-13", "08:00", "confirmed", 0, 0, "unpaid", "", "[{\"id\":\"PRD-1760359768019-300\",\"name\":\"لالا\",\"category\":\"تاتا\",\"duration\":30,\"price\":100,\"priority\":\"standard\",\"type\":\"product\",\"code\":\"PRD-1760359768019-300\"}]", "2025-10-13 13:04:08", "2025-10-13 13:04:08" ], "context": { "endpoint": "POST /api/v1/bookings", "requestBody": { "customerName": "mahmoud SABER MAHMOUD BAHNSI KHAMIS", "customerPhone": "01028454790", "customerEmail": "mido10sb@gmail.com", "branchId": 1, "tableId": 1, "shiftId": 3, "date": "2025-10-13", "time": "08:00", "services": [ { "id": "PRD-1760359768019-300", "name": "لالا", "category": "تاتا", "duration": 30, "price": 100, "priority": "standard", "type": "product", "code": "PRD-1760359768019-300" } ], "notes": "" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "content-length": "384", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "content-type": "application/json", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36" }, "additionalInfo": { "operation": "create_booking", "timestamp": "2025-10-13T13:04:08.290Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 90968064, "heapTotal": 38842368, "heapUsed": 30756544, "external": 2351654, "arrayBuffers": 33779 }, "uptime": 126.1667865 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360649368_ca2kh3h62", "timestamp": "2025-10-13T13:04:09.368Z", "message": "Unknown column 'booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.insert (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:308:21)\n at async model.save (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:2490:35)\n at async Booking.create (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1362:12)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:468:21", "name": "SequelizeDatabaseError", "sql": "INSERT INTO `BOOKINGS` (`id`,`booking_number`,`customer_name`,`customer_phone`,`customer_email`,`branch_id`,`table_id`,`booking_date`,`booking_time`,`status`,`total_price`,`final_amount`,`payment_status`,`notes`,`special_requests`,`created_at`,`updated_at`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);", "parameters": [ "BK1760360649299", "mahmoud SABER MAHMOUD BAHNSI KHAMIS", "01028454790", "mido10sb@gmail.com", 1, 1, "2025-10-13", "08:00", "confirmed", 0, 0, "unpaid", "", "[{\"id\":\"PRD-1760359768019-300\",\"name\":\"لالا\",\"category\":\"تاتا\",\"duration\":30,\"price\":100,\"priority\":\"standard\",\"type\":\"product\",\"code\":\"PRD-1760359768019-300\"}]", "2025-10-13 13:04:09", "2025-10-13 13:04:09" ], "context": { "endpoint": "POST /api/v1/bookings", "requestBody": { "customerName": "mahmoud SABER MAHMOUD BAHNSI KHAMIS", "customerPhone": "01028454790", "customerEmail": "mido10sb@gmail.com", "branchId": 1, "tableId": 1, "shiftId": 3, "date": "2025-10-13", "time": "08:00", "services": [ { "id": "PRD-1760359768019-300", "name": "لالا", "category": "تاتا", "duration": 30, "price": 100, "priority": "standard", "type": "product", "code": "PRD-1760359768019-300" } ], "notes": "" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "content-length": "384", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "content-type": "application/json", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36" }, "additionalInfo": { "operation": "create_booking", "timestamp": "2025-10-13T13:04:09.368Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 90337280, "heapTotal": 38842368, "heapUsed": 30772616, "external": 2351714, "arrayBuffers": 33839 }, "uptime": 127.2453285 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360650582_nroyvmc9y", "timestamp": "2025-10-13T13:04:10.582Z", "message": "Unknown column 'booking_number' in 'field list'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.insert (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:308:21)\n at async model.save (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:2490:35)\n at async Booking.create (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1362:12)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:468:21", "name": "SequelizeDatabaseError", "sql": "INSERT INTO `BOOKINGS` (`id`,`booking_number`,`customer_name`,`customer_phone`,`customer_email`,`branch_id`,`table_id`,`booking_date`,`booking_time`,`status`,`total_price`,`final_amount`,`payment_status`,`notes`,`special_requests`,`created_at`,`updated_at`) VALUES (DEFAULT,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);", "parameters": [ "BK1760360650572", "mahmoud SABER MAHMOUD BAHNSI KHAMIS", "01028454790", "mido10sb@gmail.com", 1, 1, "2025-10-13", "08:00", "confirmed", 0, 0, "unpaid", "", "[{\"id\":\"PRD-1760359768019-300\",\"name\":\"لالا\",\"category\":\"تاتا\",\"duration\":30,\"price\":100,\"priority\":\"standard\",\"type\":\"product\",\"code\":\"PRD-1760359768019-300\"}]", "2025-10-13 13:04:10", "2025-10-13 13:04:10" ], "context": { "endpoint": "POST /api/v1/bookings", "requestBody": { "customerName": "mahmoud SABER MAHMOUD BAHNSI KHAMIS", "customerPhone": "01028454790", "customerEmail": "mido10sb@gmail.com", "branchId": 1, "tableId": 1, "shiftId": 3, "date": "2025-10-13", "time": "08:00", "services": [ { "id": "PRD-1760359768019-300", "name": "لالا", "category": "تاتا", "duration": 30, "price": 100, "priority": "standard", "type": "product", "code": "PRD-1760359768019-300" } ], "notes": "" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "content-length": "384", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "content-type": "application/json", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36" }, "additionalInfo": { "operation": "create_booking", "timestamp": "2025-10-13T13:04:10.582Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 90357760, "heapTotal": 39890944, "heapUsed": 30846184, "external": 2359966, "arrayBuffers": 42091 }, "uptime": 128.4586834 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360650665_3z5j10mh3", "timestamp": "2025-10-13T13:04:10.665Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:04:10.663Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 90357760, "heapTotal": 39628800, "heapUsed": 32437480, "external": 2359951, "arrayBuffers": 42076 }, "uptime": 128.5423433 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360650718_1h3zzehv2", "timestamp": "2025-10-13T13:04:10.718Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:04:10.718Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 90361856, "heapTotal": 39628800, "heapUsed": 32692784, "external": 2369588, "arrayBuffers": 51713 }, "uptime": 128.5953742 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360651116_455bf790w", "timestamp": "2025-10-13T13:04:11.116Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:04:11.116Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 90611712, "heapTotal": 40939520, "heapUsed": 32780440, "external": 2368832, "arrayBuffers": 50957 }, "uptime": 128.9933931 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360651342_ym2x7hr8y", "timestamp": "2025-10-13T13:04:11.342Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:04:11.342Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 90927104, "heapTotal": 41201664, "heapUsed": 32558464, "external": 2368780, "arrayBuffers": 50905 }, "uptime": 129.2195853 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360652446_oj2ign4ln", "timestamp": "2025-10-13T13:04:12.446Z", "message": "Unknown column 'Booking.branch_id' in 'where clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id` WHERE `Booking`.`branch_id` = '1' AND `Booking`.`booking_date` = '2025-10-13';", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": { "branchId": "1", "date": "2025-10-13" }, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:04:12.446Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 90939392, "heapTotal": 41201664, "heapUsed": 32973640, "external": 2368929, "arrayBuffers": 51054 }, "uptime": 130.3235357 } } ---------------------------------------------------------------------------------------------------- { "errorId": "ERR_1760360652807_dzeqw77ba", "timestamp": "2025-10-13T13:04:12.807Z", "message": "Unknown column 'Booking.table_id' in 'on clause'", "stack": "Error\n at Query.run (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n at E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n at async MySQLQueryInterface.rawSelect (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:434:18)\n at async Booking.aggregate (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1277:19)\n at async Booking.count (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1306:20)\n at async Promise.all (index 0)\n at async Booking.findAndCountAll (E:\\مشاريع 2025\\MetaCoffe\\backend\\node_modules\\sequelize\\lib\\model.js:1322:27)\n at async E:\\مشاريع 2025\\MetaCoffe\\backend\\routes\\bookingRoutes.js:554:20", "name": "SequelizeDatabaseError", "sql": "SELECT count(`Booking`.`id`) AS `count` FROM `BOOKINGS` AS `Booking` LEFT OUTER JOIN `Branches` AS `branch` ON `Booking`.`branch_id` = `branch`.`id` LEFT OUTER JOIN `TABLES` AS `table` ON `Booking`.`table_id` = `table`.`id`;", "parameters": {}, "context": { "endpoint": "GET /api/v1/bookings", "query": {}, "headers": { "host": "localhost:4000", "connection": "keep-alive", "sec-ch-ua-platform": "\"Windows\"", "authorization": "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MSwiaWF0IjoxNzU5OTEzOTQ1LCJleHAiOjE3Njc2ODk5NDV9.y3GbfaFbQdE30lg6jLABc-vUOTv0tO-mi1KFwHcFYTM", "user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36", "sec-ch-ua": "\"Chromium\";v=\"140\", \"Not=A?Brand\";v=\"24\", \"Google Chrome\";v=\"140\"", "sec-ch-ua-mobile": "?0", "accept": "*/*", "origin": "http://localhost:8080", "sec-fetch-site": "same-site", "sec-fetch-mode": "cors", "sec-fetch-dest": "empty", "referer": "http://localhost:8080/", "accept-encoding": "gzip, deflate, br, zstd", "accept-language": "en-US,en;q=0.9,ar;q=0.8" }, "ip": "::1" }, "additionalInfo": { "operation": "fetch_bookings", "timestamp": "2025-10-13T13:04:12.807Z" }, "systemInfo": { "nodeVersion": "v22.13.1", "platform": "win32", "arch": "x64", "memoryUsage": { "rss": 90578944, "heapTotal": 41201664, "heapUsed": 32633056, "external": 2368780, "arrayBuffers": 50905 }, "uptime": 130.6836537 } } ----------------------------------------------------------------------------------------------------