Page 1 of 1
ZM 1.22.3 Presets
Posted: Sun Dec 03, 2006 2:29 pm
by 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
Posted: Sun Dec 03, 2006 5:49 pm
by 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.
Posted: Mon Dec 04, 2006 6:43 pm
by 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
Posted: Mon Dec 04, 2006 11:27 pm
by jameswilson
your welcome
Posted: Tue Dec 05, 2006 12:00 am
by 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
Posted: Wed Dec 06, 2006 12:23 am
by 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.
Posted: Thu Dec 14, 2006 8:58 am
by 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