RE: [phpesp-dev] [ phpesp-Bugs-930450 ] resp acct exp date problem

[Matthew G. <gr...@mu...>]

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)