Page 1 of 1
Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Thu Jul 21, 2022 12:35 am
by lyallp
Language translation issue I suspect.
I found this text in two places.
Code: Select all
/usr/share/zoneminder/www/lang/es_la.php: 'ONVIF_Alarm_Txt' => 'Texto Alarma ONVIF', //added 18/07/2022
/usr/share/zoneminder/www/skins/classic/views/monitor.php: <td class="text-right pr-3"><?php echo translate('ONVIF_Alarm_Txt') ?></td>
Results in log messages of
Code: Select all
Jul 21 09:35:13 Lyalls-PC zmc_dvideo0[17314]: ERR [zmc_dvideo0] [Can't run query: Unknown column 'ONVIF_Alarm_Txt' in 'field list']
Jul 21 09:35:13 Lyalls-PC zmc_dvideo0[17314]: ERR [zmc_dvideo0] [Can't load local monitors: Unknown column 'ONVIF_Alarm_Txt' in 'field list']
Jul 21 09:35:13 Lyalls-PC zmc_dvideo0[17314]: ERR [zmc_dvideo0] [No monitors found]
Jul 21 09:35:13 Lyalls-PC zmdc[17224]: ERR ['zmc -d /dev/video0' exited abnormally, exit status 255]
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Thu Jul 21, 2022 7:41 am
by Aen5quai
I've this issue too
Centos7
Code: Select all
zoneminder-httpd-1.37.18-1.70.20220720gitg95530a4f7.el7.x86_64
zoneminder-common-1.37.18-1.70.20220720gitg95530a4f7.el7.x86_64
zoneminder-1.37.18-1.70.20220720gitg95530a4f7.el7.x86_64
[root@www db]# ls -al zm_update-1.37.1*
-rw-r--r--. 1 root root 449 май 18 20:03 zm_update-1.37.10.sql
-rw-r--r--. 1 root root 509 май 18 20:03 zm_update-1.37.11.sql
-rw-r--r--. 1 root root 2689 май 18 20:03 zm_update-1.37.12.sql
-rw-r--r--. 1 root root 561 май 18 20:03 zm_update-1.37.13.sql
-rw-r--r--. 1 root root 96 май 18 20:03 zm_update-1.37.14.sql
-rw-r--r--. 1 root root 457 май 18 20:03 zm_update-1.37.15.sql
-rw-r--r--. 1 root root 254 май 18 20:03 zm_update-1.37.16.sql
-rw-r--r--. 1 root root 418 июн 18 14:35 zm_update-1.37.17.sql
-rw-r--r--. 1 root root 482 июл 13 00:34 zm_update-1.37.18.sql
-rw-r--r--. 1 root root 58 май 18 20:03 zm_update-1.37.1.sql
[root@www db]# pwd
/usr/share/zoneminder/db
[root@www db]# grep -i ONVIF_Alarm_Txt *
[root@www db]#
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Thu Jul 21, 2022 8:42 am
by Magic919
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Thu Jul 21, 2022 10:01 am
by Aen5quai
Code: Select all
whereis monitors_dbupdate.sql; echo $?
monitors_dbupdate:0
Code: Select all
zmupdate.pl
Database already at version 1.37.18, update skipped.
Whereis monitors_dbupdate.sql located?
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Thu Jul 21, 2022 10:43 am
by lyallp
sort of expected zmupdate.pl to do it's job.
My Gentoo ebuild has not included this monitors_dbupdate.sql, which does not appear to conform to previous update naming standards, such as 'zm_update-1.37.9.sql'
I did, however, find this rogue sql in the git repository, arrived about 17 hours prior to this post.
Code: Select all
ALTER TABLE zm.Monitors ADD Onvif_Alarm_Txt varchar(30) DEFAULT 'MotionAlarm' NULL;
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Thu Jul 21, 2022 10:44 am
by Magic919
In the usual DB folder.
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Thu Jul 21, 2022 12:49 pm
by Aen5quai
Yes, that works. Thank you.
Code: Select all
wget https://raw.githubusercontent.com/ZoneMinder/zoneminder/master/db/monitors_dbupdate.sql
mysql -p zm < monitors_dbupdate.sql
systemctl restart zoneminder
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Thu Jul 21, 2022 12:58 pm
by Magic919
You're welcome. It's part of the joys of running the development version.
I'd suggest cloning the git repo and having a rummage through when the DB doesn't behave.
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Thu Jul 21, 2022 11:11 pm
by lyallp
My points are
1. DB changes should give a point version bump
2. DB Changes should be in the same form as previous DB changes
3. DB Changes should apply automatically with zmupdate.pl
Failure on any of these points will potentially lead to a broken release distribution, down the track, as the DB update is 'forgotten'
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Fri Jul 22, 2022 4:25 pm
by Magic919
Development version.
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Sat Jul 23, 2022 1:28 am
by lyallp
Which is the precursor to a release version.
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Sat Jul 23, 2022 5:44 am
by Magic919
No, it’s not at all. This is a different branch.
You’d be running the ‘proposed’ version if you want the one that’s just about to be the next release.
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Sat Jul 23, 2022 6:37 am
by lyallp
Ok, it's just that all previous updates of Zoneminder dealt with database updates in the manner described earlier.
If this is the way it is, then it's the way it is.
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Sat Jul 23, 2022 8:14 pm
by iconnor
Some fixes pushed. 1.37.19 should handle the update correctly. Of course I probably missed something or screwed something up. We will find out shortly.
Re: Broken v1.37.18 - ONVIF_Alarm_Txt
Posted: Mon Jul 25, 2022 2:41 am
by lyallp
Broke it again.
Was
now it's