[Opensim-dev] opensim 0.9 robust timestamp error

[R.Gunther]

On 17-Apr-2016 17:25, Ai Austin wrote:
> R.Gunther wrote:
>> Just installed a few days ago own grid. it's now running.
>> Today in the logs a mysql timestamp error appeared, that can never be 
>> good.
>> Is this a bug ? something else wrong ? mabye it's already fixt. Or mabye
>> i need to fix something.
>>
>> MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect datetime
>> value: '1459532289' for column 'TMStamp' at row 1
>
>
> Its an issue with 0.9.0 already reported and still open on Mantis at
> http://opensimulator.org/mantis/view.php?id=7848
> and occurring on our own grid too.
>
> According to Jeff Kelly there, it looks like some Unix time stamp code 
> has crept in where os_groups_invites.TMStamp is a MySQL TIMESTAMP
>
> I found various parts of OpenSim/Addons/Groups/GroupsModule.cs that 
> use msg.timestamp = (uint)Util.UnixTimeSinceEpoch();
>
> You can mask (but not correct) the error by removing 
> STRICT_TRANS_TABLES and strict settings in the MySQL my.ini file.
>
> _______________________________________________
If the bug get fixed in later 0.9 version it's not a problem. because 
it's still empty grid setup. SO i can start with clean database.

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus