View previous topic :: View next topic |
Author |
Message |
Shaftsbury
Joined: 17 Mar 2007 Posts: 4 Location: Alberta, Canada
|
Posted: Sat Apr 28, 2007 16:29 Post subject: Timestamps? |
|
|
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 |
|
|
Papillon x-man
Joined: 28 Dec 2004 Posts: 1060 Location: Germany
|
Posted: Sat Apr 28, 2007 20:22 Post subject: |
|
|
What type of database do you use ? _________________ Papillon |
|
Back to top |
|
|
Shaftsbury
Joined: 17 Mar 2007 Posts: 4 Location: Alberta, Canada
|
Posted: Sun Apr 29, 2007 0:07 Post subject: |
|
|
I'm using MySQL |
|
Back to top |
|
|
FunkySwerve
Joined: 02 Jun 2005 Posts: 377
|
Posted: Sun Apr 29, 2007 8:36 Post subject: |
|
|
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 |
|
|
Papillon x-man
Joined: 28 Dec 2004 Posts: 1060 Location: Germany
|
Posted: Sun Apr 29, 2007 10:46 Post subject: |
|
|
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 |
|
|
Shaftsbury
Joined: 17 Mar 2007 Posts: 4 Location: Alberta, Canada
|
Posted: Sun Apr 29, 2007 15:28 Post subject: |
|
|
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 |
|
|
|