https://bugs.kde.org/show_bug.cgi?id=483060
kidakeh <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|FIXED |--- Ever confirmed|1 |0 Status|RESOLVED |REPORTED CC| |[email protected] --- Comment #10 from kidakeh <[email protected]> --- fix (commit 2781c3b) introduced a new bug in QMYSQL driver. The setUtcTimeZone() function added in that commit has a reversed condition: if (mysql_stmt_prepare(stmt.get(), query, sizeof(query) - 1)) // prepare returns 0 on success mysql_stmt_execute(stmt.get()); // so execute only runs when prepare fails As a result, SET time_zone = '+00:00' is never actually executed. MySQL general query log shows only Prepare and Close stmt, with no Execute: 23 Query SET NAMES utf8mb4 23 Init DB digikam 23 Prepare SELECT ? + ? 23 Close stmt 23 Prepare SET time_zone = '+00:00' 23 Close stmt 23 Prepare SELECT DISTINCT Images.id ... WHERE ... 23 Execute ... TIMESTAMP'2026-01-31 16:00:00' ... -- You are receiving this mail because: You are watching all bug changes.
