[GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing

[Chris Good]

Hi Derek + John,

Works now thanks.

Regards, Chris Good

> -----Original Message-----
> From: Derek Atkins <derek at ihtfp.com>
> Sent: Sunday, 1 July 2018 11:25 AM
> To: John Ralls <jralls at ceridwen.us>
> Cc: Derek Atkins <warlord at mit.edu>; Chris Good <goodchris96 at gmail.com>;
> gnucash-devel at 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 <warlord at 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" <goodchris96 at gmail.com>
> wrote:
> >>
> >>>> -----Original Message-----
> >>>> From: Derek Atkins <warlord at MIT.EDU>
> >>>> Sent: Tuesday, 26 June 2018 11:30 PM
> >>>> To: Chris Good <goodchris96 at gmail.com>
> >>>> Cc: gnucash-devel at gnucash.org
> >>>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final
> >>>> Testing
> >>>>
> >>>> Chris,
> >>>>
> >>>> "Chris Good" <goodchris96 at 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
> >>>>       warlord at 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 derek at 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