Updates 1.32.3 > 1.33.0

Forum for questions and support relating to 1.33.x development only.
Locked
da1ver
Posts: 2
Joined: Thu Dec 13, 2018 7:50 am

Updates 1.32.3 > 1.33.0

Post 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
da1ver
Posts: 2
Joined: Thu Dec 13, 2018 7:50 am

Re: Updates 1.32.3 > 1.33.0

Post 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'"
));
User avatar
knight-of-ni
Posts: 2404
Joined: Thu Oct 18, 2007 1:55 pm
Location: Shiloh, IL

Re: Updates 1.32.3 > 1.33.0

Post by knight-of-ni »

Moved to the correct forum....
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/
Mike Peters
Posts: 2
Joined: Mon Dec 24, 2018 9:28 am

Re: Updates 1.32.3 > 1.33.0

Post by Mike Peters »

Thanks for sharing it)
Locked