Hi Derek + John, Works now thanks.
Regards, Chris Good > -----Original Message----- > From: Derek Atkins <de...@ihtfp.com> > Sent: Sunday, 1 July 2018 11:25 AM > To: John Ralls <jra...@ceridwen.us> > Cc: Derek Atkins <warl...@mit.edu>; Chris Good <goodchri...@gmail.com>; > gnucash-devel@gnucash.org > Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing > > I needed "IS NULL", not "= NULL", but this has been executed. > > -derek > > > On Sat, June 30, 2018 8:44 pm, John Ralls wrote: > > Derek, > > > > That one shows as having no modified date. I expect it has no > > bugs_activity records, so it needs to have delta_ts set to creation_ts: > > > > UPDATE bugs SET delta_ts = creation_ts WHERE delta_ts = NULL; > > > > Regards, > > John Ralls > > > > > >> On Jun 30, 2018, at 5:35 PM, Derek Atkins <warl...@mit.edu> wrote: > >> > >> Thanks. > >> I bet this is related to a database "fix" that John and I did. > >> I'll take a look to ensure all bugs have a valid delta_ts. > >> > >> -derek > >> Sent using my mobile device. Please excuse any typos. > >> On June 30, 2018 8:30:15 PM "Chris Good" <goodchri...@gmail.com> > wrote: > >> > >>>> -----Original Message----- > >>>> From: Derek Atkins <warl...@mit.edu> > >>>> Sent: Tuesday, 26 June 2018 11:30 PM > >>>> To: Chris Good <goodchri...@gmail.com> > >>>> Cc: gnucash-devel@gnucash.org > >>>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final > >>>> Testing > >>>> > >>>> Chris, > >>>> > >>>> "Chris Good" <goodchri...@gmail.com> writes: > >>>> > >>>> > Hi Derek, > >>>> > > >>>> > Thanks for all your work on this. > >>>> > There seems to be a problem with dates/times. > >>>> > > >>>> > In the old and new websites, I changed my preference to Timezone > >>>> used > >>>> > to display dates and times : Australia/Sydney > >>>> > > >>>> > Now: > >>>> > https://bugzilla.gnome.org/show_bug.cgi?id=796154 > >>>> > Reported: 2018-05-16 10:42 AEST by Chris Good > >>>> > > >>>> > https://bugs.gnucash.org/show_bug.cgi?id=796154 > >>>> > Reported: 2018-05-16 14:42 AEST by Chris Good > >>>> > > >>>> > Sorry in advance if this is something you already have mentioned. > >>>> > >>>> I believe I have fixed this. Can you please re-check? (You will > >>>> need to > >>> reset your > >>>> preferences -- I dumped the database in trying to get this working). > >>> However > >>>> comparing a bug on GnomeBZ, I see the times in UTC on GnomeBZ and > >>>> EST/EDT on GnuCash-BZ with the correct 4/5-hour offsets. So I > >>>> THINK this is now > >>> fixed > >>>> but would appreciate it if you coud verify. > >>>> > >>>> Thanks, > >>>> > >>>> > Regards, Chris Good > >>>> > >>>> -derek > >>>> > >>>> -- > >>>> Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory > >>>> Member, MIT Student Information Processing Board (SIPB) > >>>> URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH > >>>> warl...@mit.edu PGP key available > >>> > >>> Hi Derek, > >>> > >>> Sorry for the delay testing this. > >>> Date/Time is correct now thanks. > >>> > >>> However, > >>> > >>> After resetting my password, logging in again to > >>> https://bugs.gnucash.org/show_bug.cgi?id=796154 > >>> changing my preference > >>> "Timezone used to display dates and times" to Australia/Sydney > >>> > >>> I tried to update the Bug Summary and get this error: > >>> > >>> https://bugs.gnucash.org/process_bug.cgi > >>> > >>> An unexpected error occurred. This could be a temporary problem, or > >>> some code is behaving incorrectly. If this problem persists, please > >>> email this page to de...@ihtfp.com with details of what you were > >>> doing at the time this message appeared. > >>> > >>> URL: > >>> > https://bugs.gnucash.org/process_bug.cgi?tag=&newalias=&priority=Normal&b > ug_ > >>> > status=NEW&comment=&see_also=&qa_contact=import%40gnucash.bugs&dup > _id=&statu > >>> > s_whiteboard=&short_desc=Generic%20import%20transaction%20matcher%20 > should%2 > >>> > 0highlight%20the%20current%20line&rep_platform=Other&bug_severity=enhan > cemen > >>> t&assigned_to=import%40gnucash.bugs&keywords=&delta_ts=0000-00- > 00%2000%3A00% > >>> > 3A00&resolution=&defined_bug_ignored=1&target_milestone=future&depends > on=&to > >>> ken=1530404201- > I3MkbYeJGLIf4WyJlcSSpcsU3Pn6peHLVYrVsfomUqk&version=3.1&class > >>> > ification=Unclassified&product=GnuCash&blocked=&op_sys=Windows&compon > ent=Imp > >>> ort%20-%20OFX&id=796154&bug_file_loc= > >>> > >>> The entered timestamp 0000-00-00 00:00:00 could not be parsed into a > >>> valid > >>> date and time. > >>> Traceback: > >>> > >>> at /usr/share/bugzilla/process_bug.cgi line 107. > >>> > >>> Regards, Chris Good _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
