Update using WHERE

Yes. All fields are in $allowedFields.

Thanks for helping.

I really think Ci4 update() only wants to update with a primary key. Anything outside of that, it explodes.

Did you set $allowedFields in your model?
https://codeigniter.com/user_guide/model...your-model
$allowedFields

There's an easy way to prove/disprove your theory....

PHP Code:

echo $this->where('activity_id', $activity_id)->getCompiledSelect(); 


It gave me this:

SELECT * FROM `billing_charges_2` WHERE `activity_id` = 8583

---

We had better clarify everything. 

So, in your controller : 

Code:

$activity_id = xyz-whatever;
$data = [
   'activity_id' => NULL
];

$this->YourModel->lets_update_it($data, $activity_id);

Your model : 

Code:

public function lets_update_id($data, $activity_id){
$db      = \Config\Database::connect();
$builder = $db->table('your_table_name');
$query = $builder->where('activity_id', $activity_id)
->update($data);
}

That should work.

YOU NAILED IT!

This query builder has been the most confusing part of Ci4. All my model functions (except for this one) works as expected.

I don't care why at this point.

THANK YOU!!!!!