[SOLVED]database error occurred

#1
[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 ErrorSad

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


Messages In This Thread
[SOLVED]database error occurred - by El Forum - 10-22-2009, 01:47 AM
[SOLVED]database error occurred - by El Forum - 10-22-2009, 02:10 AM
[SOLVED]database error occurred - by El Forum - 10-22-2009, 02:38 AM
[SOLVED]database error occurred - by El Forum - 10-22-2009, 02:47 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.