ZM 1.22.3 Presets

[dgellis]

Hello,

I've built ZM 1.22.3 and when I add a monitor the presets come up with an known field error.

Is there a work around for this?

Thanks.

Darren

[zoneminder]

I think this is probably because you downloaded an early 1.22.3 version which did not update the DB correctly. Either redownload and rerun zmupdate.pl or just apply the zm_update-1.22.2.sql file directly. I would recommend the first solution as a couple of other issues were also fixed.

[dgellis]

Thanks for the update. I will re-download and manage from there.

If you had bumped the version (1.22.31) or similar, I would have looked at the change log and re-downloaded without the loss of 48 hours and a forum post.

Darren Ellis

[jameswilson]

your welcome

[dgellis]

Hi,

I downloaded from the ZM web site and re-installed, dropping my old database and creating a new one.

I still get the:

'Unknown column 'DefaultView' in 'field list'

error when I try to add a preset. The problem persists after running zmupdate.pl -f also.

Please advise.

Thank you.

Darren

[zoneminder]

Can you grep for DefaultView in the zm_create.sql file you used, and also go into mysql and type 'show table Monitors;' and post the results.

[cordel]

Here is the patch for that bug.

Code: Select all

diff -U 3 -H -d -r -N -- ../ZoneMinder-1.22.3-Orig/web/zm_html_view_monitor.php web/zm_html_view_monitor.php
--- ../ZoneMinder-1.22.3-Orig/web/zm_html_view_monitor.php	2006-11-06 05:56:43.000000000 -0800
+++ web/zm_html_view_monitor.php	2006-12-13 17:47:35.308691325 -0800
@@ -113,7 +113,7 @@
 }
 if ( !empty($preset) )
 {
-	$result = mysql_query( "select Type, Device, Channel, Format, Host, Port, Path, Width, Height, Palette, MaxFPS, Controllable, ControlId, ControlDevice, ControlAddress, DefaultView, DefaultRate, DefaultScale from MonitorPresets where Id = '$preset'" );
+	$result = mysql_query( "select Type, Device, Channel, Format, Host, Port, Path, Width, Height, Palette, MaxFPS, Controllable, ControlId, ControlDevice, ControlAddress, DefaultRate, DefaultScale from MonitorPresets where Id = '$preset'" );
 	if ( !$result )
 		die( mysql_error() );
 	$preset = mysql_fetch_assoc( $result );

Regards,
Corey