IMPORTANT INFORMATION -- Please read!

1. The "search..." box above searches the Docs & Forum Posts. The "Search" tab above just searches the Forum Posts. :side:
Please use these to search for your issue *before* creating a new message topic, as your issue may have been previously solved.
2. Please put your Club # and Club Web Address in your Forum Signature (best) OR in each post to get faster support from us.
Click here to edit your signature at the bottom of the Profile Information tab.
3. Our user and admin docs are available at: support.toastmastersclubs.org/doc "There's a doc for that!"
4. There is an "Opt In" Feature for newly added members. The Opt In document explains the ~~strikethrough~~ member information. Click Here to View the Post
5. When posting a New Topic , please include all relevant details and be specific. When did your issue 1st occur? What operating system, browser, & browser version are you using? Did you refresh your browser cache? Are your cookies enabled? Lastly, a screen shot is often helpful.
6. Please abide by the Terms of Use . We are volunteers contributing our spare time. We are happy to assist you, so long as you are respectful and courteous.
7. We are always looking for new FreeToastHost Ambassadors to join our team and support fellow Toastmasters in their use of the FreeToastHost website system. If you are familiar with the system and have some interest, send a Send Us a Private Message.

Data Transfer error when going to the

SteveTheTechie
Offline
Administrator

More

6 years 4 months ago - 6 years 4 months ago #74274 by SteveTheTechie

Replied by SteveTheTechie on topic Data Transfer error when going to the

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: 6 years 4 months ago by SteveTheTechie.

The following user(s) said Thank You: mrscarrasco

The topic has been locked.

SteveTheTechie
Offline
Administrator

More

6 years 4 months ago #74275 by SteveTheTechie

Replied by SteveTheTechie on topic Data Transfer error when going to the

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.