Hello iRedds,
I executed using builder without model:
$db = \Config\Database::connect();
$db->table('my_table')->ignore(true)->insertBatch($data);
However, I get the same error:
Duplicate entry '25-2022-07-05' for key 'id_call'
at SYSTEMPATH/Database/MySQLi/Connection.php:292
Backtrace:
1 SYSTEMPATH/Database/MySQLi/Connection.php:292
mysqli()->query()
2 SYSTEMPATH/Database/BaseConnection.php:670
CodeIgniter\Database\MySQLi\Connection()->execute()
3 SYSTEMPATH/Database/BaseConnection.php:598
CodeIgniter\Database\BaseConnection()->simpleQuery()
4 SYSTEMPATH/Database/BaseBuilder.php:1648
CodeIgniter\Database\BaseConnection()->query()
5 APPPATH/Controllers/Cron.php:312
CodeIgniter\Database\BaseBuilder()->insertBatch()
6 SYSTEMPATH/CodeIgniter.php:832
App\Controllers\Cron()->importDialogaAudioCalls()
7 SYSTEMPATH/CodeIgniter.php:419
CodeIgniter\CodeIgniter()->runController()
8 SYSTEMPATH/CodeIgniter.php:326
CodeIgniter\CodeIgniter()->handleRequest()
9 FCPATH/index.php:37
CodeIgniter\CodeIgniter()->run()
Thank you for your reply,