Upgrade Problem from 1.22.1 -> 1.22.3

[postfux]

When i did a zmupdate.pl -version=1.22.1 i got:

Upgrading database to version 1.22.3

Database successfully upgraded from version 1.22.1.
ERROR 1064 at line 36: 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 'DEFAULT CHARSET=latin1' at line 6
Output:
Command 'mysql -hlocalhost -uroot -ptrito120404 zm < /install/ZoneMinder-1.22.3/db/zm_update-1.22.2.sql' exited with status: 1

and when i try then zmpk.pl start
i have in the logfile:12/13/06 22:00:52.597968 zmpkg[10977].ERR [Unable to run "su www-data --shell=/bin/sh --command='/usr/local/bin/zmfix'", output is ""]

Can somebody help me?

[seb3s]

Hi I had this as well.
It was due to the version of MySQL (Phil has probably upgraded his SQL in the meantime).

I just changed the "ENGINE=MyISAM" by "TYPE=MyISAM" in zm_update-1.22.2.sql and it went ok after.

You may need to remove the beginning of the script coz it won't run twice (coz of alter table statement).

Cheers,

Sébastien.

[postfux]

Thx for the help
I needet also to remove the DEFAUL CHARSET=latin1 statement cause i got also an error.

Ok now the DB is updated, but i still cant start the Zoneminder
I turned debug on and got in the log:

12/14/06 19:07:18.833375 zmpkg[8072].INF [Command: start]
12/14/06 19:07:18.834192 zmpkg[8072].DBG [Testing valid shell syntax]
12/14/06 19:07:18.834432 zmpkg[8072].DBG [Testing "sudo -u www-data true"]
12/14/06 19:07:18.838527 zmpkg[8072].DBG [Test failed, '']
12/14/06 19:07:18.838676 zmpkg[8072].DBG [Testing "su www-data --shell=/bin/sh --command='true'"
12/14/06 19:07:18.848256 zmpkg[8072].DBG [Test ok, using format "su www-data --shell=/bin/sh --command='<command>'"]
12/14/06 19:07:18.848439 zmpkg[8072].DBG [Command: su www-data --shell=/bin/sh --command='/usr/local/bin/zmdc.pl check']
12/14/06 19:07:19.012716 zmpkg[8072].DBG [Output: stopped]
12/14/06 19:07:19.012898 zmpkg[8072].DBG [Removing shared memory]
12/14/06 19:07:19.012968 zmpkg[8072].DBG [Checking for shared memory with 'ipcs -m | grep '^0x7a6d20'']
12/14/06 19:07:19.019740 zmpkg[8072].DBG [Command: su www-data --shell=/bin/sh --command='/usr/local/bin/zmfix']
12/14/06 19:07:19.037278 zmpkg[8072].ERR [Unable to run "su www-data --shell=/bin/sh --command='/usr/local/bin/zmfix'", output is ""]

then i installed sudo and got:

12/14/06 19:09:40.953001 zmpkg[8141].INF [Command: start]
12/14/06 19:09:40.953819 zmpkg[8141].DBG [Testing valid shell syntax]
12/14/06 19:09:40.954055 zmpkg[8141].DBG [Testing "sudo -u www-data true"]
12/14/06 19:09:40.998872 zmpkg[8141].DBG [Test ok, using format "sudo -u www-data <command>"]
12/14/06 19:09:40.999058 zmpkg[8141].DBG [Command: sudo -u www-data /usr/local/bin/zmdc.pl check]
12/14/06 19:09:41.161229 zmpkg[8141].DBG [Output: stopped]
12/14/06 19:09:41.161392 zmpkg[8141].DBG [Removing shared memory]
12/14/06 19:09:41.161476 zmpkg[8141].DBG [Checking for shared memory with 'ipcs -m | grep '^0x7a6d20'']
12/14/06 19:09:41.168192 zmpkg[8141].DBG [Command: sudo -u www-data /usr/local/bin/zmfix]
12/14/06 19:09:41.181921 zmpkg[8141].ERR [Unable to run "sudo -u www-data /usr/local/bin/zmfix", output is ""]

The old Version (1.22.1) functions and the 1.22.3 not anymore

What i did now was to replace the new zmfix with the old one
it is starting but i get errors in the zmdc what is i think logical cause it is from an other version. But what is wrong with the zmfix?
Here the log:

12/14/06 19:26:31.059418 zmdc[8241].ERR ['zma -m 1' exited abnormally, exit status 255]
12/14/06 19:26:31.062432 zmdc[8241].ERR ['zmf -m 1' exited abnormally, exit status 255]
12/14/06 19:26:38.026497 zmdc[8241].INF ['zmc -d /dev/video1' starting at 06/12/14 19:26:38, pid = 8454]
12/14/06 19:26:38.049234 zmdc[8241].ERR ['zmc -d /dev/video1' exited abnormally, exit status 255]
12/14/06 19:26:48.191117 zmdc[8241].INF ['zmc -d /dev/video1' starting at 06/12/14 19:26:48, pid = 8458]
12/14/06 19:26:48.202548 zmdc[8241].ERR ['zmc -d /dev/video1' exited abnormally, exit status 255]
12/14/06 19:26:58.385419 zmdc[8241].INF ['zmc -d /dev/video1' starting at 06/12/14 19:26:58, pid = 8463]
12/14/06 19:26:58.393813 zmdc[8241].ERR ['zmc -d /dev/video1' exited abnormally, exit status 255]

Thx in advance for you help!
Markus

[postfux]

Hi

So now my ZM is running.
I needet also to do a 'zmupdate.pl -f'
see also:
http://www.zoneminder.com/forums/viewtopic.php?t=6196

I didn't find anything about this in the Documentation not even that ther is a '-f' option for zmupdate.pl, maybe you wil have to mention this in the docu.

Markus