[ic] sql sessions - odd error

[DB]

>> When I tell IC to use the Windows mysql server, things mostly work, but 
>> when a user tries to log in IC throws up an error such as:
>>
>> Failed to record timestamp in UserDB: DBD::mysql::st execute failed: 
>> Incorrect datetime value: '1206123064' for column 'mod_time' at row 1 at 
>> /usr/local/interchange/lib/Vend/Table/DBI.pm line 1633.
>>
>> Paerhaps there's some difference between the Linux and Windows versions 
>> of mysql? Can anyone offer a suggestion?
> 
> Do you literally mean you've set up Interchange to use MySQL for your 
> session database, that is, the "SessionDB" directive is in catalog.cfg?
> 
> Your error above is happening in UserDB, which is unrelated.
> 
> Apparently MySQL on Windows isn't handling the Unix seconds-since-1970 
> epoch. You can disable time field updating altogether by changing this 
> line in catalog.cfg:
> 
>      UserDB    default    time_field    mod_time
> 
> to:
> 
>      UserDB    default    time_field    none
> 
> Then your userdb entries will not have a timestamp showing when they were 
> updated. You could change the mod_time field to be a "timestamp" type, 
> which I think MySQL automatically updates.
> 
> Jon
> 
> -- 
> Jon Jensen
> End Point Corporation
> http://www.endpoint.com/

Hi - you're right of course - it was squawking about userdb. The 
mod_time field was already set to type timestamp, but changing the 
time_field to none made the problem go away. Thanks!

DB