Page 2 of 2

Error upgrading 1.22.2 - 1.22.3

Posted: Wed Dec 20, 2006 5:05 pm
by ManRoaming
OK I read the MYSQL manual and fixed the permission. Here is the latest error when runing zmupdate.pl.

Upgrading database to version 1.22.3
ERROR 1060 (42S21) at line 8: Duplicate column name 'Background'
Output:
Command 'mysql -hlocalhost -uzm -pzm zm < /usr/local/ZoneMinder-1.22.3/db/zm_update-1.22.2.sql' exited with status: 1

ZM runs by the way at this point.

Posted: Wed Dec 20, 2006 9:06 pm
by cordel
This suggests that the database has been upgraded
ERROR 1060 (42S21) at line 8: Duplicate column name 'Background'
I would suggest running zmupdate.pl -f as well.

Regards,
Corey

Fixed

Posted: Thu Dec 21, 2006 9:53 pm
by ManRoaming
OK, seems to run fine now. I haven't checked logs yet but functionally it looks good. Thanks for your help!