We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Hello!
Recently i just updated to 1.37.53. Now i cant change anything in any monitor nor can add a new one. The error is this every time: SQL-ERR '00000 ', statement was 'UPDATE Monitors SET Id=?, Name=?, Deleted=?, Notes=?, ServerId=?, StorageId=?, ManufacturerId=?, ModelId=?, Type=?, Capturing=?, Analysing=?, Recording=?, RecordingSource=?, AnalysisSource=?, AnalysisImage=?, Enabled=?, Decoding=?, RTSP2WebEnabled=?, RTSP2WebType=?, JanusEnabled=?, JanusAudioEnabled=?, Janus_Profile_Override=?, Janus_Use_RTSP_Restream=?, Janus_RTSP_User=?, Janus_RTSP_Session_Timeout=?, LinkedMonitors=?, Triggers=?, EventStartCommand=?, EventEndCommand=?, ONVIF_URL=?, ONVIF_Username=?, ONVIF_Password=?, ONVIF_Options=?, ONVIF_Alarm_Text=?, ONVIF_Event_Listener=?, use_Amcrest_API=?, Device=?, Channel=?, Format=?, V4LMultiBuffer=?, V4LCapturesPerFrame=?, Protocol=?, Method=?, Host=?, Port=?, SubPath=?, Path=?, SecondPath=?, Options=?, User=?, Pass=?, Width=?, Height=?, Colours=?, Palette=?, Orientation=?, Deinterlacing=?, Decoder=?, DecoderHWAccelName=?, DecoderHWAccelDevice=?, SaveJPEGs=?, VideoWriter=?, OutputCodec=?, Encoder=?, OutputContainer=?, EncoderParameters=?, RecordAudio=?, RTSPDescribe=?, Brightness=?, Contrast=?, Hue=?, Colour=?, EventPrefix=?, LabelFormat=?, LabelX=?, LabelY=?, LabelSize=?, ImageBufferCount=?, MaxImageBufferCount=?, WarmupCount=?, PreEventCount=?, PostEventCount=?, StreamReplayBuffer=?, AlarmFrameCount=?, SectionLength=?, SectionLengthWarn=?, MinSectionLength=?, EventStartMode=?, EventCloseMode=?, FrameSkip=?, MotionFrameSkip=?, AnalysisFPSLimit=?, AnalysisUpdateDelay=?, MaxFPS=?, AlarmMaxFPS=?, FPSReportInterval=?, RefBlendPerc=?, AlarmRefBlendPerc=?, Controllable=?, ControlId=?, ControlDevice=?, ControlAddress=?, AutoStopTimeout=?, TrackMotion=?, TrackDelay=?, ReturnLocation=?, ReturnDelay=?, ModectDuringPTZ=?, DefaultRate=?, DefaultScale=?, SignalCheckPoints=?, SignalCheckColour=?, WebColour=?, Exif=?, Sequence=?, ZoneCount=?, Refresh=?, DefaultCodec=?, Latitude=?, Longitude=?, RTSPServer=?, RTSPStreamName=?, SOAP_wsa_compl=?, Importance=?, MQTT_Enabled=?, MQTT_Subscriptions=? WHERE Id=?'
Monitors
Id
Name
Deleted
Notes
ServerId
StorageId
ManufacturerId
ModelId
Type
Capturing
Analysing
Recording
RecordingSource
AnalysisSource
AnalysisImage
Enabled
Decoding
RTSP2WebEnabled
RTSP2WebType
JanusEnabled
JanusAudioEnabled
Janus_Profile_Override
Janus_Use_RTSP_Restream
Janus_RTSP_User
Janus_RTSP_Session_Timeout
LinkedMonitors
Triggers
EventStartCommand
EventEndCommand
ONVIF_URL
ONVIF_Username
ONVIF_Password
ONVIF_Options
ONVIF_Alarm_Text
ONVIF_Event_Listener
use_Amcrest_API
Device
Channel
Format
V4LMultiBuffer
V4LCapturesPerFrame
Protocol
Method
Host
Port
SubPath
Path
SecondPath
Options
User
Pass
Width
Height
Colours
Palette
Orientation
Deinterlacing
Decoder
DecoderHWAccelName
DecoderHWAccelDevice
SaveJPEGs
VideoWriter
OutputCodec
Encoder
OutputContainer
EncoderParameters
RecordAudio
RTSPDescribe
Brightness
Contrast
Hue
Colour
EventPrefix
LabelFormat
LabelX
LabelY
LabelSize
ImageBufferCount
MaxImageBufferCount
WarmupCount
PreEventCount
PostEventCount
StreamReplayBuffer
AlarmFrameCount
SectionLength
SectionLengthWarn
MinSectionLength
EventStartMode
EventCloseMode
FrameSkip
MotionFrameSkip
AnalysisFPSLimit
AnalysisUpdateDelay
MaxFPS
AlarmMaxFPS
FPSReportInterval
RefBlendPerc
AlarmRefBlendPerc
Controllable
ControlId
ControlDevice
ControlAddress
AutoStopTimeout
TrackMotion
TrackDelay
ReturnLocation
ReturnDelay
ModectDuringPTZ
DefaultRate
DefaultScale
SignalCheckPoints
SignalCheckColour
WebColour
Exif
Sequence
ZoneCount
Refresh
DefaultCodec
Latitude
Longitude
RTSPServer
RTSPStreamName
SOAP_wsa_compl
Importance
MQTT_Enabled
MQTT_Subscriptions
It was worked fine with <=1.37.51
Please look into it. Thanks!
The text was updated successfully, but these errors were encountered:
Thanks for opening your first issue here! Just a reminder, this forum is for Bug Reports only. Be sure to follow the issue template!
Sorry, something went wrong.
a738f1b
No branches or pull requests
Hello!
Recently i just updated to 1.37.53.
Now i cant change anything in any monitor nor can add a new one. The error is this every time:
SQL-ERR '00000 ', statement was 'UPDATE
Monitors
SETId
=?,Name
=?,Deleted
=?,Notes
=?,ServerId
=?,StorageId
=?,ManufacturerId
=?,ModelId
=?,Type
=?,Capturing
=?,Analysing
=?,Recording
=?,RecordingSource
=?,AnalysisSource
=?,AnalysisImage
=?,Enabled
=?,Decoding
=?,RTSP2WebEnabled
=?,RTSP2WebType
=?,JanusEnabled
=?,JanusAudioEnabled
=?,Janus_Profile_Override
=?,Janus_Use_RTSP_Restream
=?,Janus_RTSP_User
=?,Janus_RTSP_Session_Timeout
=?,LinkedMonitors
=?,Triggers
=?,EventStartCommand
=?,EventEndCommand
=?,ONVIF_URL
=?,ONVIF_Username
=?,ONVIF_Password
=?,ONVIF_Options
=?,ONVIF_Alarm_Text
=?,ONVIF_Event_Listener
=?,use_Amcrest_API
=?,Device
=?,Channel
=?,Format
=?,V4LMultiBuffer
=?,V4LCapturesPerFrame
=?,Protocol
=?,Method
=?,Host
=?,Port
=?,SubPath
=?,Path
=?,SecondPath
=?,Options
=?,User
=?,Pass
=?,Width
=?,Height
=?,Colours
=?,Palette
=?,Orientation
=?,Deinterlacing
=?,Decoder
=?,DecoderHWAccelName
=?,DecoderHWAccelDevice
=?,SaveJPEGs
=?,VideoWriter
=?,OutputCodec
=?,Encoder
=?,OutputContainer
=?,EncoderParameters
=?,RecordAudio
=?,RTSPDescribe
=?,Brightness
=?,Contrast
=?,Hue
=?,Colour
=?,EventPrefix
=?,LabelFormat
=?,LabelX
=?,LabelY
=?,LabelSize
=?,ImageBufferCount
=?,MaxImageBufferCount
=?,WarmupCount
=?,PreEventCount
=?,PostEventCount
=?,StreamReplayBuffer
=?,AlarmFrameCount
=?,SectionLength
=?,SectionLengthWarn
=?,MinSectionLength
=?,EventStartMode
=?,EventCloseMode
=?,FrameSkip
=?,MotionFrameSkip
=?,AnalysisFPSLimit
=?,AnalysisUpdateDelay
=?,MaxFPS
=?,AlarmMaxFPS
=?,FPSReportInterval
=?,RefBlendPerc
=?,AlarmRefBlendPerc
=?,Controllable
=?,ControlId
=?,ControlDevice
=?,ControlAddress
=?,AutoStopTimeout
=?,TrackMotion
=?,TrackDelay
=?,ReturnLocation
=?,ReturnDelay
=?,ModectDuringPTZ
=?,DefaultRate
=?,DefaultScale
=?,SignalCheckPoints
=?,SignalCheckColour
=?,WebColour
=?,Exif
=?,Sequence
=?,ZoneCount
=?,Refresh
=?,DefaultCodec
=?,Latitude
=?,Longitude
=?,RTSPServer
=?,RTSPStreamName
=?,SOAP_wsa_compl
=?,Importance
=?,MQTT_Enabled
=?,MQTT_Subscriptions
=? WHERE Id=?'It was worked fine with <=1.37.51
Please look into it.
Thanks!
The text was updated successfully, but these errors were encountered: