Web interface won't load after update

[tyler_h]

Everything was done under root. I did the su command to start and pasted every line as root.
It seems that I might need the zoneminder config file. I dont know where it is, how to get a copy or where to even begin to source one out.

[tyler_h]

Upon trying to install an older 1.26.5 .deb file, I got the following error...


Stopping ZoneMinder: DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/share/perl5/ZoneMinder/Config.pm line 96.
Can't execute: Table 'zm.Config' doesn't exist at /usr/share/perl5/ZoneMinder/Config.pm line 104.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 104.
Compilation failed in require at /usr/share/perl5/ZoneMinder.pm line 33.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder.pm line 33.
Compilation failed in require at /usr/bin/zmpkg.pl line 37.
BEGIN failed--compilation aborted at /usr/bin/zmpkg.pl line 37.
Zoneminder already stopped

DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/share/perl5/ZoneMinder/Config.pm line 96.
Can't execute: Table 'zm.Config' doesn't exist at /usr/share/perl5/ZoneMinder/Config.pm line 104.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 104.
Compilation failed in require at /usr/bin/zmupdate.pl line 47.
BEGIN failed--compilation aborted at /usr/bin/zmupdate.pl line 47.
dpkg: error processing package zoneminder (--install):
subprocess installed post-installation script returned error exit status 255
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Errors were encountered while processing:
zoneminder



Any ideas ?

[PacoLM]

Hi,

Stopping ZoneMinder: DBD::mysql::st execute failed: Table 'zm.Config' doesn't exist at /usr/share/perl5/ZoneMinder/Config.pm line 96.

This could be an clue. It seems that you didn't get your ZM database upgraded or created. Check that the database exists by installing the phpmyadmin package, it's useful to check this kind of problems. Open the webpage to your phpmyadmin server and check if the database "zm" is there.

Try executing the command /usr/bin/zmupdate.pl

If it fails, open a phpmyadmin session and execute the query to create the database (the query to create the db is in the file /usr/share/zoneminder/zm_create.sql)

Hope it helps,

PacoLM

[tyler_h]

That is a big step in the right direction!

I was unable to get the command to work via terminal so I tried going into the PHPMYADMIN page. My ZM database is empty. Typing /usr/share/zoneminder/zm_create.sql into any query window gives me the error '#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/share/zoneminder/zm_create.sql' at line 1' Any suggestions?

[bbunge]

Your best bet is to start over with a fresh system. The Ubuntu procedure for 1.26.5 will work and the 1.28.1 for Ubuntu 14.04 is now OK.
Will have to wait for updates.

[tyler_h]

Thats sad

With regards to a fresh system, do you mean LAMP or a whole entire ubuntu install?

I hope you mean LAMP and I would like a list of steps please \
If you mean an entire system wipe, that seems like a bit extreme. I dont expect to hear suggestions like that unless I'm running windows. If you do mean an entire system wipe, maybe you guys could consider selling the software. I'd gladly buy it in order to support good coders to get smooth upgrades. I've upgraded three times now and each time was a disaster.