[SOLVED]database error occurred

[eluser]kikz4life[/eluser]
The scenario is i when i update my CI version to 1.7.2 from 1.6.3, this problem arise. It says Database Error Occurred. Traced the said error from my model.php in this code:

Code:

function getTypes($datacode)
    {
        $this->db->select('data_id,data_value,data_display,description');
         $this->db->where("data_code='$datacode' AND display='1'");
        $this->db->orderby("order_idx", "asc");
        $query = $this->db->get('sec_dataset');
        return $query->result();        
    }

I tried to modify it to

Code:

function getTypes($datacode)
    {            
        $this->db->select('data_id,data_value,data_display,description');
        $query =$this->db->where('data_code', $datacode);
            $query =$this->db->where('display',1);
        $this->db->orderby("order_idx", "asc");
        $query = $this->db->get_where('sec_dataset');
        return $query->result();        
    }

Its working but no data displayed/retrieved from my db. and my firebug said that its now Internal Server Error

Could anyone help me with this. I'm thinking of not upgrading if many problem arise.