zmNinja: Error retrieving detailed frame API

Discussion topics related to mobile applications and ZoneMinder Event Server (including machine learning)
Post Reply
DumDum
Posts: 3
Joined: Fri Jul 13, 2018 7:29 pm

zmNinja: Error retrieving detailed frame API

Post by DumDum »

Recent issue encountered with zmNinja on Windows and Android accessing zoneminder-h264 on FreeBSD

zmNinja is unable to playback event as I receive "could not retrieve frame details"

getVersion.json:

Code: Select all

{"version":"1.30.2","apiversion":"1.0"}
monitors.json:

Code: Select all

{"monitors":[{"Monitor":{"Id":"2","Name":"Front Door","ServerId":"0","Type":"Ffmpeg","Function":"Modect","Enabled":"1","LinkedMonitors":"2","Triggers":"","Device":"\/dev\/video0","Channel":"0","Format":"255","V4LMultiBuffer":false,"V4LCapturesPerFrame":"1","Protocol":"rtsp","Method":"rtpRtsp","Host":"192.168.1.101","Port":"554","SubPath":"","Path":"rtsp:\/\/192.168.1.151:554\/cam\/realmonitor?channel=1&subtype=0&unicast=true&proto=Onvif","Options":"","User":"","Pass":"","Width":"1920","Height":"1080","Colours":"4","Palette":"0","Orientation":"0","Deinterlacing":"0","SaveJPEGs":"3","VideoWriter":"2","EncoderParameters":"","RecordAudio":"0","RTSPDescribe":false,"Brightness":"-1","Contrast":"-1","Hue":"-1","Colour":"-1","EventPrefix":"Event-","LabelFormat":"%m\/%d\/%y %H:%M:%S","LabelX":"0","LabelY":"0","LabelSize":"2","ImageBufferCount":"400","WarmupCount":"35","PreEventCount":"400","PostEventCount":"260","StreamReplayBuffer":"1000","AlarmFrameCount":"4","SectionLength":"600","FrameSkip":"0","MotionFrameSkip":"0","AnalysisFPS":"0.00","AnalysisUpdateDelay":"0","MaxFPS":"0.00","AlarmMaxFPS":"0.00","FPSReportInterval":"1000","RefBlendPerc":"6","AlarmRefBlendPerc":"3","Controllable":"0","ControlId":"0","ControlDevice":null,"ControlAddress":null,"AutoStopTimeout":null,"TrackMotion":"0","TrackDelay":"0","ReturnLocation":"-1","ReturnDelay":"0","DefaultView":"Events","DefaultRate":"100","DefaultScale":"25","SignalCheckColour":"#0000c0","WebColour":"red","Exif":true,"Sequence":"1"}}]} 

Code: Select all

zmNinja version:1.3.008D (desktop)
ZoneMinder version:1.30.2

Jul 13, 2018 02:05:30 PM INFO >>>Starting checkAllEvents interval...
Jul 13, 2018 02:05:29 PM INFO Error retrieving detailed frame API {"data":{"success":false,"data":{"name":"An Internal Error Has Occurred.","message":"An Internal Error Has Occurred.","url":"/zoneminder/api/events/51115.json?p=events%2F51115.json","exception":{"class":"PDOException","code":"42000","message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fileExists' at line 1"}}},"status":500,"config":{"method":"GET","transformRequest":[null],"transformResponse":[null],"url":"https://my.server/zoneminder/api/events/51115.json","headers":{"Accept":"application/json, text/plain, */*"}},"statusText":"Internal Server Error"}
Jul 13, 2018 02:05:28 PM INFO *** Constructed API for detailed events: https://my.server/zoneminder/api/events/51115.json
Jul 13, 2018 02:05:28 PM INFO Using stream mode single
Jul 13, 2018 02:05:28 PM INFO ZM_EVENT_IMAGE_DIGITS is already configured for 5
Jul 13, 2018 02:05:21 PM INFO ***  PROGRESS WAS NOT CALLED
Jul 13, 2018 02:05:21 PM INFO Returning pre-loaded list of 1 monitors
Jul 13, 2018 02:05:14 PM INFO MonitorCtrl:Stopping network pull...
Jul 13, 2018 02:05:09 PM INFO configurePTZ 2 is not PTZ controllable
Jul 13, 2018 02:05:09 PM INFO Using stream mode single
Jul 13, 2018 02:05:09 PM INFO Monitor Orientation is: undefined
Jul 13, 2018 02:05:04 PM INFO Returning pre-loaded list of 1 monitors
Jul 13, 2018 01:59:28 PM INFO Stream authentication construction: &user=Zorak<password removed>
Jul 13, 2018 01:59:28 PM INFO DataModel: Found simple stream auth mode (user=)
Jul 13, 2018 01:59:28 PM INFO DataModel: Did not find a stream auth key, looking for user=
Jul 13, 2018 01:59:28 PM INFO ZM has recaptcha disabled - good
Jul 13, 2018 01:59:28 PM INFO zmAutologin successfully logged into Zoneminder
Jul 13, 2018 01:59:28 PM INFO Checking if reCaptcha is enabled in ZM...
Jul 13, 2018 01:59:28 PM INFO zmAutologin called
Jul 13, 2018 01:29:30 PM INFO ***  PROGRESS WAS NOT CALLED
Jul 13, 2018 01:29:29 PM INFO multi server list loaded{"servers":[]}
Jul 13, 2018 01:29:29 PM INFO DataModel: Found simple stream auth mode (user=)
Jul 13, 2018 01:29:29 PM INFO DataModel: Did not find a stream auth key, looking for user=
Jul 13, 2018 01:29:29 PM INFO Monitor load was successful, loaded 1 monitors
Jul 13, 2018 01:29:29 PM INFO Now that we have monitors, lets get AuthKey...
Jul 13, 2018 01:29:29 PM INFO ZM_MIN_STREAMING_PORT not supported
Jul 13, 2018 01:29:29 PM INFO ZM_EVENT_IMAGE_DIGITS is 5
Jul 13, 2018 01:29:29 PM INFO Checking value of ZM_MIN_STREAMING_PORT for the first time
Jul 13, 2018 01:29:29 PM INFO getMonitors:Loading all monitors
Jul 13, 2018 01:29:29 PM INFO No Event Server present. Not initializing
Jul 13, 2018 01:29:29 PM INFO First invocation of TimeZone, asking server
Jul 13, 2018 01:29:29 PM INFO Got API version: 1.30.2
Jul 13, 2018 01:29:29 PM INFO Stream authentication construction: undefined
Jul 13, 2018 01:29:29 PM INFO Deferring auth key, as monitorId unknown
Jul 13, 2018 01:29:29 PM INFO zmAutologin successfully logged into Zoneminder
Jul 13, 2018 01:29:29 PM INFO ZM has recaptcha disabled - good
Jul 13, 2018 01:29:28 PM INFO Checking if reCaptcha is enabled in ZM...
Jul 13, 2018 01:29:28 PM INFO zmAutologin called
Jul 13, 2018 01:29:28 PM INFO https://my.server/zoneminder=>Logging out of any existing ZM sessions...
Jul 13, 2018 01:29:28 PM INFO Cancelling zmAutologin timer
Jul 13, 2018 01:29:28 PM INFO not checking for touchID
Jul 13, 2018 01:29:28 PM INFO User credentials are provided
Jul 13, 2018 01:29:27 PM INFO Entering Portal Main
Jul 13, 2018 01:29:27 PM INFO Inside init-complete in app.js: All init over, going to portal login
Jul 13, 2018 01:29:27 PM INFO DataModel init retrieved store loginData
Jul 13, 2018 01:29:27 PM INFO SlowDelay is: false
Jul 13, 2018 01:29:27 PM INFO Setting DataModel init bandwidth to: highbw
Jul 13, 2018 01:29:27 PM INFO user profile encrypted, decoding...
Jul 13, 2018 01:29:27 PM INFO Setting up pause and resume handler AFTER language is loaded...
Jul 13, 2018 01:29:27 PM INFO Setting up POST LOGIN timer
Jul 13, 2018 01:29:27 PM INFO Checking for news updates
Jul 13, 2018 01:29:27 PM INFO Checking for new version updates...
Jul 13, 2018 01:29:27 PM INFO ZMData init: checking for stored variables & setting up log file
Jul 13, 2018 01:29:27 PM INFO Language file loaded, continuing with rest
Jul 13, 2018 01:29:27 PM DEBUG last state=app.moment param=undefined
Jul 13, 2018 01:29:27 PM DEBUG isFirstUse returned: false
Jul 13, 2018 01:29:27 PM INFO >>>>Language to be used:en
Jul 13, 2018 01:29:27 PM INFO Device Language is:en
Jul 13, 2018 01:29:27 PM INFO No language set, switching to en
Jul 13, 2018 01:29:27 PM INFO Retrieving language before init is called...
Jul 13, 2018 01:29:27 PM INFO Enabling native transitions...
Jul 13, 2018 01:29:27 PM INFO >>>>No data to import....
Jul 13, 2018 01:29:27 PM INFO localforage driver for storage:asyncStorage
Jul 13, 2018 01:29:27 PM DEBUG configureStorageDB:test get/set worked, this driver is ok...
Jul 13, 2018 01:29:27 PM DEBUG configureStorageDB:Making sure this storage driver works...
Jul 13, 2018 01:29:27 PM INFO configureStorageDB:localforage driver for storage:asyncStorage
Jul 13, 2018 01:29:27 PM DEBUG configureStorageDB: trying order:["asyncStorage","localStorageWrapper"]
Jul 13, 2018 01:29:27 PM DEBUG Inside configureStorageDB
Jul 13, 2018 01:29:27 PM INFO You are running on desktop
Jul 13, 2018 01:29:27 PM INFO Device is ready

User avatar
asker
Posts: 1553
Joined: Sun Mar 01, 2015 12:12 pm

Re: zmNinja: Error retrieving detailed frame API

Post by asker »

Is 1.30.2 h-264 an official release? I see 1.30.4 (which does not do video, if I remember correctly) and now the master branch which is ZM 1.31.xx which does do video.

From your message, it looks like the server tried to access MySQL and errored out.

Notes:
a) You said "recent issue" -> what changed?
b) I'd recommend you update to a either the GA (1.30.4) or if you are on video, upgrade to 1.31.xx (which is not GA)
I no longer work on zmNinja, zmeventnotification, pyzm or mlapi. I may respond on occasion based on my available time/interest.

Please read before posting:
How to set up logging properly
How to troubleshoot and report - ES
How to troubleshoot and report - zmNinja
ES docs
zmNinja docs
DumDum
Posts: 3
Joined: Fri Jul 13, 2018 7:29 pm

Re: zmNinja: Error retrieving detailed frame API

Post by DumDum »

Holy fast reply, Batman

I have been using "zoneminder-h264-1.30.20170222_4", probably since early 2017 ;)
"Recent" meaning this has worked in the past and the only notable changes would include various package upgrades; mysql, android/windows zmninja, etc.

I could spin up another jail and try out zm 1.31.xx

Gracias amigo
User avatar
asker
Posts: 1553
Joined: Sun Mar 01, 2015 12:12 pm

Re: zmNinja: Error retrieving detailed frame API

Post by asker »

Image
I no longer work on zmNinja, zmeventnotification, pyzm or mlapi. I may respond on occasion based on my available time/interest.

Please read before posting:
How to set up logging properly
How to troubleshoot and report - ES
How to troubleshoot and report - zmNinja
ES docs
zmNinja docs
Post Reply