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
Problem with database postgres with two schemas
Started by Ocupado, 25 August 2012 - 13:38 PM
- Single Page
Posted 25 August 2012 - 13:38 PM
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
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