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

[John Ralls]

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