From 6b1dd7e19ef52c2760d65849a31a29af70ad9795 Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Sat, 10 Feb 2024 17:31:17 -0300 Subject: fix(Core/Database) mysql_stmt_bind_param deprecated in MySQL 8.3 (#18295) * feat(fix/build) Test on MacOS * Syntax error * Syntax error * Adding missing parameters * typo * deprecated * Check MySQL version --- src/server/database/Database/MySQLConnection.cpp | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'src/server/database/Database/MySQLConnection.cpp') diff --git a/src/server/database/Database/MySQLConnection.cpp b/src/server/database/Database/MySQLConnection.cpp index 3e776059a1..d3c8fc6d75 100644 --- a/src/server/database/Database/MySQLConnection.cpp +++ b/src/server/database/Database/MySQLConnection.cpp @@ -227,7 +227,11 @@ bool MySQLConnection::Execute(PreparedStatementBase* stmt) uint32 _s = getMSTime(); +#if MYSQL_VERSION_ID >= 80300 + if (mysql_stmt_bind_named_param(msql_STMT, msql_BIND, m_mStmt->GetParameterCount(), nullptr)) +#else if (mysql_stmt_bind_param(msql_STMT, msql_BIND)) +#endif { uint32 lErrno = mysql_errno(m_Mysql); LOG_ERROR("sql.sql", "SQL(p): {}\n [ERROR]: [{}] {}", m_mStmt->getQueryString(), lErrno, mysql_stmt_error(msql_STMT)); @@ -275,7 +279,11 @@ bool MySQLConnection::_Query(PreparedStatementBase* stmt, MySQLPreparedStatement uint32 _s = getMSTime(); +#if MYSQL_VERSION_ID >= 80300 + if (mysql_stmt_bind_named_param(msql_STMT, msql_BIND, m_mStmt->GetParameterCount(), nullptr)) +#else if (mysql_stmt_bind_param(msql_STMT, msql_BIND)) +#endif { uint32 lErrno = mysql_errno(m_Mysql); LOG_ERROR("sql.sql", "SQL(p): {}\n [ERROR]: [{}] {}", m_mStmt->getQueryString(), lErrno, mysql_stmt_error(msql_STMT)); -- cgit v1.2.3