[Opensim-users] How is "Date/Time" Recorded in the Database?

[Len Brown]

I changed the avatar birthdate by only 10 seconds and it still killed my
inventory and made my avatar Ruth.

I'm going to check some other things in the database and see what I can come
up with.  There must be something linked to the avatar birthdate for it to
break everything like this.
- Len
On Mon, Nov 2, 2009 at 1:53 PM, Len Brown <lenwbrown at gmail.com> wrote:

> WARNING:
>
>      Thankfully I am religious about making backups.  I made a backup of my
> database just before asking about the time/date question.
>
>      I just tried this twice to make sure it is not a quirk...
>
>      I shut down OpenSim.  Then went into the database and changed the
> "birthday" of my avatare to 1257076800 which is November 1, 2009 12:00:00
> (noon).  I then saved the change in the database then restarted OpenSim.
>
> Two things:
>
>      My avatar is the default Ruth (with a birthday of Nov 1)
>
>      My entire inventory is gone.
>
> Again, thankfully I had a backup (whew!).  I shut everything down and
> restored from backup twice - both times logging in and  my custom avatar was
> intact.  Each time I changed the birthday in the database it turned my
> avatar to Ruth and killed my entire inventory.
>
>      I'm guessing "maybe" the issue is that the time stamp I gave the
> avatar is prior to the time stamp when I actually set everything up - it was
> in the late evening of Nov 1st.
>
>      So at least I have a backup - so everything is running perfectly
> again.
>
>      Any suggestions on why the date change for teh AV killed everything
> else?
>
>      Of note also - everything in-world was still there, and the textual
> stuff I'd added to my avatar's profile was also intact.
>
> - Len W. Brown
>      lenwbrown at gmail.com
>   On Mon, Nov 2, 2009 at 1:32 PM, Len Brown <lenwbrown at gmail.com> wrote:
>
>> Very cool and thank you very much.  Wow, I didn't expect such a quick
>> reply.
>>
>> Much appreciated!
>>
>>   On Mon, Nov 2, 2009 at 1:31 PM, Chris Hart <Chris at codetorque.co.uk>wrote:
>>
>>>    Sounds like a timezone conflict between where your server thinks it
>>> is and where your client thinks you are when it converts to human-readable
>>> time.
>>>
>>>
>>>
>>> The number in the database is Epoch time which means the time is nice and
>>> universal and timezone-independant:
>>>
>>> http://en.wikipedia.org/wiki/Unix_time
>>>
>>> http://www.epochconverter.com/
>>>
>>>
>>>
>>> Hope that helps,
>>>
>>> Chris
>>>
>>>
>>>
>>> *From:* opensim-users-bounces at lists.berlios.de [mailto:
>>> opensim-users-bounces at lists.berlios.de] *On Behalf Of *Len Brown
>>> *Sent:* 02 November 2009 7:27 PM
>>> *To:* opensim-users at lists.berlios.de
>>> *Subject:* [Opensim-users] How is "Date/Time" Recorded in the Database?
>>>
>>>
>>>
>>> Hi Everyone!
>>>
>>>
>>>
>>>      Do any of you know how OpenSim saves time in the database?
>>>
>>>
>>>
>>>      Here's the situation - I started a brand new fully updated "bleeding
>>> edge" OpenSim server at home on November 1st.  The region shows it was
>>> created on Nov 1st but after creating a new skin, shape, etc for my new
>>> avatar - I noticed my avatar profile says it was created on November 2nd.
>>>
>>>
>>>
>>>      In the database for my avatar is the following: *1257137090* to
>>> represent when the avatar was created.  I suppose I could make the number
>>> slightly smaller in the database and see what happens, but if there is some
>>> "basic and simple" means that the current date is encoded, what is it?  I
>>> want my avatar to also show a birthday of November 1, like the region it's
>>> building...
>>>
>>>
>>>
>>> Any hints?
>>>
>>>
>>>
>>> Thanks!
>>>
>>>
>>>
>>> - Len W. Brown
>>>
>>>      lenwbrown at gmail.com
>>>
>>> No virus found in this incoming message.
>>> Checked by AVG - www.avg.com
>>> Version: 8.5.423 / Virus Database: 270.14.39/2468 - Release Date:
>>> 11/02/09 07:51:00
>>>
>>> _______________________________________________
>>> Opensim-users mailing list
>>> Opensim-users at lists.berlios.de
>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20091102/cfd8ad61/attachment.html>