cw wrote on Tue, 13 March 2007 08:56 > On 3/13/07, Jim Valavanis wrote: > > I ran the script to move the calendar times back an hour, it actually > > flip-flopped the start/end times. So all entries that were from > > 9:00am-10:00am move to 9:00am-8:00am (which obviously worked, as far as > > changing the times back an hour, but flip-flopped the start/end times. > > Maybe a quick way to fix this? > > >did you copy/paste the sql or retype it and maybe misplaced an "e"? > reviewing it I don't see a way for this to flip-flop. > > I typed it in, and made sure it was correct: Here I'll paste the mysql > history... > > UPDATE phpgw_cal set datetime = datetime - (60*60) WHERE mdatetime >= > 1173600000 AND datetime <= 1175410800; > > and... > UPDATE phpgw_cal set edatetime = edatetime - (60*60) WHERE mdatetime <= > 1173600000 AND edatetime >= 1173600000 AND edatetime <= 1175410800; > > Jim > _______________________________________________ > phpGroupWare-users mailing list > [email protected] > http://lists.gnu.org/mailman/listinfo/phpgroupware-users
Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org _______________________________________________ phpGroupWare-users mailing list [email protected] http://lists.gnu.org/mailman/listinfo/phpgroupware-users
