~~~ 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.

Unable to Access Agendas

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

Unable to Access Agendas

6 years 7 months 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
  • Administrator
  • Administrator
  • Posts: 11526
  • Thanks: 3050

Re: Unable to Access Agendas

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

6 years 7 months ago
#73744
Great!

Thank you.
The topic has been locked.
Moderators: BrianJane AtkinsonPamrhtaylor3marc33NotLiablejgavinLcala305peterb323
Time to create page: 0.235 seconds