The-Pokemod-Group / Atlas-All-In-One

An all-in-one package with the minimum third-party requirements to get started as quickly as possible with Pokemod Atlas
28 stars 15 forks source link

Hangs on database issue - Duplicated column name #15

Open Gdenge opened 7 months ago

Gdenge commented 7 months ago

I tried searching for the issue on the DB itself, couldn't find a resolution. Google was helpful in getting some background info, but I am not seeing where the query is set to do the migration, so I can not address it.

Tried setting the version of the database as the same as the instruction, to no avail and also the the current version, with the same issue.

Running localhost:9000 brings me to the page where its supposed to refresh itself every 30 seconds Running localhost:9200 brings me phpmyadmin Running localhost:9001 does nothing (as expected) Running localhost:9100 shows me the RDM-tools

Logs:


[+] Running 4/0
 ✔ Container atlas-db        Running                                                                                                                                                                     0.0s
 ✔ Container atlas-rdm       Running                                                                                                                                                                     0.0s
 ✔ Container atlas-pma       Running                                                                                                                                                                     0.0s
 ✔ Container atlas-rdmtools  Running

[INFO] [ConfigLoader] Loaded config settings: ENV Vars
[INFO] [MAIN] Log level set to: debug
[INFO] [MAIN] Installing Backtrace
[INFO] [MAIN] Getting Version
[INFO] [VersionManager] Version 1.52.0 (d3de54a6b5048377d51c064ea11425241fc82bf4)
[INFO] [MAIN] Starting Startup Webserver
[INFO] Starting HTTP server Temp Web Server on 0.0.0.0:9000
[INFO] [MAIN] Starting Database Controller
[INFO] [DBController] Initializing database
[INFO] [DBController] DB backups enabled: false
[INFO] [DBController] Migrating database to version 1
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 2
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 3
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 4
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 5
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 6
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 7
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 8
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 9
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 10
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 11
[INFO] [DBController] Migration successful
[INFO] [DBController] Migrating database to version 12
[CRIT] [DBController] Migration Failed: (Lost connection to MySQL server during query)
[INFO] [DBController] Threading.sleeping indefinitely
[INFO] [ConfigLoader] Loaded config settings: ENV Vars
[INFO] [MAIN] Log level set to: debug
[INFO] [MAIN] Installing Backtrace
[INFO] [MAIN] Getting Version
[INFO] [VersionManager] Version 1.52.0 (d3de54a6b5048377d51c064ea11425241fc82bf4)
[INFO] [MAIN] Starting Startup Webserver
[INFO] Starting HTTP server Temp Web Server on 0.0.0.0:9000
[INFO] [MAIN] Starting Database Controller
[INFO] [DBController] Initializing database
[INFO] [DBController] DB backups enabled: false
[INFO] [DBController] Migrating database to version 12
[CRIT] [DBController] Migration Failed: (Duplicate column name 'account_username')
[INFO] [DBController] Threading.sleeping indefinitely
fbtvirtue commented 5 months ago

I have the same issue, is there any solution?