

===============================================================================
User: 1  |  Time: 09:04:25  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => HY093
    [1] => 
    [2] => 
)

INSERT INTO tbl_stock_products                                             (                                                 Product_Code,                                                 Product_Name,                                                 Product_Arabic_Name,                                                 Category_ID,                                                 Product_Reorder_Point,                                                 Product_VAT,                                                 vat_percent,vat2_percent,                                                 PLU_Type,                                                 Product_PLU,                                                 on_scale,                                                 UOM_ID,                                                 is_tax,                                                 product_description,                                                 product_color,                                                 product_order,                                                 printer_id,                                                 product_type,                                                 Product_Limit_Discount,                                                 group_account_id,                                                 brand_id,pur_cat_id,                                                 link_note,                                                 date_created,                                                 created_logged_id,                                                 date_time,                                                 Logged_ID,                                                 section_id,                                                 machine_type_id,is_expiry,force_change_price,duration_reservation,                                                 default_view_uom_id,default_view_rate,is_lot,is_serial,main_supplier_id,                                                 family_id,default_sales_uom,default_purchase_uom,is_service,is_ticket,                                                 product_second_code,recipe_qty,product_param1,product_param2,product_param3,product_param4,print_uom_id,is_rate,branch_id                                                 ,is_rate_type_one                                                 ,is_rate_type_two                                                 ,n_width                                                  ,n_height                                                 ,effect_qty_link_product                                              )                                                 VALUES                                             (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Array
(
    [0] => 655
    [1] => test branch product1
    [2] => 
    [3] => 78
    [4] => 
    [5] => 0
    [6] => 
    [7] => 0
    [8] => N
    [9] => 655
    [10] => 0
    [11] => 67
    [12] => 0
    [13] => 
    [14] => #4c0870
    [15] => 
    [16] => 
    [17] => 0
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 2023-11-23 09:04:25
    [24] => 1
    [25] => 2023-11-23 09:04:25
    [26] => 1
    [27] => 
    [28] => 0
    [29] => 0
    [30] => 0
    [31] => 0
    [32] => 67
    [33] => 1
    [34] => 0
    [35] => 0
    [36] => 
    [37] => 
    [38] => 0
    [39] => 0
    [40] => 0
    [41] => 0
    [42] => 
    [43] => 1
    [44] => 
    [45] => 
    [46] => 
    [47] => 
    [48] => 0
    [49] => 0
    [50] => 1
    [51] => 0
    [52] => 0
    [53] => 0
    [54] => 0
    [55] => 0
    [56] => 0
)


===============================================================================
User: 1  |  Time: 09:04:25  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => 23000
    [1] => 1452
    [2] => Cannot add or update a child row: a foreign key constraint fails (`apple_clinic_update`.`tbl_uom_conversions`, CONSTRAINT `tbl_uom_conversions_ibfk_3` FOREIGN KEY (`Product_ID`) REFERENCES `tbl_stock_products` (`Product_ID`))
)

INSERT INTO tbl_uom_conversions                                                      (uom_from,                                                     conversion_amount,                                                     uom_to,                                                     Product_ID,                                                     is_default,                                                     Bar_Code,                                                     additional_barcodes                                                     )                                                     VALUES(?,1,?,?,1,?,?)                                                     
Array
(
    [0] => 67
    [1] => 67
    [2] => 0
    [3] => 655
    [4] => 
)


===============================================================================
User: 1  |  Time: 09:13:47  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => HY093
    [1] => 
    [2] => 
)

INSERT INTO tbl_stock_products                                             (                                                 Product_Code,                                                 Product_Name,                                                 Product_Arabic_Name,                                                 Category_ID,                                                 Product_Reorder_Point,                                                 Product_VAT,                                                 vat_percent,vat2_percent,                                                 PLU_Type,                                                 Product_PLU,                                                 on_scale,                                                 UOM_ID,                                                 is_tax,                                                 product_description,                                                 product_color,                                                 product_order,                                                 printer_id,                                                 product_type,                                                 Product_Limit_Discount,                                                 group_account_id,                                                 brand_id,pur_cat_id,                                                 link_note,                                                 date_created,                                                 created_logged_id,                                                 date_time,                                                 Logged_ID,                                                 section_id,                                                 machine_type_id,is_expiry,force_change_price,duration_reservation,                                                 default_view_uom_id,default_view_rate,is_lot,is_serial,main_supplier_id,                                                 family_id,default_sales_uom,default_purchase_uom,is_service,is_ticket,                                                 product_second_code,recipe_qty,product_param1,product_param2,product_param3,product_param4,print_uom_id,is_rate,branch_id                                                 ,is_rate_type_one                                                 ,is_rate_type_two                                                 ,n_width                                                  ,n_height                                                 ,effect_qty_link_product                                              )                                                 VALUES                                             (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Array
(
    [0] => 655
    [1] => test branch product1
    [2] => 
    [3] => 78
    [4] => 
    [5] => 0
    [6] => 
    [7] => 0
    [8] => N
    [9] => 655
    [10] => 0
    [11] => 67
    [12] => 0
    [13] => 
    [14] => #4c0870
    [15] => 
    [16] => 
    [17] => 0
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 2023-11-23 09:13:47
    [24] => 1
    [25] => 2023-11-23 09:13:47
    [26] => 1
    [27] => 
    [28] => 0
    [29] => 0
    [30] => 0
    [31] => 0
    [32] => 67
    [33] => 1
    [34] => 0
    [35] => 0
    [36] => 
    [37] => 
    [38] => 0
    [39] => 0
    [40] => 0
    [41] => 0
    [42] => 
    [43] => 1
    [44] => 
    [45] => 
    [46] => 
    [47] => 
    [48] => 0
    [49] => 0
    [50] => 1
    [51] => 0
    [52] => 0
    [53] => 0
    [54] => 0
    [55] => 0
    [56] => 0
)


===============================================================================
User: 1  |  Time: 09:13:47  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => 23000
    [1] => 1452
    [2] => Cannot add or update a child row: a foreign key constraint fails (`apple_clinic_update`.`tbl_uom_conversions`, CONSTRAINT `tbl_uom_conversions_ibfk_3` FOREIGN KEY (`Product_ID`) REFERENCES `tbl_stock_products` (`Product_ID`))
)

INSERT INTO tbl_uom_conversions                                                      (uom_from,                                                     conversion_amount,                                                     uom_to,                                                     Product_ID,                                                     is_default,                                                     Bar_Code,                                                     additional_barcodes                                                     )                                                     VALUES(?,1,?,?,1,?,?)                                                     
Array
(
    [0] => 67
    [1] => 67
    [2] => 0
    [3] => 655
    [4] => 
)


===============================================================================
User: 1  |  Time: 09:16:58  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => HY093
    [1] => 
    [2] => 
)

INSERT INTO tbl_stock_products                                             (                                                 Product_Code,                                                 Product_Name,                                                 Product_Arabic_Name,                                                 Category_ID,                                                 Product_Reorder_Point,                                                 Product_VAT,                                                 vat_percent,vat2_percent,                                                 PLU_Type,                                                 Product_PLU,                                                 on_scale,                                                 UOM_ID,                                                 is_tax,                                                 product_description,                                                 product_color,                                                 product_order,                                                 printer_id,                                                 product_type,                                                 Product_Limit_Discount,                                                 group_account_id,                                                 brand_id,pur_cat_id,                                                 link_note,                                                 date_created,                                                 created_logged_id,                                                 date_time,                                                 Logged_ID,                                                 section_id,                                                 machine_type_id,is_expiry,force_change_price,duration_reservation,                                                 default_view_uom_id,default_view_rate,is_lot,is_serial,main_supplier_id,                                                 family_id,default_sales_uom,default_purchase_uom,is_service,is_ticket,                                                 product_second_code,recipe_qty,product_param1,product_param2,product_param3,product_param4,print_uom_id,is_rate,branch_id                                                 ,is_rate_type_one                                                 ,is_rate_type_two                                                 ,n_width                                                  ,n_height                                                 ,effect_qty_link_product                                              )                                                 VALUES                                             (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Array
(
    [0] => 6558877
    [1] => test branch product1
    [2] => 
    [3] => 78
    [4] => 
    [5] => 0
    [6] => 
    [7] => 0
    [8] => N
    [9] => 6558877
    [10] => 0
    [11] => 67
    [12] => 0
    [13] => 
    [14] => #4c0870
    [15] => 
    [16] => 
    [17] => 0
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 2023-11-23 09:16:58
    [24] => 1
    [25] => 2023-11-23 09:16:58
    [26] => 1
    [27] => 
    [28] => 0
    [29] => 0
    [30] => 0
    [31] => 0
    [32] => 67
    [33] => 1
    [34] => 0
    [35] => 0
    [36] => 
    [37] => 
    [38] => 0
    [39] => 0
    [40] => 0
    [41] => 0
    [42] => 
    [43] => 1
    [44] => 
    [45] => 
    [46] => 
    [47] => 
    [48] => 0
    [49] => 0
    [50] => 1
    [51] => 0
    [52] => 0
    [53] => 0
    [54] => 0
    [55] => 0
    [56] => 0
)


===============================================================================
User: 1  |  Time: 09:16:58  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => 23000
    [1] => 1452
    [2] => Cannot add or update a child row: a foreign key constraint fails (`apple_clinic_update`.`tbl_uom_conversions`, CONSTRAINT `tbl_uom_conversions_ibfk_3` FOREIGN KEY (`Product_ID`) REFERENCES `tbl_stock_products` (`Product_ID`))
)

INSERT INTO tbl_uom_conversions                                                      (uom_from,                                                     conversion_amount,                                                     uom_to,                                                     Product_ID,                                                     is_default,                                                     Bar_Code,                                                     additional_barcodes                                                     )                                                     VALUES(?,1,?,?,1,?,?)                                                     
Array
(
    [0] => 67
    [1] => 67
    [2] => 0
    [3] => 6558877
    [4] => 
)


===============================================================================
User: 1  |  Time: 09:17:35  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => HY093
    [1] => 
    [2] => 
)

INSERT INTO tbl_stock_products                                             (                                                 Product_Code,                                                 Product_Name,                                                 Product_Arabic_Name,                                                 Category_ID,                                                 Product_Reorder_Point,                                                 Product_VAT,                                                 vat_percent,vat2_percent,                                                 PLU_Type,                                                 Product_PLU,                                                 on_scale,                                                 UOM_ID,                                                 is_tax,                                                 product_description,                                                 product_color,                                                 product_order,                                                 printer_id,                                                 product_type,                                                 Product_Limit_Discount,                                                 group_account_id,                                                 brand_id,pur_cat_id,                                                 link_note,                                                 date_created,                                                 created_logged_id,                                                 date_time,                                                 Logged_ID,                                                 section_id,                                                 machine_type_id,is_expiry,force_change_price,duration_reservation,                                                 default_view_uom_id,default_view_rate,is_lot,is_serial,main_supplier_id,                                                 family_id,default_sales_uom,default_purchase_uom,is_service,is_ticket,                                                 product_second_code,recipe_qty,product_param1,product_param2,product_param3,product_param4,print_uom_id,is_rate,branch_id                                                 ,is_rate_type_one                                                 ,is_rate_type_two                                                 ,n_width                                                  ,n_height                                                 ,effect_qty_link_product                                              )                                                 VALUES                                             (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Array
(
    [0] => 6558877
    [1] => test branch product187878
    [2] => 
    [3] => 78
    [4] => 
    [5] => 0
    [6] => 
    [7] => 0
    [8] => N
    [9] => 6558877
    [10] => 0
    [11] => 67
    [12] => 0
    [13] => 
    [14] => #4c0870
    [15] => 
    [16] => 
    [17] => 0
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 2023-11-23 09:17:35
    [24] => 1
    [25] => 2023-11-23 09:17:35
    [26] => 1
    [27] => 
    [28] => 0
    [29] => 0
    [30] => 0
    [31] => 0
    [32] => 67
    [33] => 1
    [34] => 0
    [35] => 0
    [36] => 
    [37] => 
    [38] => 0
    [39] => 0
    [40] => 0
    [41] => 0
    [42] => 
    [43] => 1
    [44] => 
    [45] => 
    [46] => 
    [47] => 
    [48] => 0
    [49] => 0
    [50] => 1
    [51] => 0
    [52] => 0
    [53] => 0
    [54] => 0
    [55] => 0
    [56] => 0
)


===============================================================================
User: 1  |  Time: 09:17:35  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => 23000
    [1] => 1452
    [2] => Cannot add or update a child row: a foreign key constraint fails (`apple_clinic_update`.`tbl_uom_conversions`, CONSTRAINT `tbl_uom_conversions_ibfk_3` FOREIGN KEY (`Product_ID`) REFERENCES `tbl_stock_products` (`Product_ID`))
)

INSERT INTO tbl_uom_conversions                                                      (uom_from,                                                     conversion_amount,                                                     uom_to,                                                     Product_ID,                                                     is_default,                                                     Bar_Code,                                                     additional_barcodes                                                     )                                                     VALUES(?,1,?,?,1,?,?)                                                     
Array
(
    [0] => 67
    [1] => 67
    [2] => 0
    [3] => 6558877
    [4] => 
)


===============================================================================
User: 1  |  Time: 09:17:55  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => HY093
    [1] => 
    [2] => 
)

INSERT INTO tbl_stock_products                                             (                                                 Product_Code,                                                 Product_Name,                                                 Product_Arabic_Name,                                                 Category_ID,                                                 Product_Reorder_Point,                                                 Product_VAT,                                                 vat_percent,vat2_percent,                                                 PLU_Type,                                                 Product_PLU,                                                 on_scale,                                                 UOM_ID,                                                 is_tax,                                                 product_description,                                                 product_color,                                                 product_order,                                                 printer_id,                                                 product_type,                                                 Product_Limit_Discount,                                                 group_account_id,                                                 brand_id,pur_cat_id,                                                 link_note,                                                 date_created,                                                 created_logged_id,                                                 date_time,                                                 Logged_ID,                                                 section_id,                                                 machine_type_id,is_expiry,force_change_price,duration_reservation,                                                 default_view_uom_id,default_view_rate,is_lot,is_serial,main_supplier_id,                                                 family_id,default_sales_uom,default_purchase_uom,is_service,is_ticket,                                                 product_second_code,recipe_qty,product_param1,product_param2,product_param3,product_param4,print_uom_id,is_rate,branch_id                                                 ,is_rate_type_one                                                 ,is_rate_type_two                                                 ,n_width                                                  ,n_height                                                 ,effect_qty_link_product                                              )                                                 VALUES                                             (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Array
(
    [0] => 6558877
    [1] => test branch product187878
    [2] => 
    [3] => 78
    [4] => 
    [5] => 0
    [6] => 
    [7] => 0
    [8] => N
    [9] => 6558877
    [10] => 0
    [11] => 68
    [12] => 0
    [13] => 
    [14] => #4c0870
    [15] => 
    [16] => 
    [17] => 0
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 2023-11-23 09:17:55
    [24] => 1
    [25] => 2023-11-23 09:17:55
    [26] => 1
    [27] => 
    [28] => 0
    [29] => 0
    [30] => 0
    [31] => 0
    [32] => 68
    [33] => 1
    [34] => 0
    [35] => 0
    [36] => 
    [37] => 
    [38] => 0
    [39] => 0
    [40] => 0
    [41] => 0
    [42] => 
    [43] => 1
    [44] => 
    [45] => 
    [46] => 
    [47] => 
    [48] => 0
    [49] => 0
    [50] => 1
    [51] => 0
    [52] => 0
    [53] => 0
    [54] => 0
    [55] => 0
    [56] => 0
)


===============================================================================
User: 1  |  Time: 09:17:55  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => 23000
    [1] => 1452
    [2] => Cannot add or update a child row: a foreign key constraint fails (`apple_clinic_update`.`tbl_uom_conversions`, CONSTRAINT `tbl_uom_conversions_ibfk_3` FOREIGN KEY (`Product_ID`) REFERENCES `tbl_stock_products` (`Product_ID`))
)

INSERT INTO tbl_uom_conversions                                                      (uom_from,                                                     conversion_amount,                                                     uom_to,                                                     Product_ID,                                                     is_default,                                                     Bar_Code,                                                     additional_barcodes                                                     )                                                     VALUES(?,1,?,?,1,?,?)                                                     
Array
(
    [0] => 68
    [1] => 68
    [2] => 0
    [3] => 6558877
    [4] => 
)


===============================================================================
User: 1  |  Time: 09:20:14  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => HY093
    [1] => 
    [2] => 
)

INSERT INTO tbl_stock_products                                             (                                                 Product_Code,                                                 Product_Name,                                                 Product_Arabic_Name,                                                 Category_ID,                                                 Product_Reorder_Point,                                                 Product_VAT,                                                 vat_percent,vat2_percent,                                                 PLU_Type,                                                 Product_PLU,                                                 on_scale,                                                 UOM_ID,                                                 is_tax,                                                 product_description,                                                 product_color,                                                 product_order,                                                 printer_id,                                                 product_type,                                                 Product_Limit_Discount,                                                 group_account_id,                                                 brand_id,pur_cat_id,                                                 link_note,                                                 date_created,                                                 created_logged_id,                                                 date_time,                                                 Logged_ID,                                                 section_id,                                                 machine_type_id,is_expiry,force_change_price,duration_reservation,                                                 default_view_uom_id,default_view_rate,is_lot,is_serial,main_supplier_id,                                                 family_id,default_sales_uom,default_purchase_uom,is_service,is_ticket,                                                 product_second_code,recipe_qty,product_param1,product_param2,product_param3,product_param4,print_uom_id,is_rate,branch_id                                                 ,is_rate_type_one                                                 ,is_rate_type_two                                                 ,n_width                                                  ,n_height                                                 ,effect_qty_link_product                                              )                                                 VALUES                                             (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Array
(
    [0] => 6558877
    [1] => test branch product187878
    [2] => 
    [3] => 78
    [4] => 
    [5] => 0
    [6] => 
    [7] => 0
    [8] => N
    [9] => 6558877
    [10] => 0
    [11] => 68
    [12] => 0
    [13] => 
    [14] => #4c0870
    [15] => 
    [16] => 
    [17] => 0
    [18] => 
    [19] => 
    [20] => 
    [21] => 
    [22] => 
    [23] => 2023-11-23 09:20:14
    [24] => 1
    [25] => 2023-11-23 09:20:14
    [26] => 1
    [27] => 
    [28] => 0
    [29] => 0
    [30] => 0
    [31] => 0
    [32] => 68
    [33] => 1
    [34] => 0
    [35] => 0
    [36] => 
    [37] => 
    [38] => 0
    [39] => 0
    [40] => 0
    [41] => 0
    [42] => 
    [43] => 1
    [44] => 
    [45] => 
    [46] => 
    [47] => 
    [48] => 0
    [49] => 0
    [50] => 1
    [51] => 0
    [52] => 0
    [53] => 0
    [54] => 0
    [55] => 0
    [56] => 0
)


===============================================================================
User: 1  |  Time: 09:20:14  |  URL: /apple_clinic_compare/InventoryAjax/addProductAjax

Array
(
    [0] => 23000
    [1] => 1452
    [2] => Cannot add or update a child row: a foreign key constraint fails (`apple_clinic_update`.`tbl_uom_conversions`, CONSTRAINT `tbl_uom_conversions_ibfk_3` FOREIGN KEY (`Product_ID`) REFERENCES `tbl_stock_products` (`Product_ID`))
)

INSERT INTO tbl_uom_conversions                                                      (uom_from,                                                     conversion_amount,                                                     uom_to,                                                     Product_ID,                                                     is_default,                                                     Bar_Code,                                                     additional_barcodes                                                     )                                                     VALUES(?,1,?,?,1,?,?)                                                     
Array
(
    [0] => 68
    [1] => 68
    [2] => 0
    [3] => 6558877
    [4] => 
)


===============================================================================
User: 1  |  Time: 11:09:15  |  URL: /apple_clinic_compare/InventoryAjax/getProdCatData?cat_id=77&_=1700730532358

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 11:09:20  |  URL: /apple_clinic_compare/InventoryAjax/POSCatAjax?cmd=edit

Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'multi_branch_id1' in 'field list'
)

UPDATE tbl_product_cat SET Cat_Name = ?,hide_pos=?,order_id=?,             category_color = ?,Parent_ID = ?,category_description = ?,category_prefix_barcode = ?,multi_branch_id1 = ? WHERE Cat_ID = ? 
Array
(
    [0] => new phones
    [1] => 0
    [2] => 0
    [3] => 
    [4] => 0
    [5] => 
    [6] => 
    [7] => 4
    [8] => 77
)


===============================================================================
User: 1  |  Time: 11:09:37  |  URL: /apple_clinic_compare/InventoryAjax/POSCatAjax?cmd=add

Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'multi_branch_id1' in 'field list'
)

INSERT INTO tbl_product_cat (Cat_Name,Parent_ID,hide_pos,order_id,category_color,category_description,category_prefix_barcode,multi_branch_id1) VALUES (?,?,?,?,?,?,?,?)
Array
(
    [0] => cat3
    [1] => 0
    [2] => 0
    [3] => 0
    [4] => 
    [5] => 
    [6] => 
    [7] => 1
)


===============================================================================
User: 1  |  Time: 11:09:58  |  URL: /apple_clinic_compare/InventoryAjax/POSCatAjax?cmd=add

Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'multi_branch_id1' in 'field list'
)

INSERT INTO tbl_product_cat (Cat_Name,Parent_ID,hide_pos,order_id,category_color,category_description,category_prefix_barcode,multi_branch_id1) VALUES (?,?,?,?,?,?,?,?)
Array
(
    [0] => vsdfsf
    [1] => 0
    [2] => 0
    [3] => 
    [4] => 
    [5] => 
    [6] => 
    [7] => 4
)


===============================================================================
User: 1  |  Time: 11:10:04  |  URL: /apple_clinic_compare/InventoryAjax/getProdCatData?cat_id=79&_=1700730532360

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 11:34:07  |  URL: /apple_clinic_compare/InventoryAjax/POSCatAjax?cmd=add

Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'multi_branch_id1' in 'field list'
)

INSERT INTO tbl_product_cat (Cat_Name,Parent_ID,hide_pos,order_id,category_color,category_description,category_prefix_barcode,multi_branch_id1) VALUES (?,?,?,?,?,?,?,?)
Array
(
    [0] => refgrt
    [1] => 0
    [2] => 0
    [3] => 0
    [4] => 
    [5] => 
    [6] => 
    [7] => 
)


===============================================================================
User: 1  |  Time: 11:44:07  |  URL: /apple_clinic_compare/InventoryAjax/POSCatAjax?cmd=add

Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'multi_branch_id1' in 'field list'
)

INSERT INTO tbl_product_cat (Cat_Name,Parent_ID,hide_pos,order_id,category_color,category_description,category_prefix_barcode,multi_branch_id1) VALUES (?,?,?,?,?,?,?,?)
Array
(
    [0] => asdasdasd
    [1] => 0
    [2] => 0
    [3] => 0
    [4] => 
    [5] => 
    [6] => 
    [7] => 
)


===============================================================================
User: 1  |  Time: 11:48:12  |  URL: /apple_clinic_compare/InventoryAjax/POSCatAjax?cmd=add

Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'multi_branch_id1' in 'field list'
)

INSERT INTO tbl_product_cat (Cat_Name,Parent_ID,hide_pos,order_id,category_color,category_description,category_prefix_barcode,multi_branch_id1) VALUES (?,?,?,?,?,?,?,?)
Array
(
    [0] => asdasd
    [1] => 0
    [2] => 0
    [3] => 0
    [4] => 
    [5] => 
    [6] => 
    [7] => 
)


===============================================================================
User: 1  |  Time: 11:56:52  |  URL: /apple_clinic_compare/InventoryAjax/POSCatAjax?cmd=add

Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'multi_branch_id1' in 'field list'
)

INSERT INTO tbl_product_cat (Cat_Name,Parent_ID,hide_pos,order_id,category_color,category_description,category_prefix_barcode,multi_branch_id1) VALUES (?,?,?,?,?,?,?,?)
Array
(
    [0] => asdasd
    [1] => 0
    [2] => 0
    [3] => 0
    [4] => 
    [5] => 
    [6] => 
    [7] => 
)


===============================================================================
User: 1  |  Time: 12:00:35  |  URL: /apple_clinic_compare/InventoryAjax/getProdCatData?cat_id=80&_=1700732881734

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 12:22:53  |  URL: /apple_clinic_compare/InventoryAjax/getProdCatData?cat_id=79&_=1700734967554

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 12:23:01  |  URL: /apple_clinic_compare/InventoryAjax/getProdCatData?cat_id=78&_=1700734967555

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 15  |  Time: 12:24:27  |  URL: /apple_clinic_compare/Inventory

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and branch_id ="4"' at line 1
)

SELECT count(*) as customer_count FROM `tbl_customers`  and branch_id ="4" 


===============================================================================
User: 15  |  Time: 12:25:01  |  URL: /apple_clinic_compare/Inventory

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and branch_id ="4"' at line 1
)

SELECT count(*) as customer_count FROM `tbl_customers`  and branch_id ="4" 


===============================================================================
User: 15  |  Time: 12:35:04  |  URL: /apple_clinic_compare/Inventory

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and branch_id ="4"' at line 1
)

SELECT count(*) as customer_count FROM `tbl_customers`  and branch_id ="4" 


===============================================================================
User: 15  |  Time: 12:35:31  |  URL: /apple_clinic_compare/Inventory

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and branch_id ="4"' at line 1
)

SELECT count(*) as customer_count FROM `tbl_customers`  and branch_id ="4" 


===============================================================================
User: 1  |  Time: 14:47:11  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=66&_=1700743619233

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:47:20  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=67&_=1700743619234

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:47:28  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=77&_=1700743619235

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:47:38  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=76&_=1700743619236

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:47:48  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=68&_=1700743619237

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:47:59  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=69&_=1700743619238

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:48:12  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=70&_=1700743619239

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:48:23  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=71&_=1700743619240

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:48:31  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=72&_=1700743619241

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:48:41  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=73&_=1700743619242

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:48:48  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=74&_=1700743619243

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 14:48:58  |  URL: /customers/apple_clinic_new/InventoryAjax/getProdCatData?cat_id=75&_=1700743619244

Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 7
)

select                                         branch_id  as id,                                         branch_name as text                                    from                                         tbl_organization_branches                                    where                                          branch_id IN ()         


===============================================================================
User: 1  |  Time: 15:15:09  |  URL: /customers/apple_clinic_new/StockAjax/RequestOrderAjax

Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'HCQRW25WC1' in 'where clause'
)

select sum(Product_Quantity*if(Operation_Type="+",1,-1)) as qty,serial_nb,Product_ID,Depot_ID             from tbl_stock_product_transactions              where Product_ID in (1720,1725,1788,1789,1797,1696,1815,1816,1818,1819,1820,1821,1822,1824)                 and Depot_ID in (1)                      and serial_nb in (HCQRW25WC1,K07F9HP16Y,HNWQX664QG,CM7DP4MX2X,PKVK4NKX1F,353938205774775,JRGWLXL4QL,DRH6XD6J03,G5Y7K4HX3T,GQ4YT07FVC,GNWKDW9KTW,J0VQGX72Y4,JJGX9P9576,JK7G4L071H)                         group by Product_ID,Depot_ID,serial_nb             


===============================================================================
User: 1  |  Time: 15:15:22  |  URL: /customers/apple_clinic_new/StockAjax/RequestOrderAjax

Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'HCQRW25WC1' in 'where clause'
)

select sum(Product_Quantity*if(Operation_Type="+",1,-1)) as qty,serial_nb,Product_ID,Depot_ID             from tbl_stock_product_transactions              where Product_ID in (1720,1725,1788,1789,1797,1696,1815,1816,1818,1819,1820,1821,1822,1824)                 and Depot_ID in (1)                      and serial_nb in (HCQRW25WC1,K07F9HP16Y,HNWQX664QG,CM7DP4MX2X,PKVK4NKX1F,353938205774775,JRGWLXL4QL,DRH6XD6J03,G5Y7K4HX3T,GQ4YT07FVC,GNWKDW9KTW,J0VQGX72Y4,JJGX9P9576,JK7G4L071H)                         group by Product_ID,Depot_ID,serial_nb             
