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

[Derek Atkins]

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&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 at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant