Page 1 of 1

1.31.39 SQL error on clean install

Posted: Mon Feb 26, 2018 7:14 am
by 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. :(

Re: 1.31.39 SQL error on clean install

Posted: Mon Feb 26, 2018 12:54 pm
by bbunge
MySQL or Mariadb?
Did you make the changes to the my.cnf?

Re: 1.31.39 SQL error on clean install

Posted: Mon Feb 26, 2018 4:00 pm
by Eradicator
bbunge wrote: Mon Feb 26, 2018 12:54 pm 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

Re: 1.31.39 SQL error on clean install

Posted: Tue Feb 27, 2018 2:28 pm
by 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

Re: 1.31.39 SQL error on clean install

Posted: Fri Mar 02, 2018 3:50 am
by iconnor
There will be a new release tonight that should resolve this.

Re: 1.31.39 SQL error on clean install

Posted: Fri Mar 02, 2018 6:14 am
by Eradicator
iconnor wrote: Fri Mar 02, 2018 3:50 am There will be a new release tonight that should resolve this.
Thank you very much!