Page 1 of 1

Updates 1.32.3 > 1.33.0

Posted: Thu Dec 13, 2018 7:55 am
by da1ver
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

Re: Updates 1.32.3 > 1.33.0

Posted: Thu Dec 13, 2018 11:59 am
by da1ver
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'"
));

Re: Updates 1.32.3 > 1.33.0

Posted: Thu Dec 13, 2018 7:43 pm
by knight-of-ni
Moved to the correct forum....

Re: Updates 1.32.3 > 1.33.0

Posted: Mon Dec 24, 2018 9:41 am
by Mike Peters
Thanks for sharing it)