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

[Derek Atkins]

Great.
Thanks for testing!

-derek
Sent using my mobile device. Please excuse any typos.
On June 30, 2018 9:43:19 PM "Chris Good" <goodchris96 at gmail.com> wrote:

> 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