Description
Current Behaviour
Manually creating this table in acore_world using the script will cause an error with the world server when it launches on a fresh installation.
To get around this, I deleted the table from acore_world using:
drop table auctionhousebot_professionItems;
and launched worldserver again, where it built the table itself and resolved the issue.
The script in question is auctionhousebot_professionItems.sql
Expected Behaviour
I believe that perhaps the prebuilt table inside of the script may be wrong, and needs editing. Or the table in the script should be removed. worldserver seems to be able to build the table anyway.
Steps to reproduce the problem
-
Freshly install the mod
-
Manually paste all .sql scripts into mysql
-
run authworld and worldserver and have the above error.
-
To generate this error on an existing install, delete the table as it exists now and use the script's table.
Extra Notes
No response
AC rev. hash/commit
AC> AzerothCore rev. 9bc847d339ff+ 2025-05-21 12:08:03 +0000 (master branch) (Unix, RelWithDebInfo, Static)
Connected players: 0. Characters in world: 0.
Connection peak: 0.
Server uptime: 4 minute(s) 17 second(s)
Update time diff: 1ms. Last 500 diffs summary:
|- Mean: 1ms
|- Median: 1ms
|- Percentiles (95, 99, max): 3ms, 3ms, 3ms
Using SSL version: OpenSSL 3.0.2 15 Mar 2022 (library: OpenSSL 3.0.2 15 Mar 2022)
Using Boost version: 1.74.0
Using CMake version: 3.22.1
Using MySQL version: 80042
Found MySQL Executable: /usr/bin/mysql
Compiled on: Linux 6.12.10-76061203-generic
Worldserver listening connections on port 8085
Realmlist (Realm Id: 1) configured in port 8085
VMAPs status: Enabled. LineOfSight: true, getHeight: true, indoorCheck: false
MMAPs status: Enabled
maps directory located in /home/lucky1/azerothcore/env/dist/data/maps. Total size: 291014951 bytes
vmaps directory located in /home/lucky1/azerothcore/env/dist/data/vmaps. Total size: 658130721 bytes
mmaps directory located in /home/lucky1/azerothcore/env/dist/data/mmaps. Total size: 2192910844 bytes
Default DBC locale: enUS.
All available DBC locales: enUS
Using World DB: ACDB 335.13-dev
Latest LoginDatabase update: acore_cms_subscriptions.sql
Latest CharacterDatabase update: trasmorg.sql
Latest WorldDatabase update: z_filter_disabled_and_trash.sql
LoginDatabase queue size: 0
CharacterDatabase queue size: 0
WorldDatabase queue size: 0
List of enabled modules:
|- mod-ah-bot
|- mod-eluna
|- mod-learn-spells
|- mod-rdf-expansion
|- mod-solocraft
|- mod-transmog
Operating system
Pop!OS (ubuntu linux)
Custom changes or Modules
No response