insertID bad return

[Google translation]
Hi,

I'm migrating from CI3 to CI4.

I do an insert with the builder and then try to retrieve the primary key ID number.
But the returned ID is not good, I should have a value in the 5XX but I have a value in the 2479XX

My function in model :

Code:

public function insertFiche($val1, $val2){
    $builder = $this->db->table('myTable');
    $data = array(
      'col1' => $val1,
      'col2' => $val2
    );
    $builder->insert($data);
    $insert_id = $this->db->insertID();
    return  $insert_id;
  }

Thanks for your help

Why do you know 2479XX is bad?
It is just a number that your database returned.

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

Hi Kenjis,
I'll try to explain my problem a bit more:

On CI3, when I do an insert and then use insert_id(), it returns me the id of the primary key in auto increment . In my example, looking at the DB, it should have returned 541.

But when I try to migrate to CI4, and use the insertID() function after an insert, the returned value doesn't match at all. It gave me a much higher value.

I hope to be clearer with this explanation and that the Google translation does not break my sentences.

Your code seems good, and should be return correct insert id.
But in fact, it is not.

I don't know why, but I recommend your check all queries in database log (or CI4's debug toolbar).
If the insert id is wrong, there might be another insert before you call insertID().

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

Alternatively, try to find ID 2479 X X in all tables, if there are not so many of them. This will help you find the request that returned the wrong ID

Simple CI 4 project for beginners codeigniter-expenses ( topic )

If the insert id is wrong, there might be another insert before you call insertID().

That's it ! THANKS ! I had completely forgotten that I log each modification in BBD by an insert in a table 'log_bdd' via an event 'Events::on('DBQuery', function($query) {‘. 

The IDs correspond.

Now I have to figure out how to make the log not overwrite the ID in the object or keep the ID to rewrite it after the log.

If the insert id is wrong, there might be another insert before you call insertID().

That's it ! THANKS ! I had completely forgotten that I log each modification in BBD by an insert in a table 'log_bdd' via an event 'Events::on('DBQuery', function($query) {‘. 

The IDs correspond.

Now I have to figure out how to make the log not overwrite the ID in the object or keep the ID to rewrite it after the log.

I was wondering if you managed to find a solution to this as I'm experience the same issue due to a DBQuery event I have created which inserts a record.