MySQL error

decibel83 · Post by **decibel83** » Mon Dec 24, 2007 11:01 pm

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.

decibel83 · Post by **decibel83** » Mon Dec 24, 2007 11:28 pm

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.

Post by **zoneminder** » Fri Dec 28, 2007 12:47 pm

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

johnc10 · Post by **johnc10** » Mon Dec 31, 2007 7:43 pm

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

Post by **zoneminder** » Tue Jan 01, 2008 10:09 pm

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?

johnc10 · Post by **johnc10** » Tue Jan 01, 2008 10:58 pm

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.

Post by **zoneminder** » Wed Jan 02, 2008 6:07 pm

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