Gromozeka - 24 April 2009 08:34 AM
with the same table in DB:
CREATE TABLE IF NOT EXISTS `ci_sessions` (
session_id varchar(40) DEFAULT '0' NOT NULL,
ip_address varchar(16) DEFAULT '0' NOT NULL,
user_agent varchar(50) NOT NULL,
last_activity int(10) unsigned DEFAULT 0 NOT NULL,
user_data text NOT NULL,
PRIMARY KEY (session_id)
);
When exactly this SQL error occur?
thanks for the reply
I trie to port tank auth to postgresql.
De probleme is, if i go to the page /auth/login/ . Apart of the script do this request
INSERT INTO "ci_sessions" ("session_id", "ip_address", "user_agent", "last_activity") VALUES ('fc40d7fc1a67d070866dc3578fdd1d1f', '81.247.128.65', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; fr; rv:1.', 1240510179)
as you can see there is only 4 fields in the sql request. But on the schema there are 5 field for test i have change the schema like this
CREATE TABLE IF NOT EXISTS `ci_sessions` (
session_id varchar(40) DEFAULT '0' NOT NULL,
ip_address varchar(16) DEFAULT '0' NOT NULL,
user_agent varchar(50) NOT NULL,
last_activity int(10) unsigned DEFAULT 0 NOT NULL,
user_data text ,
PRIMARY KEY (session_id)
);
that work but i dont know if that change afect the tank auth script???
If you want i can post the schema of the postgresql database.