Problems upgrading to 1.22.3

Support and queries relating to all previous versions of ZoneMinder
ManRoaming
Posts: 27
Joined: Fri Sep 08, 2006 7:15 pm

Error upgrading 1.22.2 - 1.22.3

Post 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.
User avatar
cordel
Posts: 5210
Joined: Fri Mar 05, 2004 4:47 pm
Location: /USA/Washington/Seattle

Post 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
ManRoaming
Posts: 27
Joined: Fri Sep 08, 2006 7:15 pm

Fixed

Post by ManRoaming »

OK, seems to run fine now. I haven't checked logs yet but functionally it looks good. Thanks for your help!
Locked