Debian Sarge with Zoneminder 1.22.3

benlau · Post by **benlau** » Fri Dec 22, 2006 6:55 am

Hi.

The Debian Sarge dist. provides MySql server with version 4.0.24. Although it is rather old, zoneminder with version up to 1.22.2 is working fine. However, from 1.22.3, the sql script for initial setup was changed a lot. SQL statement like 'DEFAULT CHARSET=latin1` could not be executed by this version of mysql.

Example error:

ERROR 1064 at line 29: 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 17

It make the installation of Zoneminder in Debian Sarge fails. I think many servers run Debian/Sarge for daily operation. Would it be possible to consider to create sql statement that compatible with old version of Mysql in next version of Zoneminder?

Thanks.

Post by **cordel** » Fri Dec 22, 2006 9:37 am

If you would like, I could sed out the "DEFAULT CHARSET=latin1" from the file and send it to you. Just let me know. You might also find that it may not like the database engine type to be 'ENGINE=" and would rather have "TYPE="

Post by **zoneminder** » Sun Dec 24, 2006 3:41 pm

I can probably go back to a more compatible syntax for the next version. I will see how easy it is.