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.

Unable to Access Agendas

  • kenmatos
  • kenmatos's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 28
  • Thanks: 3

Unable to Access Agendas

7 years 1 month ago
#73735
Any idea what this error message is?

GetRowsAsArrays_DBI[MEETING](Callers=>main::GetRowsAsArrays_MeetingDB>main::GetAgendaRows_AgendaDB): Unable to execute query: [SELECT MEETINGDATE,MEETINGSTARTTIME,CMEETINGDESC,MEETINGNOTESJSON,ATTACHMENTS,(DATEDIFF(MEETINGDATE,CONVERT_TZ(NOW(),'GMT','US/Eastern'))<0) as ISPAST FROM MEETING WHERE MEETINGID='01134735' and ROWTYPE='normal' and DATEDELETED=0 (Bind Values=)] Error=[Unknown column 'MEETINGNOTESJSON' in 'field list']

Sunday morning 1/27/19 at 6:50 ET
The topic has been locked.
  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Emeritus
  • Emeritus
  • Posts: 11492
  • Thanks: 3057

Re: Unable to Access Agendas

7 years 1 month ago
#73739
Made some table changes in the db... got my steps out of order.

Should be fine now. (I checked)
The topic has been locked.
  • kenmatos
  • kenmatos's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 28
  • Thanks: 3

Re: Unable to Access Agendas

7 years 1 month ago
#73744
Great!

Thank you.
The topic has been locked.
Moderators: BrianHeniPamrhtaylor3marc33NotLiableNSBjgavinLcala305peterb323DebbieT
Time to create page: 0.161 seconds