PhpDig.net - View Single Post

Iltud · 09-13-2003, 05:26 AM

Hello,

In you second point about the column "l_time" :

The l_time column in logs table isn't TIMESTAMP.

According to the script /sql/update_db_to_1_6_1.sql, this column should be a FLOAT and not a TIMESTAMP as you said.

It's probably the reason why you always have "l_time" empty: 000000000.

/sql/update_db_to_1_6_1.sql said :

ALTER TABLE logs ADD l_time FLOAT DEFAULT '0' NOT NULL ;

Thanks,
Nicolas.

09-13-2003, 05:26 AM	#2
Iltud Green Mole Join Date: Sep 2003 Location: Brest - France Posts: 22	Hello, In you second point about the column "l_time" : The l_time column in logs table isn't TIMESTAMP. According to the script /sql/update_db_to_1_6_1.sql, this column should be a FLOAT and not a TIMESTAMP as you said. It's probably the reason why you always have "l_time" empty: 000000000. /sql/update_db_to_1_6_1.sql said : ALTER TABLE logs ADD l_time FLOAT DEFAULT '0' NOT NULL ; Thanks, Nicolas.