[ic] sql sessions - odd error
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
> 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 Jensen
> End Point Corporation
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