Scaffolding & Postgre -> Fatal error: Cannot access empty property in .../system/scaffolding/views/view.php on line 14

[eluser]jojolapatade[/eluser]
Hi,
I use Ci during a few days.
I did the tuto with mysql and used scaffolding -> it works

Now, I would like to use scaffolding with db Postgre but it isn't work. I have a message Fatal error

Fatal error: Cannot access empty property in .../system/scaffolding/views/view.php on line 14
Call Stack
# Function Location
1 {main}() .../index.php:0
2 require_once('.../system/codeigniter/CodeIgniter.php') .../index.php:115
3 Controller->_ci_scaffolding() .../system/codeigniter/CodeIgniter.php:204
4 Scaffolding->view() .../system/libraries/Controller.php:119
5 CI_Loader->view() .../system/scaffolding/Scaffolding.php:182
6 CI_Loader->_ci_load() .../system/libraries/Loader.php:307
7 include('.../system/scaffolding/views/view.php') .../system/libraries/Loader.php:677

Somebody cant help me?
Thank you

Jo

[eluser]jojolapatade[/eluser]
re,

I tried Blog's tuto with postgre -> it works

Just Postgre with scaffolding -> it isn't works
I have a Fatal error

I don't understand

Perhaps a bug ??
I use CodeIgniter version 1.7

[eluser]jojolapatade[/eluser]
Hi,
Here is sql code for Postgres.
If someboy try with the blog's tuto, it's work, but I don't work with Scaffolding.
What is normal ?
Or it's a bug.
Thank you for you help.
Jo

CREATE TABLE entries (
id INT UNIQUE PRIMARY KEY,
title VARCHAR(50) NOT NULL,
body TEXT NOT NULL
) ;
/* auto_increment like in mysql : */
CREATE SEQUENCE entries_id_seq;
ALTER TABLE entries ALTER COLUMN id SET DEFAULT NEXTVAL ('entries_id_seq') ;
UPDATE entries SET id = NEXTVAL ('entries_id_seq') ;

CREATE TABLE comments (
id INT UNIQUE PRIMARY KEY,
entry_id INT NOT NULL,
body TEXT NOT NULL,
author VARCHAR(100) NOT NULL
) ;
/* auto_increment like in mysql : */
CREATE SEQUENCE comments_id_seq;
ALTER TABLE comments ALTER COLUMN id SET DEFAULT NEXTVAL ('comments_id_seq') ;
UPDATE comments SET id = NEXTVAL ('comments_id_seq') ;



/* Create user for Postgres */
CREATE USER u3 with PASSWORD 'jo' ;
GRANT ALL ON TABLE entries TO u3 ;
GRANT ALL PRIVILEGES ON SEQUENCE entries_id_seq TO u3 ;

GRANT ALL ON TABLE comments TO u3 ;
GRANT ALL PRIVILEGES ON SEQUENCE comments_id_seq TO u3 ;


//config for /application/config/database.php
$active_group = "pg";
$active_record = TRUE;

$db['pg']['hostname'] = "localhost";
$db['pg']['username'] = "u3";
$db['pg']['password'] = "jo";
$db['pg']['database'] = "mydb";
$db['pg']['dbdriver'] = "postgre";
$db['pg']['dbprefix'] = "";
$db['pg']['pconnect'] = TRUE;
$db['pg']['db_debug'] = TRUE;
$db['pg']['cache_on'] = FALSE;
$db['pg']['cachedir'] = "";
$db['pg']['char_set'] = "utf8";
$db['pg']['dbcollat'] = "utf8_general_ci";

[eluser]Crazy LionHeart[/eluser]
Look solution there

[eluser]jojolapatade[/eluser]
Thank you very much Mr Crazy LionHeart
With this soution (http://ellislab.com/forums/viewthread/49084/#529569) it work now with postgres (it work always with mysql too)

[eluser]rhyous[/eluser]
Is this going to be fixed in the next release?

[eluser]jojolapatade[/eluser]
I don't know.
Sorry Mr Rhyous, I didn't try with the next release (1.7.1).

[eluser]rhyous[/eluser]
Oh...sorry about the confusion.

I have a FreeBSD, Apache, PHP, Postgresql server and I thought I would try CodeIgnitor.

I downloaded 1.7.1 and found this error. It is kind of a show stopper.

I meant is there any work being done to fix this in 1.7.2 or 1.8

[eluser]jojolapatade[/eluser]
Try this soution http://ellislab.com/forums/viewthread/49084/#529569
It works well after.

[eluser]niczak[/eluser]
[quote author="jojolapatade" date="1238879783"]Try this soution http://ellislab.com/forums/viewthread/49084/#529569
It works well after.[/quote]

Unfortunately that "solution" doesn't work at all. Try to edit a record (especially if your ID is of type SERIAL) and it fails all over the place.

A real solution to this problem would be very well received, until then CI is NOT compatible with PostgreSQL as far as I am concerned.