Troubles to ruon zminit

[jarmo]

Distro mandriva cooker 2007 zm-1.2.2-3 mandriva's rpm
When running ./zminit I get:
DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder/Config.pm line 92.
Can't execute: Table 'zm.Config' doesn't exist at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder/Config.pm line 100
BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.8/ZoneMinder.pm line 33.
Compilation failed in require at /usr/lib/zm/bin/zmupdate.pl line 48.
BEGIN failed--compilation aborted at /usr/lib/zm/bin/zmupdate.pl line 48.
ERROR 1146 (42S02) at line 2: Table 'zm.Config' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'zm.Filters' doesn't exist

Any help to localize problem?

Jarmo

[SuperUser]

I have athe same error installing version 1.23.1.

[root@pentagon ZoneMinder-1.23.1]# /etc/init.d/zoneminder startDBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/lib/perl5/vendor_perl/5.8.8/ZoneMinder/Config.pm line 92.
Can't execute: Table 'zm.Config' doesn't exist at /usr/lib/perl5/vendor_perl/5.8.8/ZoneMinder/Config.pm line 100
BEGIN failed--compilation aborted at /usr/lib/perl5/vendor_perl/5.8.8/ZoneMinder/Config.pm line 100.
Compilation failed in require at /usr/lib/perl5/vendor_perl/5.8.8/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/lib/perl5/vendor_perl/5.8.8/ZoneMinder.pm line 33.
Compilation failed in require at /usr/bin/zmupdate.pl line 48.
BEGIN failed--compilation aborted at /usr/bin/zmupdate.pl line 48.

If somebody come up with a solution , please let me know.

[rideallday]

There's a bunch of backticks in the create script for some reason. Try this to fix it.

Code: Select all

 sed -i s/\`//g  /usr/src/ZoneMinder-1.24.2/db/zm_create.sql

then

Code: Select all

 mysql -u zmuser -p < /usr/src/ZoneMinder-1.24.2/db/zm_create.sql

I also had some issues with the DROP statements, so I just commented them out:

Code: Select all

sed -i s/\DROP/\-\-\ DROP/g  /usr/src/ZoneMinder-1.24.2/db/zm_create.sql