SQL-ERR 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ONVIF_URL' in 'field list''

[sunriseblvd]

ZoneMinder won't let me add a camera.

When I looked at the log, here's what was in there:

[Date/Time] : 2020-05-26 22:12:39

[component] : web_php

[Server] :

[PID] : 8381

[Level] : ERR

[Message] : SQL-ERR 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ONVIF_URL' in 'field list'', statement was 'INSERT INTO Monitors (`Id`, `Name`, `Notes`, `ServerId`, `StorageId`, `Type`, `Function`, `Enabled`, `LinkedMonitors`, `Triggers`, `ONVIF_URL`, `ONVIF_Username`, `ONVIF_Password`, `ONVIF_Options`, `Device`, `Channel`, `Format`, `V4LMultiBuffer`, `V4LCapturesPerFrame`, `Protocol`, `Method`, `Host`, `Port`, `SubPath`, `Path`, `Options`, `User`, `Pass`, `Width`, `Height`, `Colours`, `Palette`, `Orientation`, `Deinterlacing`, `DecoderHWAccelName`, `DecoderHWAccelDevice`, `SaveJPEGs`, `VideoWriter`, `OutputCodec`, `OutputContainer`, `EncoderParameters`, `RecordAudio`, `RTSPDescribe`, `Brightness`, `Contrast`, `Hue`, `Colour`, `EventPrefix`, `LabelFormat`, `LabelX`, `LabelY`, `LabelSize`, `ImageBufferCount`, `WarmupCount`, `PreEventCount`, `PostEventCount`, `StreamReplayBuffer`, `AlarmFrameCount`, `SectionLength`, `MinSectionLength`, `FrameSkip`, `MotionFrameSkip`, `AnalysisFPSLimit`, `AnalysisUpdateDelay`, `MaxFPS`, `AlarmMaxFPS`, `FPSReportInterval`, `RefBlendPerc`, `AlarmRefBlendPerc`, `Controllable`, `ControlId`, `ControlDevice`, `ControlAddress`, `AutoStopTimeout`, `TrackMotion`, `TrackDelay`, `ReturnLocation`, `ReturnDelay`, `DefaultRate`, `DefaultScale`, `SignalCheckPoints`, `SignalCheckColour`, `WebColour`, `Exif`, `Sequence`, `ZoneCount`, `Refresh`, `DefaultCodec`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' params:,MoneyCam,,0,0,Ffmpeg,Mocord,1,,,,,,,,0,0,,1,,rtpRtsp,,,,rtsp://admin:xxxxxxxx@192.168.1.203:554/stream0,,,,2592,1944,4,0,ROTATE_0,0,,,3,0,,,# Lines beginning with # are a comment # For changing quality, use the crf option# 1 is best, 51 is worst quality#crf=23,0,0,-1,-1,-1,-1,Event-,%N - %d/%m/%y %H:%M:%S,0,0,1,20,0,5,5,0,1,600,10,0,0,,0,,,100,6,6,0,,,,,0,,-1,,100,100,0,#0000BE,#fbdaaf,0,1,0,,auto

[bkjaya1952]

I had the same error. Then I got the solution from Mr . Isaac Connor.

Try
mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.35.4.sql

( password is zmpass )

[sunriseblvd]

I tried that too but with zm_update.sql (the one without a specific version number) and it didn't work. Ultimately I just manually added the columns to the SQL table with MySQLWorkbench but this should really be in the instructions. There's absolutely no way this is grandma proof.