Migrating to FTH4

Your club admin received the instructions to update their admin password to access FTH4. (FTH3 admin passwords will NOT work in FTH4). Follow the instructions in the email and use 'Member sign in' in the top right corner to access the Club Admin account.

If you are not sure who the club admin is, in your member account; look at 'Club Officers and Members' > "Club Email addresses". The LAST item in this list is the person who is currently listed as your club admin.

If this is not correct, please complete and submit this form to change your club admin:
www.toastmastersclubs.org/welcome/change-admin/

Data Transfer error when going to the

  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Emeritus
  • Emeritus
  • Posts: 11492
  • Thanks: 3057

Re: Data Transfer error when going to the

7 years 7 months ago - 7 years 7 months ago
#74274
Ok, everyone.... the cause of this issue is "none of the above". :lol:

This was a weird one... Somehow, a new member record for "Cormac" was created with a DATEDEACTIVATED date of 2019-03-10 02:13:55 which is an invalid nonsense time because of the daylight savings time jump that occurred last night. *All* new members are created as deactivated (DATEDEACTIVATED set). If this member had clicked the opt-in link in the email, it is likely this would have cleared the deactivated date and "magically fixed" the problem... we would not have known what happened. Kudos to the OP for posting on this... a new wierd thing for me to be aware of. :thumbsup:

This is such an unusual thing to have happened that the code does not have any check for it (not sure how to check for it) and the date parsing crashed on it which is what was causing the membership load error. I will have to chew on this a bit... too many date parsing issues currently.

My only recourse in this case was to do an ad-hoc query to change this date and time in the db to a valid time that will not crash the date parser.

The membership module should load now... Lots of member records... are all of those members still active and valid? (separate observation related to email hygiene) Kudos if so... please clean up if not.
Last edit: 7 years 7 months ago by SteveTheTechie.
The following user(s) said Thank You: mrscarrasco
The topic has been locked.
  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Emeritus
  • Emeritus
  • Posts: 11492
  • Thanks: 3057

Re: Data Transfer error when going to the

7 years 7 months ago
#74275
There were 13 other new member records in our full DB that also had this bogus time issue.

I just changed all of those to reflect 4am as the time.

Be advised we may see other weird stuff because of the daylight savings time jump... We sometimes get strange things happening because of that.
The following user(s) said Thank You: Pam
The topic has been locked.
  • mrscarrasco
  • mrscarrasco's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 4
  • Thanks: 1

Re: Data Transfer error when going to the

7 years 7 months ago
#74276
Thanks Steve! I appreciate your help with this and on a Sunday too! The member page is now opening just fine.
The following user(s) said Thank You: SteveTheTechie
The topic has been locked.
Moderators: Brian, Heni, Pam, RichardT, NotLiable, NSB, jgavin, Lcala305, peterb323, DebbieT
Time to create page: 0.157 seconds