ZoneMinder Forums

Hello all

I get error when i try start zoneminder.
FAT [Version mismatch, system is version 1.33.0, database is 1.32.3...ate.]

when i try run zmupdate.pl z i see next error:
ERROR 1064 (42000) at line 8: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))' at line 10

Version Maridb :
mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1

zm_update-1.33.0.sql content:
--
-- This updates a 1.32.3 database to 1.33.0
--
--
-- Remove DefaultView from Monitors table.
--

SET @s = (SELECT IF(
(SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'Monitors'
AND table_schema = DATABASE()
AND column_name = 'DefaultView'
) > 0,
"ALTER TABLE Monitors DROP COLUMN DefaultView"
"SELECT 'Column DefaultView no longer exists in Monitors'",
));

PREPARE stmt FROM @s;
EXECUTE stmt;

Please, help me to resolv this issue.

Thanks

Resolved:

) > 0,
"ALTER TABLE Monitors DROP COLUMN DefaultView"
"SELECT 'Column DefaultView no longer exists in Monitors'",
));

>>>

) > 0,
"ALTER TABLE Monitors DROP COLUMN DefaultView",
"SELECT 'Column DefaultView no longer exists in Monitors'"
));

Moved to the correct forum....

Thanks for sharing it)