Trinitycore: [BFA] Update (Hotfixes 2018_09_25_00_hotfixes) ERROR'S

[Dozorov]

Applying update "2018_09_25_00_hotfixes.sql" '3BC8C33'...
ERROR 1054 (42S22) at line 86: Unknown column 'PosX' in 'artifact_power'

Applying of file 'F:/WoWBFA-Server/sql/updates/hotfixes/master/2018_09_25_00_hotfixes.sql' to database 'hotfixes' 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 TrinityCore repository with your sql client. If you are a developer, please fix your sql query.
Could not update the Hotfix database, see log for details.

[TrinityCoreBot]

This issue is not considered valid because of the following reasons:

• No proper commit hash (revision)

Please read http://bit.ly/tc-issuetracker-and-you and add the missing information to this issue. Thanks.

[Shauren]

bfa branch is not ready, don't use it

[AlcDenat]

He's not wrong tho, ran into the same issue today when switching to another machine.

https://github.com/TrinityCore/TrinityCore/blob/bfa/sql/updates/hotfixes/master/2018_09_25_00_hotfixes.sql#L160
That line for reasons unknown to me doesn't work on MySQL 5.5, works fine on 5.6 tho.
Error: No column "Flags" in "broadcast_text" (it's there, I checked).

If you rerun worldserver after that error you get above error because the column "PosX" gets renamed in the same .sql update file which is also reapplied because it didn't finish first time.

tl;dr: Update to MySQL 5.6