=== DOTS HR Pro - Fresh Data Seeder === Step 1: Cleaning old data... ✓ Cleaned: notification_recipients ✓ Cleaned: notifications ✓ Cleaned: recognitions ✓ Cleaned: pip_checkpoints ✓ Cleaned: evaluations ✓ Cleaned: evaluation_cycles ✓ Cleaned: evaluation_templates ✓ Cleaned: training_enrollments ✓ Cleaned: training_programs ✓ Cleaned: training_courses ✓ Cleaned: training_paths ✓ Cleaned: succession_candidates ✓ Cleaned: succession_plans ✓ Cleaned: career_path_levels ✓ Cleaned: career_paths ✓ Cleaned: document_reminders ✓ Cleaned: data_change_requests ✓ Cleaned: onboarding_tasks ✓ Cleaned: onboarding_template_tasks ✓ Cleaned: onboarding_templates ✓ Cleaned: offboarding_checklist ✓ Cleaned: offboarding_records ✓ Cleaned: e_signatures ✓ Cleaned: letter_requests ✓ Cleaned: letter_templates ✓ Cleaned: accounting_entry_lines ✓ Cleaned: accounting_entries ✓ Cleaned: payroll_details ✓ Cleaned: payroll_runs ✓ Cleaned: payrolls ✓ Cleaned: expense_claims ✓ Cleaned: business_trips ✓ Cleaned: interviews ✓ Cleaned: applicants ✓ Cleaned: job_postings ✓ Cleaned: leave_balances ✓ Cleaned: leave_requests ✓ Cleaned: attendance_corrections ✓ Cleaned: attendances ✓ Cleaned: contracts ✓ Cleaned: custom_field_values ✓ Cleaned: nationalization_records ✓ Cleaned: saved_reports ✓ Cleaned: announcements ✓ Cleaned: model_has_roles ✓ Cleaned: model_has_permissions ✓ Cleaned: employees ✓ Cleaned: users ✓ Cleaned: departments ✓ Cleaned: job_titles ✓ Cleaned: leave_types ✓ Cleaned: work_periods ✓ Cleaned: work_shifts ✓ Cleaned: pay_scales ✓ Cleaned: cost_centers Step 2: Creating admin user... ✓ Admin role assigned (level_4) ✓ Admin created: admin@dot-hr.com / Admin@123 Step 3: Creating departments... ✓ الإدارة العامة ✓ الموارد البشرية ✓ تقنية المعلومات ✓ المالية والمحاسبة ✓ المبيعات والتسويق ✓ العمليات Step 4: Creating job titles... ✓ Created 15 job titles Step 5: Creating leave types... ✓ إجازة سنوية ✓ إجازة مرضية ✓ إجازة طارئة ✓ إجازة بدون راتب ✓ إجازة زواج ✓ إجازة وفاة ✓ إجازة أمومة ✓ إجازة أبوة Step 6: Creating work shift... ✓ الدوام الرسمي (8:00 - 17:00) Step 7: Creating 15 employees... ✓ EMP-0001 - خالد محمد السعيد (المدير العام) ✓ EMP-0002 - نورة أحمد القحطاني (مدير الموارد البشرية) ✓ EMP-0003 - سارة فهد الحربي (أخصائي موارد بشرية) ✓ EMP-0004 - عمر يوسف الغامدي (مدير تقنية المعلومات) ✓ EMP-0005 - أحمد خالد الشهري (مطور برمجيات أول) ✓ EMP-0006 - ياسر عبدالرحمن المالكي (مطور برمجيات) ✓ EMP-0007 - فاطمة علي العتيبي (فني دعم تقني) ✓ EMP-0008 - عبدالله سعيد الدوسري (المدير المالي) ✓ EMP-0009 - منى عادل الزهراني (محاسب أول) ✓ EMP-0010 - محمد حسين البقمي (محاسب) ✓ EMP-0011 - تركي فيصل العنزي (مدير المبيعات) ✓ EMP-0012 - ريم سامي الشمري (مندوب مبيعات) ✓ EMP-0013 - بندر سلطان المطيري (مدير العمليات) ✓ EMP-0014 - هند ماجد القرني (منسق عمليات) ✓ EMP-0015 - فهد مشاري الحارثي (مساعد إداري) Step 8: Creating contracts... ✓ Created 15 contracts Step 9: Creating attendance records (30 days)... ✓ Created 345 attendance records Step 10: Creating leave balances and requests... ✓ Created leave balances for all employees ✓ Created 34 leave requests Step 11: Creating payroll records... ✓ Created payroll for 3 months Step 12: Creating training data... DOTS HR Pro
Internal Server Error
QueryException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'field list' (Connection: mysql, SQL: insert into `training_courses` (`title`, `category`, `type`, `instructor`, `start_date`, `end_date`, `location`, `duration_hours`, `max_participants`, `is_mandatory`, `status`, `description`, `created_by`, `created_at`, `updated_at`) values (أساسيات الأمن السيبراني, technical, classroom, م. سعود العتيبي, 2026-07-01, 2026-07-03, قاعة التدريب الرئيسية, 24, 20, 1, completed, دورة تدريبية متخصصة في أساسيات الأمن السيبراني, 1, 2026-10-01 01:37:44, 2026-10-01 01:37:44))
vendor/laravel/framework/src/Illuminate/Database/Connection.php :825
vendor/laravel/framework/src/Illuminate/Database/Connection.php :779
vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php :42
vendor/laravel/framework/src/Illuminate/Database/Query/Processors/MySqlProcessor.php :35
vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php :3766
seed_fresh_data.php :599
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 only the first 100 queries are displayed
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'notification_recipients' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `notification_recipients`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'notifications' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `notifications`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'recognition_points' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'recognitions' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `recognitions`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'feedback' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'pip_checkpoints' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `pip_checkpoints`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'performance_improvement_plans' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'okrs' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'evaluations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `evaluations`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'evaluation_cycles' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `evaluation_cycles`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'evaluation_templates' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `evaluation_templates`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'compensation_requests' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'training_enrollments' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `training_enrollments`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'training_programs' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `training_programs`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'training_courses' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `training_courses`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'training_paths' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `training_paths`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'succession_candidates' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `succession_candidates`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'succession_plans' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `succession_plans`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'career_path_levels' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `career_path_levels`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'career_paths' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `career_paths`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'document_reminders' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `document_reminders`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'data_change_requests' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `data_change_requests`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'onboarding_tasks' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `onboarding_tasks`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'onboarding_template_tasks' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `onboarding_template_tasks`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'onboarding_templates' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `onboarding_templates`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'offboarding_checklist' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `offboarding_checklist`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'offboarding_records' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `offboarding_records`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'e_signatures' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `e_signatures`
mysql 
SET FOREIGN_KEY_CHECKS=1;
mysql 
select exists (select 1 from information_schema.tables where table_schema = 'prehrgostcode_hr' and table_name = 'letter_requests' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`
mysql 
SET FOREIGN_KEY_CHECKS=0;
mysql 
truncate table `letter_requests`