I compiled Asterisk 15.2 with ODBC support for voicemail and created the table in db per sql script in realtime folder. I have verified that the table populates with data when vm is stored and that I can access vm with sip phone. The issue is that neither the freepbx 14 vm admin nor the vm app in ucp can access this data.
app_voicemail.c:3972 retrieve_file: SQL Get Data error! coltitle=category
[SELECT * FROM voicemail WHERE dir=? AND msgnum=?]
Does anyone know how to resolve this error?