[ic] sql sessions - odd error

[DB <suppressed>]

> > 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
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users