=== CALCULATING CORRECT PROJECT INVENTORY === 1. Inventory Dispatch (MR-INV): +0 2. Direct Deliveries: +0 3. Supplier Delivery to Project: +0 KCG-UAE
Internal Server Error

Illuminate\Database\QueryException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'material_site_transfer_items.material_site_transfer_id' in 'ON' (Connection: mysql, SQL: select sum(`material_site_transfer_items`.`quantity_transferred`) as aggregate from `material_site_transfer_items` inner join `material_site_transfers` on `material_site_transfer_items`.`material_site_transfer_id` = `material_site_transfers`.`id` where `material_site_transfers`.`to_project_id` = 681 and `material_site_transfer_items`.`item_id` = 2114 and `material_site_transfers`.`status` = completed)

LARAVEL 12.31.1
PHP 8.2.30
UNHANDLED
CODE 42S22
GET
http://kcguae.com/wms/public

Overview

DATE
2026/04/14 08:20:05.958 UTC
STATUS CODE
500
METHOD
GET

Exception trace

9 vendor frames 
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))
vendor/laravel/framework/src/Illuminate/Database/Connection.php:824 
Illuminate\Database\Connection->run(string, array, object(Closure))
vendor/laravel/framework/src/Illuminate/Database/Connection.php:778 
Illuminate\Database\Connection->select(string, array, boolean)
vendor/laravel/framework/src/Illuminate/Database/Connection.php:397 
Illuminate\Database\Query\Builder->runSelect()
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3188 
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3173 
Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3763 
Illuminate\Database\Query\Builder->get(array)
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3172 
Illuminate\Database\Query\Builder->aggregate(string, array)
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3687 
Illuminate\Database\Query\Builder->sum(string)
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3648 
check_double_add.php
check_double_add.php:50 
45$transfersIn = DB::table('material_site_transfer_items')
46    ->join('material_site_transfers', 'material_site_transfer_items.material_site_transfer_id', '=', 'material_site_transfers.id')
47    ->where('material_site_transfers.to_project_id', $projectId)
48    ->where('material_site_transfer_items.item_id', $itemId)
49    ->where('material_site_transfers.status', 'completed')
50    ->sum('material_site_transfer_items.quantity_transferred');
51
52echo "4. Site Transfers IN: +{$transfersIn}\n";
53
54// Site Returns (subtract)
55$siteReturns = DB::table('incoming_operation_items')
56    ->join('incoming_operations', 'incoming_operation_items.incoming_operation_id', '=', 'incoming_operations.id')
57    ->where('incoming_operations.project_id', $projectId)
58    ->where('incoming_operations.operation_type', 'site_return')
59    ->where('incoming_operation_items.item_id', $itemId)
60    ->where('incoming_operations.status', 'completed')
61    ->sum(DB::raw('GREATEST(incoming_operation_items.quantity_delivered, incoming_operation_items.quantity_accepted)'));
62

Queries

mysql 
select sum(`outgoing_items`.`quantity_released`) as aggregate from `outgoing_items` inner join `outgoing_transactions` on `outgoing_items`.`outgoing_transaction_id` = `outgoing_transactions`.`id` where `outgoing_transactions`.`project_id` = 681 and `outgoing_items`.`item_id` = 2114 and `outgoing_transactions`.`status` in ('successful', 'completed') and `outgoing_items`.`quantity_released` > 0
7.31ms
mysql 
select sum(`direct_delivery_items`.`delivered_quantity`) as aggregate from `direct_delivery_items` inner join `direct_deliveries` on `direct_delivery_items`.`direct_delivery_id` = `direct_deliveries`.`id` where `direct_deliveries`.`project_id` = 681 and `direct_delivery_items`.`item_id` = 2114 and `direct_deliveries`.`status` in ('delivered', 'completed')
0.95ms
mysql 
select sum(GREATEST(incoming_operation_items.quantity_delivered, incoming_operation_items.quantity_accepted)) as aggregate from `incoming_operation_items` inner join `incoming_operations` on `incoming_operation_items`.`incoming_operation_id` = `incoming_operations`.`id` where `incoming_operations`.`project_id` = 681 and `incoming_operations`.`operation_type` = 'supplier_delivery' and `incoming_operation_items`.`item_id` = 2114 and `incoming_operations`.`status` = 'completed'
1.23ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
2.07ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
6.02ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
1.28ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
1.38ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.57ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.54ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.44ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.45ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.43ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.42ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.33ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.66ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.63ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
1.76ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.59ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.81ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.48ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.35ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.25ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.2ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.22ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.26ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.36ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.55ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.36ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.54ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
1.47ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.93ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.69ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
1.75ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
1.86ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.68ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.67ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.32ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.75ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
1.41ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
2.22ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.47ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
1.25ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
1.37ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
1.06ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.72ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.7ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.88ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.59ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.38ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.38ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.36ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.45ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.25ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.31ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.57ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
1.78ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
1.24ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.45ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.43ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.52ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.42ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.32ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.49ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.37ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.35ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.27ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.28ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.51ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
1.43ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.61ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.93ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
1.31ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.4ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.36ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
1.71ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
1.59ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
1.29ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.58ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.3ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
1.38ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
1.02ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
1.3ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.62ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
0.39ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.42ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
0.28ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.39ms
mysql 
select * from `site_settings` where (`key` = 'contact_email') limit 1
0.33ms
mysql 
select * from `site_settings` where (`key` = 'contact_phone') limit 1
0.37ms
mysql 
select * from `site_settings` where (`key` = 'contact_address') limit 1
0.32ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_number') limit 1
0.9ms
mysql 
select * from `site_settings` where (`key` = 'whatsapp_enabled') limit 1
0.36ms
mysql 
select * from `site_settings` where (`key` = 'footer_text') limit 1
0.47ms
mysql 
select * from `site_settings` where `is_active` = 1 order by `group` asc, `sort_order` asc
0.61ms
mysql 
select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'site_settings' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
0.66ms
mysql 
select * from `site_settings` where (`key` = 'site_name') limit 1
0.42ms
mysql 
select * from `site_settings` where (`key` = 'site_description') limit 1
1.08ms
mysql 
select * from `site_settings` where (`key` = 'site_logo') limit 1
0.65ms
mysql 
select * from `site_settings` where (`key` = 'site_favicon') limit 1
1.66ms
mysql 
select * from `site_settings` where (`key` = 'admin_favicon') limit 1
0.84ms

Headers

host
kcguae.com
user-agent
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
accept
*/*
accept-language
en-us,en;q=0.5
accept-charset
ISO-8859-1,utf-8;q=0.7,*;q=0.7
accept-encoding
gzip, br, zstd, deflate

Body

// No request body

Routing

// No routing context

Routing parameters

// No routing parameters