how to fix codeigniter non-object error in PostgreSQL database

Question

we're using codeigniter with postgresql, our following code works in MySQL type database, but in postgresql, it shows errror

Fatal error: Call to a member function result() on a non-object in /application/models/category_m.php on line 61

Our Model Code:

$this->db->select('ci_categories.cat_id, ci_categories.cat_name, COUNT(ci_albums.album_id) AS total_albums');
$this->db->from('ci_categories');
$this->db->join('ci_albums', 'ci_albums.cat_id = ci_categories.cat_id', 'left');

return $this->db->group_by('ci_categories.cat_id')->get()->result();

Shijin TR · Accepted Answer · 2014-03-13 11:44:03Z

1

Set dbdriver in application/config/database.php

  $db['default']['dbdriver'] = "postgres";

The error is likely due to the fact that the query (and resulting result() object) are empty. Ensure that the query actually returns at least one record before attempting to use the result() object:

   $this->db->select('ci_categories.cat_id, ci_categories.cat_name, COUNT(ci_albums.album_id) AS total_albums');
   $this->db->from('ci_categories');
   $this->db->join('ci_albums', 'ci_albums.cat_id = ci_categories.cat_id', 'left');

   $query=$this->db->group_by('ci_categories.cat_id')->get();
    if($query->num_rows() > 0){
      return $query->result();
    }

edited Mar 13, 2014 at 11:44

answered Mar 13, 2014 at 11:16

Shijin TR

7,80911 gold badges64 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ahmed iqbal Over a year ago

hello, thanks for answering, but its already set to 'postgre', and all other controller work fine for me, maybe it some kind of issue with query ...

Shijin TR Over a year ago

@user1218948,The result of query was empty?Could you check my updated answer

Ahmed iqbal Over a year ago

it returns Fatal error: Call to a member function num_rows() on a non-object in

Mohan · Accepted Answer · 2014-03-13 12:02:21Z

0

try using this code

$this->db->select('ci_categories.cat_id, ci_categories.cat_name, COUNT(ci_albums.album_id) AS total_albums',FALSE);
$this->db->from('ci_categories');
$this->db->join('ci_albums', 'ci_albums.cat_id = ci_categories.cat_id', 'left');

return $this->db->group_by('ci_categories.cat_id')->get()->result();

answered Mar 13, 2014 at 12:02

Mohan

4,8597 gold badges47 silver badges70 bronze badges

8 Comments

Ahmed iqbal Over a year ago

it return Fatal error: Call to a member function result() on a non-object in, in MYSQL it work fine, but in PostGreSQL it return same...

Mohan Over a year ago

try to print last query ... using this $this->db->group_by('ci_categories.cat_id')->get(); and after this line echo $this->db->last_query();

Ahmed iqbal Over a year ago

SELECT "ci_categories"."cat_id", "ci_categories"."cat_name", COUNT(ci_albums.album_id) AS total_albums FROM "ci_categories" LEFT JOIN "ci_albums" ON "ci_albums"."cat_id" = "ci_categories"."cat_id" GROUP BY "ci_categories"."cat_id"

Mohan Over a year ago

try using return $this->db->group_by('ci_categories.cat_id')->get()->result_array();

Ahmed iqbal Over a year ago

Fatal error: Call to a member function result_array() on a non-object in

|

Fisherman · Accepted Answer · 2014-03-13 12:28:52Z

0

try this on the last line --

$query  = $this->db->group_by('ci_categories.cat_id')->get();
 return ($query)?$query->result():array(); // instead of false you can return empty array if you need

edited Mar 13, 2014 at 12:28

answered Mar 13, 2014 at 11:47

Fisherman

6,1311 gold badge33 silver badges37 bronze badges

2 Comments

Ahmed iqbal Over a year ago

it return Message: Invalid argument supplied for foreach(); it mean, we get FALSE from model...

Fisherman Over a year ago

the return array() instead of false return ($query)?$query->result():array();

Collectives™ on Stack Overflow

how to fix codeigniter non-object error in PostgreSQL database

3 Answers 3

3 Comments

8 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

8 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related