Unknown column 'Monitor.DefaultView' in 'field list'

Forum for questions and support relating to the 1.34.x releases only.
Post Reply
anorth
Posts: 5
Joined: Thu May 07, 2020 10:55 pm

Unknown column 'Monitor.DefaultView' in 'field list'

Post 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.
User avatar
iconnor
Posts: 3362
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Unknown column 'Monitor.DefaultView' in 'field list'

Post 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.
anorth
Posts: 5
Joined: Thu May 07, 2020 10:55 pm

Re: Unknown column 'Monitor.DefaultView' in 'field list'

Post by anorth »

http://10.40.67.10/zm/api/monitors.json when I go to this. I found it in the troubleshooting for zmninja.
anorth
Posts: 5
Joined: Thu May 07, 2020 10:55 pm

Re: Unknown column 'Monitor.DefaultView' in 'field list'

Post 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"}}}
anorth
Posts: 5
Joined: Thu May 07, 2020 10:55 pm

Re: Unknown column 'Monitor.DefaultView' in 'field list'

Post by anorth »

If I disable all authentication getVersion works but I still get the column not found error on monitors.json
anorth
Posts: 5
Joined: Thu May 07, 2020 10:55 pm

Re: Unknown column 'Monitor.DefaultView' in 'field list'

Post by anorth »

I ran zmupdate.pl -c and -f and then disable authentication and it works. Enabling authentication still fails.
Post Reply