Commands out of sync; you can't run this command now

Open this file
system/database/drivers/mysqli/mysqli_result.php


Add 

     function next_result()
     {
         if (is_object($this->conn_id))
         {
             return mysqli_next_result($this->conn_id);
         }
     }



------------------------------

then where ever calling query 

$query->next_result(); 

$query->free_result();

    function get_total_staff() {
        $query = $this->db->query("call getTotalStaffCount()");
        $cnt =  $query->row()->total_staff_count;
        $query->next_result(); 
        $query->free_result();
        return $cnt;
       
    }
 
    function get_active_staff() {
        $query = $this->db->query("call getActiveStaffCount()");
        $cnt =  $query->row()->active_staff_count;
        $query->next_result(); 
        $query->free_result();
        return $cnt;    
    }