Bug 1.22.3

[drubort]

Hi

Version: 1.22.3
Ubuntu Edgy
PV-149 capture card

Bug #1 (Minor)

cause
Add New Monitor -> Presets -> select any presets -> Save
results in

Unknown column 'DefaultView' in 'field list'

in New monitor window.

workaround/fix
Sorry I don't have a fix for this, but can still manually enter the details of the monitor.

Bug #2 (might not be a bug)
I was getting errors when trying to construct video of events.

workaround/fix
I resolved it with the follow hack:
on line 323 of zmvideo.pl I removed the "&"

so it now looks like

Code: Select all

 my $command = ZM_PATH_FFMPEG." -y -r $frame_rate ".ZM_FFMPEG_INPUT_OPTIONS." -i %0".ZM_EVENT_IMAGE_DIGITS."d-capture.jpg -s $video_size ".ZM_FFMPEG_OUTPUT_OPTIONS." '$video_file' > /tmp/ffmpeg.log";

This software is amazing. Thanks to all who are developing it.

[zoneminder]

Thanks for this. Did you do an upgrade or a fresh 1.22.3 install. If you did the upgrade, did you remember to run zmupdate.pl? That should have added the DefaultView column.

On your second bug, you said you were getting errors. Can you post what they were?

[drubort]

Hi

I did an upgrade from 1.22.2 but the zmupdate.pl didnt have an entry for 1.22.2 and was giving me trouble (sorry I didnt keep logs ) so then I did a clean install of 1.22.3

I didnt drop the zm tables in mysql though... just did

Code: Select all

sudo mysql < db/zm_create.sql

then

Code: Select all

make install

as regards (possible) Bug #2 the errors from zmvideo.log are

Code: Select all

11/23/06 21:52:29.582154 zmvideo[12846].INF [Creating video file Event-34-r1-s1.mpg for event 34]
11/23/06 21:52:29.583174 zmvideo[12846].INF [/usr/bin/ffmpeg -y -r 5.00  -i %03d-capture.jpg -s  320x240 -r 25 'Event-34-r1-s1.mpg' >& ffmpeg.log]
11/23/06 21:52:29.585536 zmvideo[12846].ERR [Unable to generate video, check /var/www/zm/events/1/34/ffmpeg.log for details]
11/23/06 22:06:52.391616 zmvideo[15390].INF [Creating video file Event-8-r1-s1.mpg for event 8]
11/23/06 22:06:52.392560 zmvideo[15390].INF [/usr/bin/ffmpeg -y -r 2.51  -i %03d-capture.jpg -s  320x240 -r 25 'Event-8-r1-s1.mpg' >& ffmpeg.log]
11/23/06 22:06:52.395037 zmvideo[15390].ERR [Unable to generate video, check /var/www/zm/events/1/8/ffmpeg.log for details]
11/23/06 23:17:23.775360 zmvideo[12310].INF [Creating video file New_Event-r1-s1.mpg for event 1]
11/23/06 23:17:23.778103 zmvideo[12310].ERR [Unable to generate video, check /var/www/zm/events/1/1/ffmpeg.log for details]
11/23/06 23:22:04.195609 zmvideo[12967].INF [Creating video file Event-1-r1-s1.mpg for event 1]
11/23/06 23:22:04.198395 zmvideo[12967].ERR [Unable to generate video, check /var/www/zm/events/1/1/ffmpeg.log for details]
11/23/06 23:24:00.362638 zmvideo[13240].INF [Creating video file Event-1-r1-s1.mpg for event 1]
11/23/06 23:24:00.365405 zmvideo[13240].ERR [Unable to generate video, check /var/www/zm/events/1/1/ffmpeg.log for details]
11/23/06 23:25:12.710879 zmvideo[13416].INF [Creating video file Event-1-r1-s1.mpg for event 1]
11/23/06 23:25:12.713734 zmvideo[13416].ERR [Unable to generate video, check /var/www/zm/events/1/1/ffmpeg.log for details]
11/23/06 23:26:20.573940 zmvideo[13560].INF [Creating video file Event-1-r1-s1.mpg for event 1]
11/23/06 23:26:20.576888 zmvideo[13560].ERR [Unable to generate video, check /var/www/zm/events/1/1/ffmpeg.log for details]
11/23/06 23:29:30.173188 zmvideo[13989].INF [Creating video file Event-1-r1-s1.mpg for event 1]
11/23/06 23:29:30.176086 zmvideo[13989].ERR [Unable to generate video, check /var/www/zm/events/1/1/ffmpeg.log for details]

The first two are from Ver 1.22.2 and the rest are from 1.22.3 before I removed the "&"

[zoneminder]

Ah yes. The check for v 1.22.2 was missing from zmupdate.pl, now fixed and uploaded.

What was in the ffmpeg.log files referenced in your logs?

[drubort]

Cool, thanks.


The file didnt exist. Works perfectly with the "&" removed though.

[kamand]

Ah yes. The check for v 1.22.2 was missing from zmupdate.pl, now fixed and uploaded.

Hello.

Code: Select all

	if ( $cascade || $version eq "1.22.2" )
	{
		# Patch the database
		patchDB( $dbh, "1.22.1" );
		$cascade = !undef;
	}

I think this is a typo (need to be patchDB( $dbh, "1.22.2" ); ) ?
Regards
Andrew

[zoneminder]

Aaargh! That'll teach to do this kind of thing last thing at night.

Thanks

[bonnerchen]

cause
Add New Monitor -> Presets -> select any presets -> Save
results in

Unknown column 'DefaultView' in 'field list'

in New monitor window.

Hi!

I have currently the same bug with an fresh installation of 1.22.3. I'm not the expert for mysql etc. is there any workaround available?

[cordel]

Yeah, I put the patch up and I think Phil added it to the wiki.
Don't use the above example as it's not correct.

[W.]

Hi!

In fact there is more to monitors and presets in v1.22.3. Another small bug, that prevents opening presets window in ie7 (did not try earlier versions)
FF 2 is more forgiving in this case and still opens the presets window.

diff follows.

Code: Select all

--- web/zm_html_view_monitor.php
+++ web/zm_html_view_monitor.php
@@ -353,7 +353,7 @@
 <table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
 <td align="left" class="head"><?= $zmSlangMonitor ?> - <?= $monitor['Name'] ?></td>
-<td align="right" valign="bottom" class="text"><?= makeLink( "javascript: newWindow( '$PHP_SELF?view=monitorpreset&mid=$mid', 'zmMonitorPreset<?= $mid ?>', ".$jws['monitorpreset']['w'].", ".$jws['monitorpreset']['h']." );", $zmSlangPresets, canEdit( 'Monitors' ) ) ?></td>
+<td align="right" valign="bottom" class="text"><?= makeLink( "javascript:newWindow( '$PHP_SELF?view=monitorpreset&mid=$mid', 'zmMonitorPreset', ".$jws['monitorpreset']['w'].", ".$jws['monitorpreset']['h']." );", $zmSlangPresets, canEdit( 'Monitors' ) ) ?></td>
 </tr>
 <tr>
 <td>&nbsp;</td>