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 <[email protected]> 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" <[email protected]> wrote: >> >>>> -----Original Message----- >>>> From: Derek Atkins <[email protected]> >>>> Sent: Tuesday, 26 June 2018 11:30 PM >>>> To: Chris Good <[email protected]> >>>> Cc: [email protected] >>>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final >>>> Testing >>>> >>>> Chris, >>>> >>>> "Chris Good" <[email protected]> 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 >>>> [email protected] 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 [email protected] 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 >> [email protected] >> https://lists.gnucash.org/mailman/listinfo/gnucash-devel > > -- Derek Atkins 617-623-3745 [email protected] www.ihtfp.com Computer and Internet Security Consultant _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
