1.31.39 SQL error on clean install

[Eradicator]

Hi!
Tried to make clean install to resolve auth problem (described in auth problem topic) but encountered SQL error at install.
Tried to make

Code: Select all

mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql

same error:

Code: Select all

ERROR 1064 (42000) at line 420: 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 '' at line 48

P.S.I tested all builds of 1.31 and want to share testing experience but dont know how to do it correctly. Can anyone tell how make bugreport right? Thanks!

P.P.S. Sorry if it is trivial error. My SQL knowledge is too basic for this.

[bbunge]

MySQL or Mariadb?
Did you make the changes to the my.cnf?

[Eradicator]

MySQL or Mariadb?
Did you make the changes to the my.cnf?

MySQL from lamp-server.
My.cnf default (from /etc/mysql/mysql.conf.d/mysqld.cnf) with addition: sql_mode = NO_ENGINE_SUBSTITUTION

[Eradicator]

Tried on second test server. Problem exist! Did anyone clean install 1.31.39? May be some changes in installation? Is that manual correct?
http://zoneminder.readthedocs.io/en/lat ... untu-16-04

[iconnor]

There will be a new release tonight that should resolve this.

[Eradicator]

There will be a new release tonight that should resolve this.

Thank you very much!