ZoneMinder Forums

I'm getting an error from MySQL when I try to import the db/zm_create.sql file in MySQL when installing ZoneMinder 1.23.0:

venere:/usr/local/src/ZoneMinder-1.23.0# mysql -uroot -p < db/zm_create.sql
Enter password:
ERROR 1064 (42000) at line 408: 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 'UNIQUE KEY `UC_Username` (`Username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 16

I looked in the file but I didn't managed in solving the problem.

Could you help me, please? Is this a bug?

Thank you! Bye and have a nice Christmas.

I solved the problem adding a "," at the end of the row 422 of the db/zm_create.sql file.
But now I have another problem during the compilation process, for which I am going to open another thread in the forum.

Thank you very much.

Ack! Apologies for this further SQL cock-up. Now updated.

I have just downloaded ZoneMinder-1.23.0.tar.gz and the error is still there.

Do you know where you got it from. I don't know if all mirrors updated but will check my ones. Also was this a fresh download or just an update?

Re-downloaded again from

http://www2.zoneminder.com/downloads/Zo ... 3.0.tar.gz

but this time it had been updated so it must have been a delay in the mirrors.

It was zm_create.sql for an initial install.

I re-uploaded it just in case anyway. I may have just sent the old one up again before