I finally got it to load on my computer by renaming the update file it was having an issue with C:\Azerothcore-wotlk\modules\mod-playerbots\data\sql\characters\updates\2026_01_30_00_change_to_innoDB.sql to .sql.old

I then loaded the world server and it made all the databases and such and after the server was loaded I shut it back down, then I renamed that .sql.old file back to .sql and reran the world server in which it loaded the update without issue.

So not sure why but you may want to try that to see if it works on yours. Not sure what the issue is or was but its working for me after that.

Best of luck!

I finally got it to load on my computer by renaming the update file it was having an issue with C:\Azerothcore-wotlk\modules\mod-playerbots\data\sql\characters\updates\2026_01_30_00_change_to_innoDB.sql to .sql.old

Your acore user probably lacks a right to convert the tables to InnoDB. You need somthing like this:
GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO '[usernmae]'@'[host]';

Example:
GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO 'acore'@'localhost';

Thank you for that and I did initially add those permissions but it still failed. I did rename that last update file, it was able to load for the first time and create all the databases that it needed. I then shut the server down renamed that file that had failed earlier back so it would update and it did complete. So not sure if it was the order of updating the others first then that last one? I am not sure but it is working beautifully on my server now.

I am not sure if it matters but this was a first time install of this module. Could it be that I had to do the earlier updates first and then run that last update to convert the database? as I saw that at the time the update I was having trouble with was recently put on the server as a update about the same time I downloaded your module.

But I did get it to work with all of the update patches. I thank you for your assistance!

The issue is that the update file is called before the tables are created when starting from scratch. So even if you grant Acore the required permissions, you'll get a ERROR 1146 (42S02) at line 5: Table 'acore_characters.playerbots_guild_names' doesn't exist.

So renaming the file, running the worldserver, allowing the databases to be populated and then running the .sql file afterwards does work.

I tried compiling and running it, and encountered the same problem.