ERROR 1054 (42S22) Using the most updated Playerbot AzerothCore build...

[Hiddenisme]

ERROR 1054 (42S22) at line 22: Unknown column 'id1' in 'where clause'♪◙
Applying of file 'G:/AzerothCore/azerothcore-wotlk/modules/mod-dungeon-master/data/sql/db-world/base/dm_setup.sql' to database 'acore_wotlk_world' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from AzerothCore repository with your sql client. If you are a developer, please fix your sql query.

[Paurobbi]

Ran into that error massively in individual progression module as well. It is however a simple fix even for a novice like myself. You will need to know how to access your SQL database to see how many ID columns there are currently in the creature table. Then adjust that SQL file (dm_setep.sql) to contain the correct id for line 22 and any other references of it. So you should see a id1 on line 22 if u open the sql file in vs code. that is what needs changed based on what your database has so it will run the query.

For example - Mine had 3x id columns of id1, id2, id3 for example and i had to rename every single error of id for creature table to id1 as that was the one being used in all the sql queries for IP. it was a lot but this module is a lot less extensive.

no idea why or what causes different id columns to be in the database, but there are so many different modules, cores, etc that im not surprised.

hope it helps.

[Tntdruid]

its this azerothcore/azerothcore-wotlk#25197

[kjcampbell1990-lang]

Ran into that error massively in individual progression module as well. It is however a simple fix even for a novice like myself. You will need to know how to access your SQL database to see how many ID columns there are currently in the creature table. Then adjust that SQL file (dm_setep.sql) to contain the correct id for line 22 and any other references of it. So you should see a id1 on line 22 if u open the sql file in vs code. that is what needs changed based on what your database has so it will run the query.

For example - Mine had 3x id columns of id1, id2, id3 for example and i had to rename every single error of id for creature table to id1 as that was the one being used in all the sql queries for IP. it was a lot but this module is a lot less extensive.

no idea why or what causes different id columns to be in the database, but there are so many different modules, cores, etc that im not surprised.

hope it helps.

I dont have any id1, id2, or id3 columns in my creature table in world dB I'm not sure how to fix

[mattthhdp]

In those files you have 4 place that id1, change it to id. Thats it everything will work

77fe0d7