Page 1 of 1
Unknown column 'Monitor.DefaultView' in 'field list'
Posted: Thu May 07, 2020 11:08 pm
by anorth
Updated to 1.34.11 had problems with the database updating finally got it to work but now my api's do not work. I looked in the database and I don't see a DefaultView field at all.
Re: Unknown column 'Monitor.DefaultView' in 'field list'
Posted: Thu May 07, 2020 11:58 pm
by iconnor
Um... I could be wrong... but I seem to recall removing all references to that column because it isn't used anymore...
So... where are you seeing it?
I just did a quick grep over the source and can't find a single mention of it.
Re: Unknown column 'Monitor.DefaultView' in 'field list'
Posted: Fri May 08, 2020 12:17 am
by anorth
http://10.40.67.10/zm/api/monitors.json when I go to this. I found it in the troubleshooting for zmninja.
Re: Unknown column 'Monitor.DefaultView' in 'field list'
Posted: Fri May 08, 2020 12:31 am
by anorth
Okay if I enable legacy api authentication I get
Code: Select all
{"success":false,"data":{"name":"An Internal Error Has Occurred.","message":"An Internal Error Has Occurred.","url":"\/zm\/api\/monitors.json","exception":{"class":"PDOException","code":"42S22","message":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Monitor.DefaultView' in 'field list'"}}}
if I disable it I get
Code: Select all
{"success":false,"data":{"name":"Not Authenticated","message":"Not Authenticated","url":"\/zm\/api\/monitors.json","exception":{"class":"UnauthorizedException","code":401,"message":"Not Authenticated"}}}
Re: Unknown column 'Monitor.DefaultView' in 'field list'
Posted: Fri May 08, 2020 5:01 am
by anorth
If I disable all authentication getVersion works but I still get the column not found error on monitors.json
Re: Unknown column 'Monitor.DefaultView' in 'field list'
Posted: Fri May 08, 2020 5:13 am
by anorth
I ran zmupdate.pl -c and -f and then disable authentication and it works. Enabling authentication still fails.