logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Timestamps?

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
Shaftsbury



Joined: 17 Mar 2007
Posts: 4
Location: Alberta, Canada

PostPosted: Sat Apr 28, 2007 16:29    Post subject: Timestamps? Reply with quote

I'm sorry if this has been covered elsewhere, I searched but couldn't find an answer.

None of my writes to the database ever have a timestamp associated with them, is there a setting I missed or something I forgot to install?

The "Last" column always just has the default "0's"
Back to top
View user's profile Send private message Visit poster's website
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Sat Apr 28, 2007 20:22    Post subject: Reply with quote

What type of database do you use ?
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Shaftsbury



Joined: 17 Mar 2007
Posts: 4
Location: Alberta, Canada

PostPosted: Sun Apr 29, 2007 0:07    Post subject: Reply with quote

I'm using MySQL
Back to top
View user's profile Send private message Visit poster's website
FunkySwerve



Joined: 02 Jun 2005
Posts: 377

PostPosted: Sun Apr 29, 2007 8:36    Post subject: Reply with quote

You mean the expiration column? If you wanted to use that to remove entries after a set time you would have to add code to do the check.
Funky
Back to top
View user's profile Send private message
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Sun Apr 29, 2007 10:46    Post subject: Reply with quote

Funky, the column is always 0 for him.

Please post your pwdata table definition. MySQL should update the timestamp value automatically if the table has been created correctly.
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Shaftsbury



Joined: 17 Mar 2007
Posts: 4
Location: Alberta, Canada

PostPosted: Sun Apr 29, 2007 15:28    Post subject: Reply with quote

I'm not sure why exactly, but instead of the default value being

CURRENT_TIMESTAMP it was set at 0000-00-00 00:00:00

even though the datatype was set for timestamp?

After removing the default value and updating the table it works fine now.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group