SQLSTATE[42S22]: Column not found: 1054 Unknown column 'supply_order_type_id' in 'field list' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: backendalhamidin_backendalhamidindb, SQL: insert into `sup_supply_orders` (`status`, `supply_order_type_id`, `supplier_id`, `location_id`, `currency_id`, `customer_id`, `code`, `company_id`, `updated_at`, `created_at`) values (new, 1, 1, 1, 1, 1, PO-2026-0001, 1, 2026-05-14 07:02:13, 2026-05-14 07:02:13))
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->run(string, array, object(Closure))Illuminate\Database\MySqlConnection->insert(string, array, string)Illuminate\Database\Query\Processors\MySqlProcessor->processInsertGetId(object(Illuminate\Database\Query\Builder), string, array, string)Illuminate\Database\Query\Builder->insertGetId(array, string)Illuminate\Database\Eloquent\Builder->__call(string, array)Illuminate\Database\Eloquent\Model->insertAndSetId(object(Illuminate\Database\Eloquent\Builder), array)Illuminate\Database\Eloquent\Model->performInsert(object(Illuminate\Database\Eloquent\Builder))Illuminate\Database\Eloquent\Model->save()32 $order->supply_order_type_id = 1;33 $order->supplier_id = 1; 34 $order->location_id = 1;35 $order->currency_id = 1;36 $order->customer_id = 1; 37 $order->save();3839 $item = new SupplyOrderItem();40 $item->supply_order_id = $order->id;41 $item->item_description = 'Test Item';42 $item->quantity = 10;43 $item->unit_of_measure = 'pcs';44 // Use a valid item status45 $item->status = SupplyOrderItemStatus::PENDING_DELEGATE->value;46 $item->save();4748 echo "Order created with ID: {$order->id}, Item ID: {$item->id}\n";49{closure:/home/backendalhamidin/public_html/debug_requote_script.php:27}(object(Illuminate\Database\MySqlConnection))Illuminate\Database\Connection->transaction(object(Closure))Illuminate\Database\DatabaseManager->__call(string, array)Illuminate\Support\Facades\Facade::__callStatic(string, array)22 exit(1);23}24auth()->login($user);2526// Create a dummy order and item27DB::transaction(function () {28 echo "Creating test order...\n";29 $order = new SupplyOrder();30 // Use a valid enum value31 $order->status = SupplyOrderStatus::NEW->value; 32 $order->supply_order_type_id = 1;33 $order->supplier_id = 1; 34 $order->location_id = 1;35 $order->currency_id = 1;36 $order->customer_id = 1; 37 $order->save();3839select * from `users` limit 1delete from `sessions` where `id` = '7FMzymaQwyo2iO24w1y1ltj6TDJXtP52w8kSABBY'select * from `sup_supply_orders` where `company_id` = 1 and `code` like 'PO-2026-%' and `sup_supply_orders`.`deleted_at` is null and `sup_supply_orders`.`company_id` = 1 and `sup_supply_orders`.`status` != 'archived' order by `id` desc limit 1