git: 5ac399c45824 - main - www/mnogosearch: Fix with mysql-5.7 and above

The branch main has been updated by crees:

URL: https://cgit.FreeBSD.org/ports/commit/?id=5ac399c458241f36f9bc62469f1ed4a6a88a74ed

commit 5ac399c458241f36f9bc62469f1ed4a6a88a74ed
Author:     Konstantin Stroykovskiy <bonkor@gmail.com>
AuthorDate: 2023-03-27 07:56:11 +0000
Commit:     Chris Rees <crees@FreeBSD.org>
CommitDate: 2023-03-27 07:57:28 +0000

    www/mnogosearch: Fix with mysql-5.7 and above
    
    Variable "storage_engine" is deprecated in mysql-server version 5.6. It is removed from mysql 5.7. New variable is "default_storage_engine".
    
    PR:     ports/269365
---
 www/mnogosearch/Makefile                    |  1 +
 www/mnogosearch/files/patch-src-sql-mysql-c | 11 +++++++++++
 2 files changed, 12 insertions(+)

diff --git a/www/mnogosearch/Makefile b/www/mnogosearch/Makefile
index ebb63c6cc1d0..7cc4e081bd57 100644
--- a/www/mnogosearch/Makefile
+++ b/www/mnogosearch/Makefile
@@ -1,5 +1,6 @@
 PORTNAME=	mnogosearch
 PORTVERSION=	3.4.1
+PORTREVISION=	1
 CATEGORIES=	www databases
 MASTER_SITES=	http://www.mnogosearch.org/Download/
 
diff --git a/www/mnogosearch/files/patch-src-sql-mysql-c b/www/mnogosearch/files/patch-src-sql-mysql-c
new file mode 100644
index 000000000000..a5864284aeb7
--- /dev/null
+++ b/www/mnogosearch/files/patch-src-sql-mysql-c
@@ -0,0 +1,11 @@
+--- src/sql-mysql.c.orig	2023-02-06 10:23:32.970179000 +0300
++++ src/sql-mysql.c	2023-02-06 10:24:17.488815000 +0300
+@@ -206,7 +206,7 @@
+   {
+     int myrc;
+     char qbuf[64];
+-    udm_snprintf(qbuf, sizeof(qbuf), "SET storage_engine=%s",
++    udm_snprintf(qbuf, sizeof(qbuf), "SET default_storage_engine=%s",
+                  storage_engine[0] ?  storage_engine : "MyISAM");
+     if ((myrc= mysql_query(&mydb->mysql, qbuf)))
+     {