Search found 61 matches

by windracer
Mon Jun 30, 2014 2:44 am
Forum: ZoneMinder 1.27.x
Topic: Another eyeZM issue: SQL-ERR dbFetchOne no result
Replies: 7
Views: 2082

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($...
by windracer
Mon Jun 16, 2014 3:07 pm
Forum: ZoneMinder 1.27.x
Topic: Working Perfectly But With Error Messages
Replies: 2
Views: 784

Re: Working Perfectly But With Error Messages

Maybe a permissions error on /tmp/zm?
by windracer
Mon Jun 16, 2014 3:04 pm
Forum: ZoneMinder 1.27.x
Topic: Compile with libvlc issues
Replies: 1
Views: 781

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.
by windracer
Thu Jun 12, 2014 5:14 pm
Forum: ZoneMinder 1.27.x
Topic: Another eyeZM issue: SQL-ERR dbFetchOne no result
Replies: 7
Views: 2082

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 variab...
by windracer
Thu Jun 12, 2014 3:23 pm
Forum: ZoneMinder 1.27.x
Topic: Another eyeZM issue: SQL-ERR dbFetchOne no result
Replies: 7
Views: 2082

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...
by windracer
Thu Jun 12, 2014 3:12 pm
Forum: ZoneMinder 1.27.x
Topic: Another eyeZM issue: SQL-ERR dbFetchOne no result
Replies: 7
Views: 2082

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 t...
by windracer
Wed Jun 11, 2014 8:37 pm
Forum: ZoneMinder 1.27.x
Topic: Another eyeZM issue: SQL-ERR dbFetchOne no result
Replies: 7
Views: 2082

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 ...
by windracer
Sun Jun 08, 2014 2:26 am
Forum: ZoneMinder 1.27.x
Topic: TRENDnet TV-IP311PI with ZM 1.27
Replies: 3
Views: 2179

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. :wink:
by windracer
Sat Jun 07, 2014 12:54 pm
Forum: ZoneMinder 1.27.x
Topic: TRENDnet TV-IP311PI with ZM 1.27
Replies: 3
Views: 2179

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 sendin...
by windracer
Sat Jun 07, 2014 2:27 am
Forum: ZoneMinder 1.27.x
Topic: TRENDnet TV-IP311PI with ZM 1.27
Replies: 3
Views: 2179

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...
by windracer
Wed Apr 09, 2014 11:42 pm
Forum: ZoneMinder 1.27.x
Topic: New ZM Install on Ubuntu 13:10?
Replies: 4
Views: 1806

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.
by windracer
Wed Apr 09, 2014 11:41 pm
Forum: ZoneMinder 1.27.x
Topic: Default Skin
Replies: 7
Views: 3714

Re: Default Skin

Biggus wrote:But do I need to specify https://x.x.x.x/zm/index.php?skin=flat everytime I login?
Yeah, that's what I've been doing (just updated my Zoneminder bookmark to include the skin parameter).
by windracer
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: 5460

Re: eyezm on iPhone broken after Zoneminder upgrade to 1.27

McFuzz wrote:So here's an interesting observation - it looks like at times, attempting to log into zoneminder via eyeZM fails
I'm seeing this occasionally as well. At least a refresh seems to fix it.
by windracer
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: 5460

Re: eyezm on iPhone broken after Zoneminder upgrade to 1.27

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?
See this post for details. You need to modify the skin.php file for the XML skin.
by windracer
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: 5460

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 decid...