ZoneMinder Forums

Posted: **Wed May 27, 2020 3:32 am**

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

Posted: **Wed May 27, 2020 6:50 am**

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 )

Posted: **Wed May 27, 2020 6:18 pm**

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.

ZoneMinder Forums

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

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

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

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