[2026-10-18 14:19:42] live.EMERGENCY: File:/home/mindwbzq/public_html/app/Http/Controllers/ImportProductsController.phpLine:625Message:Unit with name Pieces(Pcs) not found in row no. 1. You can add unit from Products > Units  
[2026-10-18 14:26:22] live.EMERGENCY: File:/home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.phpLine:780Message:No query results for model [App\Variation].  
[2026-10-18 14:27:14] live.EMERGENCY: File:/home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.phpLine:780Message:No query results for model [App\Variation].  
[2026-10-18 16:02:00] live.EMERGENCY: File:/home/mindwbzq/public_html/app/Http/Controllers/ImportOpeningStockMultiLocationController.phpLine:270Message:Column 1 header must be SKU.  
[2026-10-18 17:34:36] live.EMERGENCY: File:/home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.phpLine:780Message:No query results for model [App\Variation].  
[2026-10-18 17:35:07] live.EMERGENCY: File:/home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.phpLine:780Message:No query results for model [App\Variation].  
[2026-10-18 17:35:33] live.EMERGENCY: File:/home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.phpLine:780Message:No query results for model [App\Variation].  
[2026-10-18 17:36:44] live.EMERGENCY: File:/home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.phpLine:780Message:No query results for model [App\Variation].  
[2026-10-18 17:36:55] live.EMERGENCY: File:/home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.phpLine:780Message:No query results for model [App\Variation].  
[2026-10-18 22:31:43] live.EMERGENCY: File:/home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.phpLine:780Message:No query results for model [App\Variation].  
[2026-10-18 23:16:25] live.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 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 '\", \") as refund_no from `transactions` as `sr` where `sr`.`type` = ? and `s...' at line 1 (Connection: mysql, Host: localhost, Port: 3306, Database: mindwbzq_pos, SQL: select count(*) as aggregate from (select `transaction_sell_lines`.`id`, `sr_agg`.`refund_date` as `refund_date`, `sr_agg`.`refund_no` as `refund_no`, `t`.`id` as `transaction_id`, `t`.`invoice_no`, `t`.`transaction_date` as `sale_date`, `bl`.`name` as `business_location`, CONCAT(COALESCE(u.surname, ''), ' ', COALESCE(u.first_name, ''), ' ', COALESCE(u.last_name, '')) as added_by, `c`.`name` as `customer_name`, `c`.`supplier_business_name`, `p`.`name` as `product_name`, `p`.`type` as `product_type`, `pv`.`name` as `product_variation_name`, `v`.`name` as `variation_name`, `v`.`sub_sku` as `sku`, `u`.`short_name` as `unit`, `transaction_sell_lines`.`quantity` as `sold_qty`, `transaction_sell_lines`.`quantity_returned` as `refunded_qty`, `transaction_sell_lines`.`unit_price_inc_tax` as `unit_price_inc_tax`, (SELECT GROUP_CONCAT(ps.serial_no ORDER BY COALESCE(ps.received_at, ps.created_at), ps.id SEPARATOR ", ") FROM product_serials ps WHERE ps.sell_line_id = transaction_sell_lines.id AND ps.return_id IS NOT NULL) as serial_numbers, (transaction_sell_lines.quantity_returned * transaction_sell_lines.unit_price_inc_tax) as refunded_amount from `transaction_sell_lines` inner join `transactions` as `t` on `transaction_sell_lines`.`transaction_id` = `t`.`id` left join `users` as `u` on `t`.`created_by` = `u`.`id` inner join (select sr.return_parent_id as sale_id, MAX(sr.transaction_date) as refund_date, GROUP_CONCAT(DISTINCT sr.invoice_no ORDER BY sr.transaction_date SEPARATOR \", \") as refund_no from `transactions` as `sr` where `sr`.`type` = sell_return and `sr`.`status` = final and LOWER(COALESCE(sr.custom_field_1,'')) != 'exchange' group by `sr`.`return_parent_id`) as `sr_agg` on `sr_agg`.`sale_id` = `t`.`id` inner join `business_locations` as `bl` on `t`.`location_id` = `bl`.`id` inner join `contacts` as `c` on `t`.`contact_id` = `c`.`id` inner join `variations` as `v` on `transaction_sell_lines`.`variation_id` = `v`.`id` inner join `product_variations` as `pv` on `v`.`product_variation_id` = `pv`.`id` inner join `products` as `p` on `pv`.`product_id` = `p`.`id` left join `units` as `u` on `p`.`unit_id` = `u`.`id` where `t`.`business_id` = 1 and `t`.`type` = sell and `t`.`status` = final and `transaction_sell_lines`.`parent_sell_line_id` is null and `transaction_sell_lines`.`quantity_returned` > 0 and date(`sr_agg`.`refund_date`) >= 2026-10-18 and date(`sr_agg`.`refund_date`) <= 2026-10-18 group by `transaction_sell_lines`.`id` order by `sr_agg`.`refund_date` desc) count_row_table) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 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 '\\\", \\\") as refund_no from `transactions` as `sr` where `sr`.`type` = ? and `s...' at line 1 (Connection: mysql, Host: localhost, Port: 3306, Database: mindwbzq_pos, SQL: select count(*) as aggregate from (select `transaction_sell_lines`.`id`, `sr_agg`.`refund_date` as `refund_date`, `sr_agg`.`refund_no` as `refund_no`, `t`.`id` as `transaction_id`, `t`.`invoice_no`, `t`.`transaction_date` as `sale_date`, `bl`.`name` as `business_location`, CONCAT(COALESCE(u.surname, ''), ' ', COALESCE(u.first_name, ''), ' ', COALESCE(u.last_name, '')) as added_by, `c`.`name` as `customer_name`, `c`.`supplier_business_name`, `p`.`name` as `product_name`, `p`.`type` as `product_type`, `pv`.`name` as `product_variation_name`, `v`.`name` as `variation_name`, `v`.`sub_sku` as `sku`, `u`.`short_name` as `unit`, `transaction_sell_lines`.`quantity` as `sold_qty`, `transaction_sell_lines`.`quantity_returned` as `refunded_qty`, `transaction_sell_lines`.`unit_price_inc_tax` as `unit_price_inc_tax`, (SELECT GROUP_CONCAT(ps.serial_no ORDER BY COALESCE(ps.received_at, ps.created_at), ps.id SEPARATOR \", \") FROM product_serials ps WHERE ps.sell_line_id = transaction_sell_lines.id AND ps.return_id IS NOT NULL) as serial_numbers, (transaction_sell_lines.quantity_returned * transaction_sell_lines.unit_price_inc_tax) as refunded_amount from `transaction_sell_lines` inner join `transactions` as `t` on `transaction_sell_lines`.`transaction_id` = `t`.`id` left join `users` as `u` on `t`.`created_by` = `u`.`id` inner join (select sr.return_parent_id as sale_id, MAX(sr.transaction_date) as refund_date, GROUP_CONCAT(DISTINCT sr.invoice_no ORDER BY sr.transaction_date SEPARATOR \\\", \\\") as refund_no from `transactions` as `sr` where `sr`.`type` = sell_return and `sr`.`status` = final and LOWER(COALESCE(sr.custom_field_1,'')) != 'exchange' group by `sr`.`return_parent_id`) as `sr_agg` on `sr_agg`.`sale_id` = `t`.`id` inner join `business_locations` as `bl` on `t`.`location_id` = `bl`.`id` inner join `contacts` as `c` on `t`.`contact_id` = `c`.`id` inner join `variations` as `v` on `transaction_sell_lines`.`variation_id` = `v`.`id` inner join `product_variations` as `pv` on `v`.`product_variation_id` = `pv`.`id` inner join `products` as `p` on `pv`.`product_id` = `p`.`id` left join `units` as `u` on `p`.`unit_id` = `u`.`id` where `t`.`business_id` = 1 and `t`.`type` = sell and `t`.`status` = final and `transaction_sell_lines`.`parent_sell_line_id` is null and `transaction_sell_lines`.`quantity_returned` > 0 and date(`sr_agg`.`refund_date`) >= 2026-10-18 and date(`sr_agg`.`refund_date`) <= 2026-10-18 group by `transaction_sell_lines`.`id` order by `sr_agg`.`refund_date` desc) count_row_table) at /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:838)
[stacktrace]
#0 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(794): Illuminate\\Database\\Connection->runQueryCallback()
#1 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(411): Illuminate\\Database\\Connection->run()
#2 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3505): Illuminate\\Database\\Connection->select()
#3 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3490): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(4080): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3489): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(4004): Illuminate\\Database\\Query\\Builder->get()
#7 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3932): Illuminate\\Database\\Query\\Builder->aggregate()
#8 /home/mindwbzq/public_html/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(183): Illuminate\\Database\\Query\\Builder->count()
#9 /home/mindwbzq/public_html/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php(712): Yajra\\DataTables\\QueryDataTable->count()
#10 /home/mindwbzq/public_html/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(166): Yajra\\DataTables\\DataTableAbstract->totalCount()
#11 /home/mindwbzq/public_html/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(138): Yajra\\DataTables\\QueryDataTable->prepareQuery()
#12 /home/mindwbzq/public_html/app/Http/Controllers/ReportController.php(3079): Yajra\\DataTables\\QueryDataTable->make()
#13 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\ReportController->refundedItemsReport()
#14 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction()
#15 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#16 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController()
#17 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run()
#18 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#19 /home/mindwbzq/public_html/app/Http/Middleware/CheckUserLogin.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#20 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\CheckUserLogin->handle()
#21 /home/mindwbzq/public_html/app/Http/Middleware/AdminSidebarMenu.php(23): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\AdminSidebarMenu->handle()
#23 /home/mindwbzq/public_html/app/Http/Middleware/Timezone.php(42): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\Timezone->handle()
#25 /home/mindwbzq/public_html/app/Http/Middleware/Language.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\Language->handle()
#27 /home/mindwbzq/public_html/app/Http/Middleware/SetSessionData.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\SetSessionData->handle()
#29 /home/mindwbzq/public_html/app/Http/Middleware/IsInstalled.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#30 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\IsInstalled->handle()
#31 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#33 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#35 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(87): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#37 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(48): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#39 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#41 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle()
#42 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(36): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#43 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#44 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(74): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#46 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then()
#48 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack()
#49 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute()
#50 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute()
#51 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch()
#52 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#53 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#54 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#55 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#56 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#57 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#58 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#59 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#60 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle()
#61 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#62 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#63 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#64 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle()
#65 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#66 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#67 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#68 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then()
#69 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#70 /home/mindwbzq/public_html/public/index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle()
#71 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 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 '\\\", \\\") as refund_no from `transactions` as `sr` where `sr`.`type` = ? and `s...' at line 1 at /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:420)
[stacktrace]
#0 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(420): PDO->prepare()
#1 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(827): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(794): Illuminate\\Database\\Connection->runQueryCallback()
#3 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(411): Illuminate\\Database\\Connection->run()
#4 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3505): Illuminate\\Database\\Connection->select()
#5 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3490): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(4080): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3489): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(4004): Illuminate\\Database\\Query\\Builder->get()
#9 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3932): Illuminate\\Database\\Query\\Builder->aggregate()
#10 /home/mindwbzq/public_html/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(183): Illuminate\\Database\\Query\\Builder->count()
#11 /home/mindwbzq/public_html/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php(712): Yajra\\DataTables\\QueryDataTable->count()
#12 /home/mindwbzq/public_html/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(166): Yajra\\DataTables\\DataTableAbstract->totalCount()
#13 /home/mindwbzq/public_html/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(138): Yajra\\DataTables\\QueryDataTable->prepareQuery()
#14 /home/mindwbzq/public_html/app/Http/Controllers/ReportController.php(3079): Yajra\\DataTables\\QueryDataTable->make()
#15 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\\Http\\Controllers\\ReportController->refundedItemsReport()
#16 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction()
#17 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(265): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#18 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(211): Illuminate\\Routing\\Route->runController()
#19 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(822): Illuminate\\Routing\\Route->run()
#20 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#21 /home/mindwbzq/public_html/app/Http/Middleware/CheckUserLogin.php(22): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#22 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\CheckUserLogin->handle()
#23 /home/mindwbzq/public_html/app/Http/Middleware/AdminSidebarMenu.php(23): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#24 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\AdminSidebarMenu->handle()
#25 /home/mindwbzq/public_html/app/Http/Middleware/Timezone.php(42): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#26 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\Timezone->handle()
#27 /home/mindwbzq/public_html/app/Http/Middleware/Language.php(25): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#28 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\Language->handle()
#29 /home/mindwbzq/public_html/app/Http/Middleware/SetSessionData.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#30 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\SetSessionData->handle()
#31 /home/mindwbzq/public_html/app/Http/Middleware/IsInstalled.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#32 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): App\\Http\\Middleware\\IsInstalled->handle()
#33 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#34 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle()
#35 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(63): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#36 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Auth\\Middleware\\Authenticate->handle()
#37 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(87): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle()
#39 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(48): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle()
#41 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(120): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest()
#43 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Session\\Middleware\\StartSession->handle()
#44 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(36): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#45 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle()
#46 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(74): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#47 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle()
#48 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#49 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(821): Illuminate\\Pipeline\\Pipeline->then()
#50 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(800): Illuminate\\Routing\\Router->runRouteWithinStack()
#51 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(764): Illuminate\\Routing\\Router->runRoute()
#52 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(753): Illuminate\\Routing\\Router->dispatchToRoute()
#53 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch()
#54 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#55 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#56 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#57 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle()
#58 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#59 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#60 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle()
#61 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#62 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\ValidatePostSize->handle()
#63 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(109): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#64 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#65 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(61): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#66 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\HandleCors->handle()
#67 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#68 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(219): Illuminate\\Http\\Middleware\\TrustProxies->handle()
#69 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(137): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#70 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then()
#71 /home/mindwbzq/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#72 /home/mindwbzq/public_html/public/index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle()
#73 {main}
"}