[ic] sql sessions - odd error

DB DB at M-and-D.com
Fri Mar 21 14:27:26 EST 2008

>> 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!


More information about the interchange-users mailing list