1.37.28 - Error updating Database

[carlosph]

Hi, I´ve just updated my test environment to 1.37.28 and got an error during database update process:

Configurando zoneminder (1.37.28~20221214083017-jammy) ...
detected systemd
Detected db service is mysql.service
Checking for db
Db exists.
Updating permissions for user zmuser@localhost

Initiating database upgrade to version 1.37.28 from version 1.37.27

Upgrading database to version 1.37.28
Upgrading DB to 1.37.28 from 1.37.27
ERROR 1064 (42000) at line 5: 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 'SET @s = (SELECT IF(
(SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHER' at line 2
Output:
Command 'mysql --defaults-file=/etc/mysql/debian.cnf -hlocalhost zm < /usr/share/zoneminder/db/zm_update-1.37.28.sql' exited with status: 1
Error updating db.

MySQL version: Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

[iconnor]

New packages are building which should fix this.