It could have been related to the transition. I unfortunately don't
have access to a 4.1 server to test/confirm. With the change in
date/time handling changing somewhat with 1.7(adodb instead of native
php_mysql), this problem might fix itself, if it exists.
On Wed, 2004-05-05 at 20:39, Paul R. Jackson wrote:
> I have this same problem. It happened for me when I moved the database to a
> different server, which also meant I went from MySql 3.xx to 4.xx
>
> This is caused by a change in the way MySql handles timestamps in 4.xx (I
> think?), see:
> http://dev.mysql.com/doc/mysql/en/TIMESTAMP_4.1.html
>
> Other than the on screen display error I haven't noticed any real problems
> with this issue, i.e. accounts still expire when required etc..
>
> Paul
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Paul R. Jackson
> Experimental Programmer
>
> School of Psychology
> University of Queensland
> E:pa...@ps...
> P:3365-6713
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
> > -----Original Message-----
> > From: php...@li...
> > [mailto:php...@li...] On Behalf
> > Of SourceForge.net
> > Sent: Wednesday, 5 May 2004 6:46 AM
> > To: no...@pr...
> > Subject: [phpesp-dev] [ phpesp-Bugs-930450 ] resp acct exp
> > date problem
> >
> > Bugs item #930450, was opened at 2004-04-06 08:48 Message
> > generated for change (Settings changed) made by greggmc You
> > can respond by visiting:
> > https://sourceforge.net/tracker/?func=detail&atid=108956&aid=9
> > 30450&group_id=8956
> >
> > Category: Admin
> > Group: v1.6.1
> > >Status: Closed
> > >Resolution: Works For Me
> > Priority: 5
> > Submitted By: Christopher Kolar (ckolar) Assigned to:
> > Nobody/Anonymous (nobody)
> > Summary: resp acct exp date problem
> >
> > Initial Comment:
> > Hi. I'm not sure if this is just a display problem or not.
> > I have a respondent account set up and I wanted it to expire
> > on April 15 so I set it up and everything worked fine. Today
> > I decided to extend the survey so I went into the manage
> > respondent accounts screen to change the date. The values in
> > the box looked funny.
> > I put in 2004, 5, 1 in the three boxes for May 1, saved the
> > info, and then went back to look at it. The respondent
> > editor screen now has the values
> >
> > 2004 -0 5-
> >
> > in the three boxes. I'm not sure if my settings took and
> > this just a display problem, or if there is something going
> > on in the code (maybe getting the day/months slots out of
> > order). Anyway, thought you should know. In this case it
> > will not be a problem to manually shut down the survey when
> > the time comes.
> >
> > Cheers,
> >
> > --chris
> >
> >
> >
> > ----------------------------------------------------------------------
> >
> > You can respond by visiting:
> > https://sourceforge.net/tracker/?func=detail&atid=108956&aid=9
> > 30450&group_id=8956
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: Oracle 10g Get certified
> > on the hottest thing ever to hit the market... Oracle 10g.
> > Take an Oracle 10g class now, and we'll give you the exam FREE.
> > http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> > _______________________________________________
> > phpESP-devel mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpesp-devel
> >
>
--
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)
|