Important: when posting, please provide your Club Number at a minimum, and as many details as possible.
For further info, please read This page before posting.

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/

DB Error - 7931 clubsite

  • JJSteele
  • JJSteele's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 2
  • Thanks: 0

DB Error - 7931 clubsite

7 years 3 months ago
#75157
Error message when clicking on Agenda:
Software error:

GetRowsAsArrays_DBI[MEETING](Callers=>main::GetRowsAsArrays_MeetingDB>main::TemplateSelect_MeetingDB): Unable to execute query: [SELECT MEETINGID,MEETINGNAME FROM MEETING WHERE ROWTYPE='system' or (ROWTYPE='template' and ALIAS='clubdefaults') order by MEETINGNAME,MEETINGID (Bind Values=)] Error=[Unknown column 'ALIAS' in 'where clause']

Clubsite:https://7931.toastmastersclubs.org/
Jeri Steele, DTM & VPE

For help, please send mail to the webmaster (root@localhost), giving this error message and the time and date of the error.
Jeri Steele, DTM, President, #7931 Thoroughbred Toastmasters
The topic has been locked.
  • scottsutton
  • scottsutton's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 1
  • Thanks: 0

Re: DB Error - 7931 clubsite

7 years 3 months ago
#75168
I'm getting the same error on our site, 111toastmasters.org. I've tried both using my own details and the admin login, and I get the following error after it tries to process the login:

Software error:

GetRowsAsArrays_DBI[MEETING](Callers=>main::GetRowsAsArrays_MeetingDB>main::TemplateSelect_MeetingDB): Unable to execute query: [SELECT MEETINGID,MEETINGNAME FROM MEETING WHERE ROWTYPE='system' or (ROWTYPE='template' and ALIAS='clubdefaults') order by MEETINGNAME,MEETINGID (Bind Values=)] Error=[Unknown column 'ALIAS' in 'where clause']

For help, please send mail to the webmaster (root@localhost), giving this error message and the time and date of the error.
The topic has been locked.
  • ScottStevenson
  • ScottStevenson's Avatar
  • New Member
  • New Member
  • Thanks: 0

Re: DB Error - 7931 clubsite

7 years 3 months ago
#75170
Same problem here with my (3) clubs.

Scott Stevenson
#3346, #5588, #6222
The topic has been locked.
  • greencmg
  • greencmg's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 1
  • Thanks: 0

Re: DB Error - 7931 clubsite

7 years 3 months ago
#75172
Same error here...
The topic has been locked.
  • elaine.toastmaster
  • elaine.toastmaster's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 4
  • Thanks: 0

Re: DB Error - 7931 clubsite

7 years 3 months ago
#75173
The topic has been locked.
  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Emeritus
  • Emeritus
  • Posts: 11492
  • Thanks: 3057

Re: DB Error - 7931 clubsite

7 years 3 months ago
#75184
FIXED Sorry for any inconvenience.
The following user(s) said Thank You: elaine.toastmaster
The topic has been locked.
Moderators: Brian, Pam, RichardT, NotLiable, NSB, jgavin, Heni, Lcala305, peterb323, DebbieT
Time to create page: 0.155 seconds

Latest Forum Posts