Search found 61 matches
- Mon Jun 30, 2014 2:44 am
- Forum: ZoneMinder 1.27.x
- Topic: Another eyeZM issue: SQL-ERR dbFetchOne no result
- Replies: 7
- Views: 5451
Re: Another eyeZM issue: SQL-ERR dbFetchOne no result
What version of ZM are you using? I'm running 1.27.1 and see escapeSql calls in the following places for the xml skin: 22:41:14 /usr/local/zoneminder/skins/xml:$ grep -R escapeSql * includes/functions.php:function escapeSql($str, $maxlen = 0) { includes/functions.php: //$res = dbFetchOne(escapeSql ...
- Mon Jun 16, 2014 3:07 pm
- Forum: ZoneMinder 1.27.x
- Topic: Working Perfectly But With Error Messages
- Replies: 2
- Views: 2067
Re: Working Perfectly But With Error Messages
Maybe a permissions error on /tmp/zm?
- Mon Jun 16, 2014 3:04 pm
- Forum: ZoneMinder 1.27.x
- Topic: Compile with libvlc issues
- Replies: 1
- Views: 1974
Re: Compile with libvlc issues
Have you tried using the new cmake instructions instead? I just did this last week (recompiled for vlc support) and had no issues. Details are in the INSTALL file.
- Thu Jun 12, 2014 5:14 pm
- Forum: ZoneMinder 1.27.x
- Topic: Another eyeZM issue: SQL-ERR dbFetchOne no result
- Replies: 7
- Views: 5451
Re: Another eyeZM issue: SQL-ERR dbFetchOne no result
Ok, got it! It's specific to the XML skin (of course). I tracked the problem down to the SQL queries in the isMonitor and getMonitorDims functions in includes/functions.php for the skin, specifically, the results of escapeSql. It looks like the escapeSql function is clearing the entire $query ...
- Thu Jun 12, 2014 3:23 pm
- Forum: ZoneMinder 1.27.x
- Topic: Another eyeZM issue: SQL-ERR dbFetchOne no result
- Replies: 7
- Views: 5451
Re: Another eyeZM issue: SQL-ERR dbFetchOne no result
Found where the error is coming from, line 124 of database.php: function dbFetchOne( $sql, $col=false, $params=NULL ) { $result = dbQuery( $sql, $params ); if ( ! $result ) { Fatal( "SQL-ERR dbFetchOne no result, statement was '".$sql."'" . ( $params ? 'params: ' . join(',',$params) : '' ) ); return ...
- Thu Jun 12, 2014 3:12 pm
- Forum: ZoneMinder 1.27.x
- Topic: Another eyeZM issue: SQL-ERR dbFetchOne no result
- Replies: 7
- Views: 5451
Re: Another eyeZM issue: SQL-ERR dbFetchOne no result
Looking at eyezm.log, this is the URL that is causing the error: zm/?skin=xml&view=actions&action=feed&monitor=3&protoVer=2&scale=100&fps=3&width=160&height=120&vcodec=mjpeg If I put that into my browser I get the same error: SQL-ERR dbFetchOne no result, statement was '' Trying to figure out what ...
- Wed Jun 11, 2014 8:37 pm
- Forum: ZoneMinder 1.27.x
- Topic: Another eyeZM issue: SQL-ERR dbFetchOne no result
- Replies: 7
- Views: 5451
Another eyeZM issue: SQL-ERR dbFetchOne no result
I just downloaded and re-compiled 1.27.1 from source on my Ubuntu 14.04 box to get libvlc support. Everything went fine except zmupdate.pl tried to upgrade 1.27.0 to 1.27 and ran into a SQL error (I had to run it with the --version=1.27.1 flag). Despite that, everything seemed to be working fine. I ...
- Sun Jun 08, 2014 2:26 am
- Forum: ZoneMinder 1.27.x
- Topic: TRENDnet TV-IP311PI with ZM 1.27
- Replies: 3
- Views: 4448
Re: TRENDnet TV-IP311PI with ZM 1.27
The default is 15fps but I can change to just about anything on the camera side. My Linux "server" is an old Aspire Revo 3610 with a dial-core 1.6GHz Atom 330 CPU ... so a little less grunt than yours.
- Sat Jun 07, 2014 12:54 pm
- Forum: ZoneMinder 1.27.x
- Topic: TRENDnet TV-IP311PI with ZM 1.27
- Replies: 3
- Views: 4448
Re: TRENDnet TV-IP311PI with ZM 1.27
After some more late-night tinkering, I was able to reduce the CPU usage. It turns out there are two RTSP streams available from the camera and the first string I found (Streaming/Channels/1) was the H.264 (HD) one. I am now using Streaming/Channels/2 which is the MJPEG stream so now I'm only ...
- Sat Jun 07, 2014 2:27 am
- Forum: ZoneMinder 1.27.x
- Topic: TRENDnet TV-IP311PI with ZM 1.27
- Replies: 3
- Views: 4448
TRENDnet TV-IP311PI with ZM 1.27
I just purchased a TRENDnet TV-IP311PI 3MP dome outdoor camera to replace an old Foscam FI8904W. It's a really nice piece of equipment, and PoE so I was able to get rid of an extension cable in the attic. :shock: I was able to get the new camera working with ZM by using ffmpeg as the source and rtsp ...
- Wed Apr 09, 2014 11:42 pm
- Forum: ZoneMinder 1.27.x
- Topic: New ZM Install on Ubuntu 13:10?
- Replies: 4
- Views: 4031
Re: New ZM Install on Ubuntu 13:10?
I'm also running on 13.10 but have had ZM installed for a while so have just been doing upgrades and not a clean install.
- Wed Apr 09, 2014 11:41 pm
- Forum: ZoneMinder 1.27.x
- Topic: Default Skin
- Replies: 7
- Views: 7416
Re: Default Skin
Yeah, that's what I've been doing (just updated my Zoneminder bookmark to include the skin parameter).Biggus wrote:But do I need to specify https://x.x.x.x/zm/index.php?skin=flat everytime I login?
- Thu Mar 27, 2014 7:51 pm
- Forum: ZoneMinder 1.27.x
- Topic: eyezm on iPhone broken after Zoneminder upgrade to 1.27
- Replies: 23
- Views: 12816
Re: eyezm on iPhone broken after Zoneminder upgrade to 1.27
I'm seeing this occasionally as well. At least a refresh seems to fix it.McFuzz wrote:So here's an interesting observation - it looks like at times, attempting to log into zoneminder via eyeZM fails
- Thu Mar 27, 2014 7:50 pm
- Forum: ZoneMinder 1.27.x
- Topic: eyezm on iPhone broken after Zoneminder upgrade to 1.27
- Replies: 23
- Views: 12816
Re: eyezm on iPhone broken after Zoneminder upgrade to 1.27
See this post for details. You need to modify the skin.php file for the XML skin.Biggus wrote:I can now see my events. However I need to apply the skin fix, what file and what do I need to change?
- Tue Mar 25, 2014 12:31 pm
- Forum: ZoneMinder 1.27.x
- Topic: eyezm on iPhone broken after Zoneminder upgrade to 1.27
- Replies: 23
- Views: 12816
Re: eyezm on iPhone broken after Zoneminder upgrade to 1.27
I really wish I could use eyezm but its not available in the app store to download. I can still see both in the iTunes store: eyeZM: https://itunes.apple.com/us/app/eyezm/id400246213?mt=8 eyeZM HD: https://itunes.apple.com/us/app/eyezm-hd/id430792499?mt=8 Of course, like you said, you need to ...