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

classic Classic list List threaded Threaded
20 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins
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
       [hidden email]                        PGP key available
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

David Carlson-4
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 <[hidden email]> 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
>        [hidden email]                        PGP key available
> _______________________________________________
> gnucash-devel mailing list
> [hidden email]
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

ChrisGood
In reply to this post by Derek Atkins
> Message: 6
> Date: Fri, 15 Jun 2018 17:18:05 -0400
> From: Derek Atkins <[hidden email]>
> To: [hidden email]
> Subject: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
> Message-ID: <[hidden email]>
> 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
>        [hidden email]                        PGP 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
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins-3
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" <[hidden email]> wrote:

>> Message: 6
>> Date: Fri, 15 Jun 2018 17:18:05 -0400
>> From: Derek Atkins <[hidden email]>
>> To: [hidden email]
>> Subject: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
>> Message-ID: <[hidden email]>
>> 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
>>        [hidden email]                        PGP 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
> [hidden email]
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel



_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

ChrisGood
Hi Derek,

I have added this task to the wiki TODO list.

Regards, Chris Good

> -----Original Message-----
> From: Derek Atkins <[hidden email]>
> Sent: Saturday, 16 June 2018 6:09 PM
> To: Chris Good <[hidden email]>; [hidden email]
> 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" <[hidden email]> wrote:
>
> >> Message: 6
> >> Date: Fri, 15 Jun 2018 17:18:05 -0400
> >> From: Derek Atkins <[hidden email]>
> >> To: [hidden email]
> >> Subject: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
> >> Message-ID: <[hidden email]>
> >> 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
> >>        [hidden email]                        PGP 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
> > [hidden email]
> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>

_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins-3
Thanks.

-derek
Sent using my mobile device. Please excuse any typos.
On June 16, 2018 4:15:12 AM "Chris Good" <[hidden email]> wrote:

> Hi Derek,
>
> I have added this task to the wiki TODO list.
>
> Regards, Chris Good
>
>> -----Original Message-----
>> From: Derek Atkins <[hidden email]>
>> Sent: Saturday, 16 June 2018 6:09 PM
>> To: Chris Good <[hidden email]>; [hidden email]
>> 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" <[hidden email]> wrote:
>>
>> >> Message: 6
>> >> Date: Fri, 15 Jun 2018 17:18:05 -0400
>> >> From: Derek Atkins <[hidden email]>
>> >> To: [hidden email]
>> >> Subject: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
>> >> Message-ID: <[hidden email]>
>> >> 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
>> >>        [hidden email]                        PGP 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
>> > [hidden email]
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>



_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

John Ralls-2
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 <[hidden email]> wrote:
>
> Thanks.
>
> -derek
> Sent using my mobile device. Please excuse any typos.
> On June 16, 2018 4:15:12 AM "Chris Good" <[hidden email]> wrote:
>
>> Hi Derek,
>>
>> I have added this task to the wiki TODO list.
>>
>> Regards, Chris Good
>>
>>> -----Original Message-----
>>> From: Derek Atkins <[hidden email]>
>>> Sent: Saturday, 16 June 2018 6:09 PM
>>> To: Chris Good <[hidden email]>; [hidden email]
>>> 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" <[hidden email]> wrote:
>>>
>>> >> Message: 6
>>> >> Date: Fri, 15 Jun 2018 17:18:05 -0400
>>> >> From: Derek Atkins <[hidden email]>
>>> >> To: [hidden email]
>>> >> Subject: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
>>> >> Message-ID: <[hidden email]>
>>> >> 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
>>> >>        [hidden email]                        PGP 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
>>> > [hidden email]
>>> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>>
>
>
>
> _______________________________________________
> gnucash-devel mailing list
> [hidden email]
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel

_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

Richard Ullger-2
In reply to this post by Derek Atkins
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


_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

signature.asc (499 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins
In reply to this post by ChrisGood
Chris,

"Chris Good" <[hidden email]> 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
       [hidden email]                        PGP key available
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins
In reply to this post by John Ralls-2
John Ralls <[hidden email]> 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
       [hidden email]                        PGP key available
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins
In reply to this post by Richard Ullger-2
Hi,

Thanks for catching this.  I'll go take a look.

-derek

Richard Ullger <[hidden email]> 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
> [hidden email]
> 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
       [hidden email]                        PGP key available
_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins-3
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 <[hidden email]> 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
>> [hidden email]
>> 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
>        [hidden email]                        PGP key available
> _______________________________________________
> gnucash-devel mailing list
> [hidden email]
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


--
       Derek Atkins                 617-623-3745
       [hidden email]             www.ihtfp.com
       Computer and Internet Security Consultant

_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

Richard Ullger-2
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 <[hidden email]> 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.



_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

signature.asc (499 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

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

ChrisGood
In reply to this post by Derek Atkins
> -----Original Message-----
> From: Derek Atkins <[hidden email]>
> Sent: Tuesday, 26 June 2018 11:30 PM
> To: Chris Good <[hidden email]>
> Cc: [hidden email]
> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
>
> Chris,
>
> "Chris Good" <[hidden email]> 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
>        [hidden email]                        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 [hidden email] 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
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins
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" <[hidden email]> wrote:

>> -----Original Message-----
>> From: Derek Atkins <[hidden email]>
>> Sent: Tuesday, 26 June 2018 11:30 PM
>> To: Chris Good <[hidden email]>
>> Cc: [hidden email]
>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
>>
>> Chris,
>>
>> "Chris Good" <[hidden email]> 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
>>        [hidden email]                        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 [hidden email] 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
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

John Ralls-2
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 <[hidden email]> 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" <[hidden email]> wrote:
>
>>> -----Original Message-----
>>> From: Derek Atkins <[hidden email]>
>>> Sent: Tuesday, 26 June 2018 11:30 PM
>>> To: Chris Good <[hidden email]>
>>> Cc: [hidden email]
>>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
>>>
>>> Chris,
>>>
>>> "Chris Good" <[hidden email]> 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
>>>       [hidden email]                        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 [hidden email] 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
> [hidden email]
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel

_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins
Yeah. I figured it was something like that, and indeed that was my plan.  
I'll execute it once I get back to my laptop.

-derek
Sent using my mobile device. Please excuse any typos.
On June 30, 2018 8:46:50 PM John Ralls <[hidden email]> 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 <[hidden email]> 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" <[hidden email]> wrote:
>>
>>>> -----Original Message-----
>>>> From: Derek Atkins <[hidden email]>
>>>> Sent: Tuesday, 26 June 2018 11:30 PM
>>>> To: Chris Good <[hidden email]>
>>>> Cc: [hidden email]
>>>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final Testing
>>>>
>>>> Chris,
>>>>
>>>> "Chris Good" <[hidden email]> 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
>>>>       [hidden email]                        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 [hidden email] 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
>> [hidden email]
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel



_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

Derek Atkins-3
In reply to this post by John Ralls-2
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 <[hidden email]> 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" <[hidden email]> wrote:
>>
>>>> -----Original Message-----
>>>> From: Derek Atkins <[hidden email]>
>>>> Sent: Tuesday, 26 June 2018 11:30 PM
>>>> To: Chris Good <[hidden email]>
>>>> Cc: [hidden email]
>>>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final
>>>> Testing
>>>>
>>>> Chris,
>>>>
>>>> "Chris Good" <[hidden email]> 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
>>>>       [hidden email]                        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 [hidden email] 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
>> [hidden email]
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
>


--
       Derek Atkins                 617-623-3745
       [hidden email]             www.ihtfp.com
       Computer and Internet Security Consultant

_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

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

ChrisGood
Hi Derek + John,

Works now thanks.

Regards, Chris Good

> -----Original Message-----
> From: Derek Atkins <[hidden email]>
> Sent: Sunday, 1 July 2018 11:25 AM
> To: John Ralls <[hidden email]>
> Cc: Derek Atkins <[hidden email]>; Chris Good <[hidden email]>;
> [hidden email]
> 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 <[hidden email]> 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" <[hidden email]>
> wrote:
> >>
> >>>> -----Original Message-----
> >>>> From: Derek Atkins <[hidden email]>
> >>>> Sent: Tuesday, 26 June 2018 11:30 PM
> >>>> To: Chris Good <[hidden email]>
> >>>> Cc: [hidden email]
> >>>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final
> >>>> Testing
> >>>>
> >>>> Chris,
> >>>>
> >>>> "Chris Good" <[hidden email]> 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
> >>>>       [hidden email]                        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 [hidden email] 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

_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Reply | Threaded
Open this post in threaded view
|

Re: [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" <[hidden email]> wrote:

> Hi Derek + John,
>
> Works now thanks.
>
> Regards, Chris Good
>
>> -----Original Message-----
>> From: Derek Atkins <[hidden email]>
>> Sent: Sunday, 1 July 2018 11:25 AM
>> To: John Ralls <[hidden email]>
>> Cc: Derek Atkins <[hidden email]>; Chris Good <[hidden email]>;
>> [hidden email]
>> 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 <[hidden email]> 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" <[hidden email]>
>> wrote:
>> >>
>> >>>> -----Original Message-----
>> >>>> From: Derek Atkins <[hidden email]>
>> >>>> Sent: Tuesday, 26 June 2018 11:30 PM
>> >>>> To: Chris Good <[hidden email]>
>> >>>> Cc: [hidden email]
>> >>>> Subject: Re: [GNC-dev] BZ: Migration Status (2018-06-15) -- Final
>> >>>> Testing
>> >>>>
>> >>>> Chris,
>> >>>>
>> >>>> "Chris Good" <[hidden email]> 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
>> >>>>       [hidden email]                        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 [hidden email] 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



_______________________________________________
gnucash-devel mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel