⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Problem with database postgres with two schemas



Ocupado
  • profile picture
  • Member

Posted 25 August 2012 - 13:38 PM

Im new to grosery crud. After Installing a tutorial to test crud with postgres i got the following error:

[b][i]Fatal error: Call to a member function result() on a non-object in C:\appserv\htdocs\sisgede\application\models\grocery_crud_model.php on line 435[/i][/b]

Line 435 in grocery_crud_model.php is:

[b][i]foreach($this->db->query("SHOW COLUMNS FROM `{$this->table_name}`")->result() as $db_field_type)[/i][/b]

Note: I have tested this line with and without ‘ char:

[b][i]foreach($this->db->query("SHOW COLUMNS FROM {$this->table_name}"[/i][/b]

When I display the tables availables inside [b][i]grocery_crud_model.[/i][/b] I don’t see the table I want to use.

The point is I am trying to use CRUD with a database in postgres with two schemas: public & another one. Inside CRUD I have available the tables of public schema only. The problem is that all our tables are in another schema.

Am i doing something wrong or Is it possible to fix this issue?

Thanks for your help

Ocupado
  • profile picture
  • Member

Posted 25 August 2012 - 14:00 PM

Ok. Ok.

I found that CRUD [color=#2C575B][font=Arial, Tahoma, Helvetica, sans-serif]Only works with MYSQL and MYSQLi database.[/font][/color]
http://www.grocerycrud.com/documentation/known-issues