Problem installing ZM 1.25 on Ubuntu 12.04, ERROR 1050

[tetsuo_shima]

I have been attempting to install Zoneminder 1.25 in Ubuntu 12.04, following the 10.04 Desktop instructions at http://www.zoneminder.com/wiki/index.ph ... x)_Desktop. Whenever I entered instruction #6:

Code: Select all

sudo mysql -u root -p < /usr/share/zoneminder/db/zm_create.sql

and enter a correct password, the system responds:

Code: Select all

ERROR 1050 (42S01) at line 265: Table 'Logs' already exists

I got this error in the Desktop, Server, and Mini(Netboot) editions.


I opened /usr/share/zoneminder/db/zm_create.sql in a text editor to look at line 265. I found that while every other table is preceded by something like:

Code: Select all

DROP TABLE IF EXISTS `tablename`;
CREATE TABLE `tablename` (

the 'Logs' table is only preceded by:

Code: Select all

CREATE TABLE `Logs`( 

I edited zm_create.sql, adding

Code: Select all

DROP TABLE IF EXISTS `Logs`;

before

Code: Select all

CREATE TABLE `Logs`( 

at line 265. I reentered

Code: Select all

sudo mysql -u root -p < /usr/share/zoneminder/db/zm_create.sql

in the terminal and now no errors are returned.


Hopefully the package can be fixed at some point. If not, here's the solution should you see a similar error.