Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Great. Thanks for testing! -derek Sent using my mobile device. Please excuse any typos. On June 30, 2018 9:43:19 PM "Chris Good" wrote: Hi Derek + John, Works now thanks. Regards, Chris Good -Original Message- From: Derek Atkins Sent: Sunday, 1 July 2018 11:25 AM To: John Ralls Cc: Derek Atkins ; Chris Good ; gnucash-devel@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 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" wrote: >> >>>> -Original Message----- >>>> From: Derek Atkins >>>> Sent: Tuesday, 26 June 2018 11:30 PM >>>> To: Chris Good >>>> Cc: gnucash-devel@gnucash.org >>>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final >>>> Testing >>>> >>>> Chris, >>>> >>>> "Chris Good" 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 >>>> warl...@mit.eduPGP 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 de...@ihtfp.com with details of what you were >>> doing at the time this message appeared. >>> >>> URL: >>> https://bugs.gnucash.org/process_bug.cgi?tag===Normal ug_ >>> status=NEW=_also=_contact=import%40gnucash.bugs _id= >>> s_whiteboard=_desc=Generic%20import%20transaction%20matcher%20 should%2 >>> 0highlight%20the%20current%20line_platform=Other_severity=enhan cemen >>> t_to=import%40gnucash.bugs=_ts=-00- 00%2000%3A00% >>> 3A00=_bug_ignored=1_milestone=future on= >>> ken=1530404201- I3MkbYeJGLIf4WyJlcSSpcsU3Pn6peHLVYrVsfomUqk=3.1 >>> ification=Unclassified=GnuCash=_sys=Windows ent=Imp >>> ort%20-%20OFX=796154_file_loc= >>> >>> The entered timestamp -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@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Hi Derek + John, Works now thanks. Regards, Chris Good > -Original Message- > From: Derek Atkins > Sent: Sunday, 1 July 2018 11:25 AM > To: John Ralls > Cc: Derek Atkins ; Chris Good ; > gnucash-devel@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 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" > wrote: > >> > >>>> -Original Message- > >>>> From: Derek Atkins > >>>> Sent: Tuesday, 26 June 2018 11:30 PM > >>>> To: Chris Good > >>>> Cc: gnucash-devel@gnucash.org > >>>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final > >>>> Testing > >>>> > >>>> Chris, > >>>> > >>>> "Chris Good" 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 > >>>> warl...@mit.eduPGP 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 de...@ihtfp.com with details of what you were > >>> doing at the time this message appeared. > >>> > >>> URL: > >>> > https://bugs.gnucash.org/process_bug.cgi?tag===Normal > ug_ > >>> > status=NEW=_also=_contact=import%40gnucash.bugs > _id= > >>> > s_whiteboard=_desc=Generic%20import%20transaction%20matcher%20 > should%2 > >>> > 0highlight%20the%20current%20line_platform=Other_severity=enhan > cemen > >>> t_to=import%40gnucash.bugs=_ts=-00- > 00%2000%3A00% > >>> > 3A00=_bug_ignored=1_milestone=future > on= > >>> ken=1530404201- > I3MkbYeJGLIf4WyJlcSSpcsU3Pn6peHLVYrVsfomUqk=3.1 > >>> > ification=Unclassified=GnuCash=_sys=Windows > ent=Imp > >>> ort%20-%20OFX=796154_file_loc= > >>> > >>> The entered timestamp -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@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
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 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" wrote: > >>> -Original Message- >>> From: Derek Atkins >>> Sent: Tuesday, 26 June 2018 11:30 PM >>> To: Chris Good >>> Cc: gnucash-devel@gnucash.org >>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing >>> >>> Chris, >>> >>> "Chris Good" 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 >>> warl...@mit.eduPGP 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 de...@ihtfp.com with details of what you were doing at the time this >> message appeared. >> >> URL: >> https://bugs.gnucash.org/process_bug.cgi?tag===Normal_ >> status=NEW=_also=_contact=import%40gnucash.bugs_id= >> s_whiteboard=_desc=Generic%20import%20transaction%20matcher%20should%2 >> 0highlight%20the%20current%20line_platform=Other_severity=enhancemen >> t_to=import%40gnucash.bugs=_ts=-00-00%2000%3A00% >> 3A00=_bug_ignored=1_milestone=future= >> ken=1530404201-I3MkbYeJGLIf4WyJlcSSpcsU3Pn6peHLVYrVsfomUqk=3.1 >> ification=Unclassified=GnuCash=_sys=Windows=Imp >> ort%20-%20OFX=796154_file_loc= >> >> The entered timestamp -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@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
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" wrote: -Original Message- From: Derek Atkins Sent: Tuesday, 26 June 2018 11:30 PM To: Chris Good Cc: gnucash-devel@gnucash.org Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing Chris, "Chris Good" 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 warl...@mit.eduPGP 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 de...@ihtfp.com with details of what you were doing at the time this message appeared. URL: https://bugs.gnucash.org/process_bug.cgi?tag===Normal_ status=NEW=_also=_contact=import%40gnucash.bugs_id= s_whiteboard=_desc=Generic%20import%20transaction%20matcher%20should%2 0highlight%20the%20current%20line_platform=Other_severity=enhancemen t_to=import%40gnucash.bugs=_ts=-00-00%2000%3A00% 3A00=_bug_ignored=1_milestone=future= ken=1530404201-I3MkbYeJGLIf4WyJlcSSpcsU3Pn6peHLVYrVsfomUqk=3.1 ification=Unclassified=GnuCash=_sys=Windows=Imp ort%20-%20OFX=796154_file_loc= The entered timestamp -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@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
> -Original Message- > From: Derek Atkins > Sent: Tuesday, 26 June 2018 11:30 PM > To: Chris Good > Cc: gnucash-devel@gnucash.org > Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing > > Chris, > > "Chris Good" 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 >warl...@mit.eduPGP 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 de...@ihtfp.com with details of what you were doing at the time this message appeared. URL: https://bugs.gnucash.org/process_bug.cgi?tag===Normal_ status=NEW=_also=_contact=import%40gnucash.bugs_id= s_whiteboard=_desc=Generic%20import%20transaction%20matcher%20should%2 0highlight%20the%20current%20line_platform=Other_severity=enhancemen t_to=import%40gnucash.bugs=_ts=-00-00%2000%3A00% 3A00=_bug_ignored=1_milestone=future= ken=1530404201-I3MkbYeJGLIf4WyJlcSSpcsU3Pn6peHLVYrVsfomUqk=3.1 ification=Unclassified=GnuCash=_sys=Windows=Imp ort%20-%20OFX=796154_file_loc= The entered timestamp -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@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Hi Derek, > Hi Richard, > > I THINK I fixed this. Can you please go take a look. > > Thanks, > > -derek > > On Tue, June 26, 2018 9:35 am, Derek Atkins wrote: >> Hi, >> >> Thanks for catching this. I'll go take a look. >> >> -derek >> >> Richard Ullger writes: >> >>> Hi Derek, >>> >>> Comments relating to an attachment are duplicated. For example, comment >>> 1 on bug https://bugs.gnucash.org/show_bug.cgi?id=793593 ... >>> >>> - >>> Richard Ullger 2018-02-19 16:08:41 GMT >>> >>> Created attachment 368555 [details] >>> Reconciled balances showing zero difference >>> >>> Created attachment 368555 [details] >>> Reconciled balances showing zero difference >>> - >>> >>> Whereas on Gnome bugzilla you get a single occurrence of the comment. >>> >>> Regards, >>> >>> Richard Yes, it looks good. Regards, Richard. signature.asc Description: OpenPGP digital signature ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Hi Richard, I THINK I fixed this. Can you please go take a look. Thanks, -derek On Tue, June 26, 2018 9:35 am, Derek Atkins wrote: > Hi, > > Thanks for catching this. I'll go take a look. > > -derek > > Richard Ullger writes: > >> Hi Derek, >> >> Comments relating to an attachment are duplicated. For example, comment >> 1 on bug https://bugs.gnucash.org/show_bug.cgi?id=793593 ... >> >> - >> Richard Ullger 2018-02-19 16:08:41 GMT >> >> Created attachment 368555 [details] >> Reconciled balances showing zero difference >> >> Created attachment 368555 [details] >> Reconciled balances showing zero difference >> - >> >> Whereas on Gnome bugzilla you get a single occurrence of the comment. >> >> Regards, >> >> Richard >> >> ___ >> gnucash-devel mailing list >> gnucash-devel@gnucash.org >> https://lists.gnucash.org/mailman/listinfo/gnucash-devel >> > > -- >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 >warl...@mit.eduPGP key available > ___ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Hi, Thanks for catching this. I'll go take a look. -derek Richard Ullger writes: > Hi Derek, > > Comments relating to an attachment are duplicated. For example, comment > 1 on bug https://bugs.gnucash.org/show_bug.cgi?id=793593 ... > > - > Richard Ullger 2018-02-19 16:08:41 GMT > > Created attachment 368555 [details] > Reconciled balances showing zero difference > > Created attachment 368555 [details] > Reconciled balances showing zero difference > - > > Whereas on Gnome bugzilla you get a single occurrence of the comment. > > Regards, > > Richard > > ___ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > -- 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 warl...@mit.eduPGP key available ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
John Ralls writes: > ISTR talking about this on IRC a couple of weeks ago. The times in the import > data are getting treated as the wrong TZ by the import. Based on the shift I’d > guess that they’re UTC in the data but the import program is treating them as > local, i.e. -0400. This is indeed what happened. There were two issues: 1) The parse_date function would fall through to "local time" if the tz offset was '0' 2) My import scripts were never calling the parse_date function! > As long as the events are all in the same order it doesn’t really matter at > exactly what time an event happened. The only risk is that an event on > bugzila.gnome.org entered right before the final dump will be briefly in the > future on bugs.gnucash.org and so an event on the same bug entered on > bugs.gnucash.org might get out-of-order. True.. But I'd rather the data be correct. It's fixed now. > Regards, > John Ralls -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 warl...@mit.eduPGP key available ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Chris, "Chris Good" 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 warl...@mit.eduPGP key available ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
On 15/06/18 22:18, Derek Atkins wrote: > Hi Everyone, > > I've been working on the BZ migration and finished yet another migration > test. At this point I *THINK* we've got everything the way we want in > preparation for our final migration. > > Please take a look at https://bugs.gnucash.org/ > > Peruse the bug list. Check it out. See if there are any problems. > Also check out the wiki page for other notes and status: > https://wiki.gnucash.org/wiki/Bugzilla_Administration#New_Installation > > NOTES: > 1) All users have accounts in the database, but you will need to reset >your password in order to access it. > 2) The database will be blown away when we perform the final migration, >so you will need to reset your password again when we do the final >migration. > 3) Bug creation will not work, so don't try. > 4) I have not migrated any GnomeBZ extensions -- we can always add those >later (e.g. their browse page). > > Final migration is planned for the week of June 25. > > Please let me know if you find any issues! > > Thanks, > > -derek > Hi Derek, Comments relating to an attachment are duplicated. For example, comment 1 on bug https://bugs.gnucash.org/show_bug.cgi?id=793593 ... - Richard Ullger 2018-02-19 16:08:41 GMT Created attachment 368555 [details] Reconciled balances showing zero difference Created attachment 368555 [details] Reconciled balances showing zero difference - Whereas on Gnome bugzilla you get a single occurrence of the comment. Regards, Richard signature.asc Description: OpenPGP digital signature ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
ISTR talking about this on IRC a couple of weeks ago. The times in the import data are getting treated as the wrong TZ by the import. Based on the shift I’d guess that they’re UTC in the data but the import program is treating them as local, i.e. -0400. As long as the events are all in the same order it doesn’t really matter at exactly what time an event happened. The only risk is that an event on bugzila.gnome.org <http://bugzila.gnome.org/> entered right before the final dump will be briefly in the future on bugs.gnucash.org and so an event on the same bug entered on bugs.gnucash.org <http://bugs.gnucash.org/> might get out-of-order. Regards, John Ralls > On Jun 16, 2018, at 1:17 AM, Derek Atkins wrote: > > Thanks. > > -derek > Sent using my mobile device. Please excuse any typos. > On June 16, 2018 4:15:12 AM "Chris Good" wrote: > >> Hi Derek, >> >> I have added this task to the wiki TODO list. >> >> Regards, Chris Good >> >>> -Original Message- >>> From: Derek Atkins >>> Sent: Saturday, 16 June 2018 6:09 PM >>> To: Chris Good ; gnucash-devel@gnucash.org >>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing >>> >>> Interesting. >>> I wonder if there in an import confusion between edt and gmt? >>> Please add this to the wiki todo list? >>> >>> -derek >>> Sent using my mobile device. Please excuse any typos. >>> On June 16, 2018 1:18:19 AM "Chris Good" wrote: >>> >>> >> Message: 6 >>> >> Date: Fri, 15 Jun 2018 17:18:05 -0400 >>> >> From: Derek Atkins >>> >> To: gnucash-devel@gnucash.org >>> >> Subject: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing >>> >> Message-ID: >>> >> Content-Type: text/plain >>> >> >>> >> Hi Everyone, >>> >> >>> >> I've been working on the BZ migration and finished yet another >>> >> migration >>> > test. >>> >> At this point I *THINK* we've got everything the way we want in >>> > preparation for >>> >> our final migration. >>> >> >>> >> Please take a look at https://bugs.gnucash.org/ >>> >> >>> >> Peruse the bug list. Check it out. See if there are any problems. >>> >> Also check out the wiki page for other notes and status: >>> >> >>> >> https://wiki.gnucash.org/wiki/Bugzilla_Administration#New_Installatio >>> >> n >>> >> >>> >> NOTES: >>> >> 1) All users have accounts in the database, but you will need to reset >>> >>your password in order to access it. >>> >> 2) The database will be blown away when we perform the final migration, >>> >>so you will need to reset your password again when we do the final >>> >>migration. >>> >> 3) Bug creation will not work, so don't try. >>> >> 4) I have not migrated any GnomeBZ extensions -- we can always add >> those >>> >>later (e.g. their browse page). >>> >> >>> >> Final migration is planned for the week of June 25. >>> >> >>> >> Please let me know if you find any issues! >>> >> >>> >> Thanks, >>> >> >>> >> -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 >>> >>warl...@mit.eduPGP key available >>> >> >>> >> >>> >> -- >>> > >>> > 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. >>> > >>> > Regards, Chris Good >>> > >>> > ___ >>> > gnucash-devel mailing list >>> > gnucash-devel@gnucash.org >>> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel >>> > > > > ___ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Thanks. -derek Sent using my mobile device. Please excuse any typos. On June 16, 2018 4:15:12 AM "Chris Good" wrote: Hi Derek, I have added this task to the wiki TODO list. Regards, Chris Good -Original Message- From: Derek Atkins Sent: Saturday, 16 June 2018 6:09 PM To: Chris Good ; gnucash-devel@gnucash.org Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing Interesting. I wonder if there in an import confusion between edt and gmt? Please add this to the wiki todo list? -derek Sent using my mobile device. Please excuse any typos. On June 16, 2018 1:18:19 AM "Chris Good" wrote: >> Message: 6 >> Date: Fri, 15 Jun 2018 17:18:05 -0400 >> From: Derek Atkins >> To: gnucash-devel@gnucash.org >> Subject: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing >> Message-ID: >> Content-Type: text/plain >> >> Hi Everyone, >> >> I've been working on the BZ migration and finished yet another >> migration > test. >> At this point I *THINK* we've got everything the way we want in > preparation for >> our final migration. >> >> Please take a look at https://bugs.gnucash.org/ >> >> Peruse the bug list. Check it out. See if there are any problems. >> Also check out the wiki page for other notes and status: >> >> https://wiki.gnucash.org/wiki/Bugzilla_Administration#New_Installatio >> n >> >> NOTES: >> 1) All users have accounts in the database, but you will need to reset >>your password in order to access it. >> 2) The database will be blown away when we perform the final migration, >>so you will need to reset your password again when we do the final >>migration. >> 3) Bug creation will not work, so don't try. >> 4) I have not migrated any GnomeBZ extensions -- we can always add those >>later (e.g. their browse page). >> >> Final migration is planned for the week of June 25. >> >> Please let me know if you find any issues! >> >> Thanks, >> >> -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 >>warl...@mit.eduPGP key available >> >> >> -- > > 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. > > Regards, Chris Good > > ___ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Hi Derek, I have added this task to the wiki TODO list. Regards, Chris Good > -Original Message- > From: Derek Atkins > Sent: Saturday, 16 June 2018 6:09 PM > To: Chris Good ; gnucash-devel@gnucash.org > Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing > > Interesting. > I wonder if there in an import confusion between edt and gmt? > Please add this to the wiki todo list? > > -derek > Sent using my mobile device. Please excuse any typos. > On June 16, 2018 1:18:19 AM "Chris Good" wrote: > > >> Message: 6 > >> Date: Fri, 15 Jun 2018 17:18:05 -0400 > >> From: Derek Atkins > >> To: gnucash-devel@gnucash.org > >> Subject: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing > >> Message-ID: > >> Content-Type: text/plain > >> > >> Hi Everyone, > >> > >> I've been working on the BZ migration and finished yet another > >> migration > > test. > >> At this point I *THINK* we've got everything the way we want in > > preparation for > >> our final migration. > >> > >> Please take a look at https://bugs.gnucash.org/ > >> > >> Peruse the bug list. Check it out. See if there are any problems. > >> Also check out the wiki page for other notes and status: > >> > >> https://wiki.gnucash.org/wiki/Bugzilla_Administration#New_Installatio > >> n > >> > >> NOTES: > >> 1) All users have accounts in the database, but you will need to reset > >>your password in order to access it. > >> 2) The database will be blown away when we perform the final migration, > >>so you will need to reset your password again when we do the final > >>migration. > >> 3) Bug creation will not work, so don't try. > >> 4) I have not migrated any GnomeBZ extensions -- we can always add those > >>later (e.g. their browse page). > >> > >> Final migration is planned for the week of June 25. > >> > >> Please let me know if you find any issues! > >> > >> Thanks, > >> > >> -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 > >>warl...@mit.eduPGP key available > >> > >> > >> -- > > > > 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. > > > > Regards, Chris Good > > > > ___ > > gnucash-devel mailing list > > gnucash-devel@gnucash.org > > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Interesting. I wonder if there in an import confusion between edt and gmt? Please add this to the wiki todo list? -derek Sent using my mobile device. Please excuse any typos. On June 16, 2018 1:18:19 AM "Chris Good" wrote: Message: 6 Date: Fri, 15 Jun 2018 17:18:05 -0400 From: Derek Atkins To: gnucash-devel@gnucash.org Subject: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing Message-ID: Content-Type: text/plain Hi Everyone, I've been working on the BZ migration and finished yet another migration test. At this point I *THINK* we've got everything the way we want in preparation for our final migration. Please take a look at https://bugs.gnucash.org/ Peruse the bug list. Check it out. See if there are any problems. Also check out the wiki page for other notes and status: https://wiki.gnucash.org/wiki/Bugzilla_Administration#New_Installation NOTES: 1) All users have accounts in the database, but you will need to reset your password in order to access it. 2) The database will be blown away when we perform the final migration, so you will need to reset your password again when we do the final migration. 3) Bug creation will not work, so don't try. 4) I have not migrated any GnomeBZ extensions -- we can always add those later (e.g. their browse page). Final migration is planned for the week of June 25. Please let me know if you find any issues! Thanks, -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 warl...@mit.eduPGP key available -- 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. Regards, Chris Good ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
> Message: 6 > Date: Fri, 15 Jun 2018 17:18:05 -0400 > From: Derek Atkins > To: gnucash-devel@gnucash.org > Subject: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing > Message-ID: > Content-Type: text/plain > > Hi Everyone, > > I've been working on the BZ migration and finished yet another migration test. > At this point I *THINK* we've got everything the way we want in preparation for > our final migration. > > Please take a look at https://bugs.gnucash.org/ > > Peruse the bug list. Check it out. See if there are any problems. > Also check out the wiki page for other notes and status: > https://wiki.gnucash.org/wiki/Bugzilla_Administration#New_Installation > > NOTES: > 1) All users have accounts in the database, but you will need to reset >your password in order to access it. > 2) The database will be blown away when we perform the final migration, >so you will need to reset your password again when we do the final >migration. > 3) Bug creation will not work, so don't try. > 4) I have not migrated any GnomeBZ extensions -- we can always add those >later (e.g. their browse page). > > Final migration is planned for the week of June 25. > > Please let me know if you find any issues! > > Thanks, > > -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 >warl...@mit.eduPGP key available > > > -- 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. Regards, Chris Good ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Since that is almost the same time as release 3.2 happens there could be a flurry of users wanting to read bugs listed in the release announcement and perhaps enter new bugs or updates. I suggest that the 6.3 release announcement mention the BZ release and warn as appropriate. David C On Fri, Jun 15, 2018, 4:19 PM Derek Atkins wrote: > Hi Everyone, > > I've been working on the BZ migration and finished yet another migration > test. At this point I *THINK* we've got everything the way we want in > preparation for our final migration. > > Please take a look at https://bugs.gnucash.org/ > > Peruse the bug list. Check it out. See if there are any problems. > Also check out the wiki page for other notes and status: > https://wiki.gnucash.org/wiki/Bugzilla_Administration#New_Installation > > NOTES: > 1) All users have accounts in the database, but you will need to reset >your password in order to access it. > 2) The database will be blown away when we perform the final migration, >so you will need to reset your password again when we do the final >migration. > 3) Bug creation will not work, so don't try. > 4) I have not migrated any GnomeBZ extensions -- we can always add those >later (e.g. their browse page). > > Final migration is planned for the week of June 25. > > Please let me know if you find any issues! > > Thanks, > > -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 >warl...@mit.eduPGP key available > ___ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
[GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
Hi Everyone, I've been working on the BZ migration and finished yet another migration test. At this point I *THINK* we've got everything the way we want in preparation for our final migration. Please take a look at https://bugs.gnucash.org/ Peruse the bug list. Check it out. See if there are any problems. Also check out the wiki page for other notes and status: https://wiki.gnucash.org/wiki/Bugzilla_Administration#New_Installation NOTES: 1) All users have accounts in the database, but you will need to reset your password in order to access it. 2) The database will be blown away when we perform the final migration, so you will need to reset your password again when we do the final migration. 3) Bug creation will not work, so don't try. 4) I have not migrated any GnomeBZ extensions -- we can always add those later (e.g. their browse page). Final migration is planned for the week of June 25. Please let me know if you find any issues! Thanks, -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 warl...@mit.eduPGP key available ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel