MYSQL Error?

[Thor1423]

OS: Debain 12
PHP Version: 8.3
AOWOW Version: Latest with all Updates
AzerothCore: No
MySQL: 10.11.6-MariaDB-0+deb12u1 Debian 12
TC rev: TrinityCore rev. 51ede41aba4a+ 2024-10-14 11:55:46 +0200 (release branch) (Unix, RelWithDebInfo, Static)
TDB Version: Using World DB: TDB 335.24081

The console spams the following error message:
14:35:47 [WARN] WARNING - mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS newQSE

16:16:19 [WARN] WARNING - mysqli_query(): (21S01/1136): Column count doesn't match value count at row 1 @ /home/users/admin/www/xxx/aowow/includes/libs/DbSimple/Mysqli.php:165

aowow not compatible with the newest TC Version?

Is a fresh installation on a new server

[Sarjuuk]

14:35:47 [WARN] WARNING - mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS newQSE

This is MariaDB vs MySQL incompatibility thing. You need to roll back this part from 481a3dc#diff-f0e544595b41b612b1e4cd02497161cc3ff26f5249f5c064443f3f3492a64024R40

-                DB::Aowow()->query('INSERT INTO ?_quests_startend (?#) VALUES (?a) ON DUPLICATE KEY UPDATE method = method | VALUES(method), eventId = IF(eventId = 0, VALUES(eventId), eventId)', array_keys($d), array_values($d));
+                DB::Aowow()->query('INSERT INTO ?_quests_startend (?#) VALUES (?a) AS newQSE(`t`, `ti`, `qi`, `m`, `ei`) ON DUPLICATE KEY UPDATE `method` = `method` | newQSE.`m`, `eventId` = IF(`eventId` = 0, newQSE.`ei`, `eventId`)', array_keys($d), array_values($d));

/e: and i'm pretty certain there was another instance where the deprecated VALUES() construct was used, but i don't see it right now.
also roll back https://github.com/Sarjuuk/aowow/blob/master/includes/types/profile.class.php#L711

-                DB::Aowow()->query('INSERT INTO ?_profiler_profiles (?#) VALUES '.$ins.' ON DUPLICATE KEY UPDATE `name` = VALUES(`name`), `renameItr` = VALUES(`renameItr`)', array_keys(reset($baseData)));
+                DB::Aowow()->query('INSERT INTO ?_profiler_profiles (?#) VALUES '.$ins.' AS newP(`r`, `rg`, `na`, `itr`, `ra`, `cl`, `lvl`, `ge`, `g`, `gr`, `cf`) ON DUPLICATE KEY UPDATE `name` = newP.`na`, `renameItr` = newP.`itr`', array_keys(reset($baseData)));

---

16:16:19 [WARN] WARNING - mysqli_query(): (21S01/1136): Column count doesn't match value count at row 1 @ /home/users/admin/www/xxx/aowow/includes/libs/DbSimple/Mysqli.php:165

Is probably related to the warning, but you need to tell me where it occured.

[Thor1423]

16:16:19 [WARN] WARNING - mysqli_query(): (21S01/1136): Column count doesn't match value count at row 1 @ /home/users/admin/www/xxx/aowow/includes/libs/DbSimple/Mysqli.php:165

Is probably related to the warning, but you need to tell me where it occured.

21:01:13          [setup] resuming from step 78...
21:01:14          [setup] step 78 / 80
21:01:14          [update] checking for sql updates...
21:01:14  [OK]    [update] db is already up to date
21:01:15          [update] The following sql scripts have been scheduled: spawns                                                                                                                                                                                                                                             , stats
21:01:15          [update] The following build scripts have been scheduled: tool                                                                                                                                                                                                                                             tips, markup, locales
21:01:15          [sql] filling aowow_stats with data
21:01:15          [stats] - applying stats for enchantments
21:01:19  [WARN]  WARNING - mysqli_query(): (21S01/1136): Column count doesn't match value count at row 1 @ /home/users/admin/www/xxxxxx/aowow/includes/libs/DbSimple/Mysqli.php:165
21:01:19  [WARN]  WARNING -  at /home/users/admin/www/xxxxxx/aowow/setup/tools/sqlgen/itemstats.ss.php line 97 @ /home/users/admin/www/xxxxxx/aowow/includes/database.class.php:92
21:01:19  [WARN]  WARNING - mysqli_query(): (21S01/1136): Column count doesn't match value count at row 1 @ /home/users/admin/www/xxxxxx/aowow/includes/libs/DbSimple/Mysqli.php:165
21:01:19  [WARN]  WARNING -  at /home/users/admin/www/xxxxxx/aowow/setup/tools/sqlgen/itemstats.ss.php line 97 @ /home/users/admin/www/xxxxxx/aowow/includes/database.class.php:92
21:01:27             2017+639 enchantments parsed
21:01:27          [stats] - applying stats for items
21:01:28  [WARN]  WARNING - mysqli_query(): (21S01/1136): Column count doesn't match value count at row 1 @ /home/users/admin/www/xxxxxx/aowow/includes/libs/DbSimple/Mysqli.php:165
21:01:28  [WARN]  WARNING -  at /home/users/admin/www/xxxxxx/aowow/setup/tools/sqlgen/itemstats.ss.php line 61 @ /home/users/admin/www/xxxxxx/aowow/includes/database.class.php:92
21:01:28  [WARN]  WARNING - mysqli_query(): (21S01/1136): Column count doesn't match value count at row 1 @ /home/users/admin/www/xxxxxx/aowow/includes/libs/DbSimple/Mysqli.php:165

And all quests in aowow are marked as "red deactivated". And the minimap for the quests is black.
I think that has something to do with the errors

[Sarjuuk]

That doesnt make much sense. May be a couple days before i can check it in detail.

item stats are not related to quests, so something else is borked.

[Thor1423]

That doesnt make much sense. May be a couple days before i can check it in detail.

item stats are not related to quests, so something else is borked.

Here its what i mean..

Everything is marked as deactivated, even though these quests are not deactivated in the database and the map is black for the quests. Don't be surprised my aowow is in German

[Thor1423]

@Sarjuuk

I reinstalled everything with the fix for MariaDB, the quests are now no longer all marked as deactivated, but only those that are really deactivated.

But the problem with the black minima in the quests remains.
However, if I want to see where the NPCs are, the map is displayed correctly

NPCs

Quests:

Maybe you have an idea why the map works for the NPCs, but not for the quests

[Sarjuuk]

since you are using custom maps (#436) i' not inestigating this anomaly.

[Thor1423]

since you are using custom maps (#436) i' not inestigating this anomaly.

Here in my Thread the screenshot doesn't show a custom map but a standard Blizzard map.