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
