Bug with large IN query

It's actually a problem of regex. If the string gets too big it runs run into a recursion limit.

Instead of using Query Builder you might be better off using a hand-crafted query string as an argument to $this->db->query('your hand-crafted query');

Depending on how you are building the "in" list you might be able to break it down into manageable bites. Here's the basic idea.

PHP Code:

$this->db->group_start();
$ids_chunk = array_chunk($all_ids, 250); //or whatever size can be handled
foreach($ids_chunk as $chunk)
{
    $this->db->or_where_in('id_prod', $chunk);
}
$this->db->group_end();