~~~ Please read before posting. ~~~

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

DB Error - 7931 clubsite

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

DB Error - 7931 clubsite

6 years 6 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

6 years 6 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

6 years 6 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

6 years 6 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

6 years 6 months ago
#75173
The topic has been locked.
  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 11526
  • Thanks: 3050

Re: DB Error - 7931 clubsite

6 years 6 months ago
#75184
FIXED Sorry for any inconvenience.
The following user(s) said Thank You: elaine.toastmaster
The topic has been locked.
Moderators: BrianPamrhtaylor3marc33NotLiableNSBjgavinHeniLcala305peterb323DebbieT
Time to create page: 0.723 seconds