summaryrefslogtreecommitdiff
path: root/src/server/database/Database/MySQLConnection.cpp
diff options
context:
space:
mode:
authorWalter Pagani <paganiwalter@gmail.com>2024-02-10 17:31:17 -0300
committerGitHub <noreply@github.com>2024-02-10 21:31:17 +0100
commit6b1dd7e19ef52c2760d65849a31a29af70ad9795 (patch)
tree870e6aa1f75f9aaed2369dffadd1ddda46cb4234 /src/server/database/Database/MySQLConnection.cpp
parent04266cc18d2f32c35cf8e5e47401c5e0754a4beb (diff)
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
Diffstat (limited to 'src/server/database/Database/MySQLConnection.cpp')
-rw-r--r--src/server/database/Database/MySQLConnection.cpp8
1 files changed, 8 insertions, 0 deletions
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));