[Opensim-dev] opensim 0.9 robust timestamp error

[Ai Austin]

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.