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&bug_ >> status=NEW&comment=&see_also=&qa_contact=import%40gnucash.bugs&dup_id=&statu >> s_whiteboard=&short_desc=Generic%20import%20transaction%20matcher%20should%2 >> 0highlight%20the%20current%20line&rep_platform=Other&bug_severity=enhancemen >> t&assigned_to=import%40gnucash.bugs&keywords=&delta_ts=0000-00-00%2000%3A00% >> 3A00&resolution=&defined_bug_ignored=1&target_milestone=future&dependson=&to >> ken=1530404201-I3MkbYeJGLIf4WyJlcSSpcsU3Pn6peHLVYrVsfomUqk&version=3.1&class >> ification=Unclassified&product=GnuCash&blocked=&op_sys=Windows&component=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 _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
