Illuminate\Database\QueryException
QueryException
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'total_basic' cannot be null (Connection: mysql, SQL: update `payrolls` set `total_basic` = ?, `total_allowances` = ?, `total_deductions` = ?, `total_net` = ? where `id` = 1)
GET localhost:8000
PHP 8.2.33 — Laravel 11.55.1
vendor/laravel/framework/src/Illuminate/Database/Connection.php
:825
vendor/laravel/framework/src/Illuminate/Database/Connection.php
:779
vendor/laravel/framework/src/Illuminate/Database/Connection.php
:584
vendor/laravel/framework/src/Illuminate/Database/Connection.php
:536
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php
:3830
fix_payroll1.php
:58
Request
GET
/
Headers
host
localhost:8000
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
x-forwarded-for
216.73.216.163
x-forwarded-host
pre-hr.gostcode.com
x-forwarded-port
443
x-forwarded-proto
https
x-forwarded-server
pre-hr.gostcode.com
x-real-ip
216.73.216.163
x-https
1
Body
No body data
Application
Routing
No routing data
Database Queries
mysql
(4.05 ms)
select * from `payroll_runs` where `month` = '2026-06' limit 1
mysql
(0.74 ms)
select * from `payroll_items` where `payroll_id` = 2
mysql
(0.49 ms)
select SUM(basic_salary) as tb, SUM(housing_allowance+transportation_allowance+other_allowances) as ta, SUM(deductions+leave_deduction+social_insurance+tax+loans) as td, SUM(net_salary) as tn from `payroll_items` where `payroll_id` = 1 limit 1