Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Error] Table 'acore_world.version' doesn't exist, might implies that Database need to update - commit 835cf3a #43

Open
languede opened this issue Sep 4, 2024 · 1 comment

Comments

@languede
Copy link

languede commented Sep 4, 2024

Got error in first run of the docker compose, container ac-db-import fail to start up

  • [Error] Table 'acore_world.table' doesn't exist
 ERROR 1146 (42S02) at line 2 in file: '/azerothcore/data/sql/updates/db_world/2024_07_16_02.sql': Table 'acore_world.version' doesn't exist
acore-docker-ac-db-import-1     | 
acore-docker-ac-db-import-1     | Applying of file '/azerothcore/data/sql/updates/db_world/2024_07_16_02.sql' to database 'acore_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.
acore-docker-ac-db-import-1     | Could not update the World database, see log for details.

by searching documents in AzerothCore, the section Errores comunes indicate that error was due to database structure is not up to date.

https://www.azerothcore.org/wiki/es/common-errors

@languede languede changed the title [Error] Table 'acore_world.table' doesn't exist implice that Database need to update [Error] Table 'acore_world.table' doesn't exist implies that Database need to update Sep 4, 2024
@languede languede changed the title [Error] Table 'acore_world.table' doesn't exist implies that Database need to update [Error] Table 'acore_world.table' doesn't exist implies that Database need to update - commit 835cf3a Sep 4, 2024
@languede languede changed the title [Error] Table 'acore_world.table' doesn't exist implies that Database need to update - commit 835cf3a [Error] Table 'acore_world.version' doesn't exist, might implies that Database need to update - commit 835cf3a Sep 4, 2024
@TheNotary
Copy link

I hit this problem too when testing out the docker compose stuff. For me, things went sideways because my docker for desktop ran out of space. The solutions was to increase the space in the app, delete all the containers and images I had docker system prune, and then delete the volumes related to the docker compose before trying again:

docker compose down --rmi all -v --remove-orphans

docker compose up

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants