ADB 820.00 broken about ashamanecore HOT 26 CLOSED

your database should be used as 8.3 !!! ;)

It isnt bad idea :P.I will check a thing and if it is ok I will try to create a pull request so fixes are added in ashamanecore :).
Edited: pull request done,while ashamanecore check it you can use my repository https://github.com/Daniel25/AshamaneCore with every db thing fixed,it compiles good and dbs update ok too. For more info about instaling it you can check my youtube chanel video ^^ : https://www.youtube.com/watch?v=f9SMUi_gE5Q

from ashamanecore.

Daniel25 all updates should also be installed automatically. But for many, ADB 820.00 is not installed, progress simply does not reach updates.

from ashamanecore.

Well I have installed the ADB 820 ok,I had to change max_allowed_packeds in the file ini of mysql to 500 MB (It was 4 MB). I'm figthing with the updates now :P.
I deleted 2019_06_08_00_characters.sql because both columns dont exists and it gives error.
2020_02_18_00_world.sql gives error because verifiedbuild colum is null in around of 350 rows,I created a fix adding a build in that rows.Checking if it finishs updating everything now...

from ashamanecore.

I changed the value of max_allowed_packeds at 5000m, now I also ran into an error with the update.
Applying of file 'C:/server/BFA/sql/ashamane/characters/2019_06_08_00_characters.sql' to database 'characters' failed!
Maybe you should try changing to 32000m)))

With 500 It works for me ok.
You can delete file,both columns are missing so you dont need to drop it. I have fixed every error with updatest. But I'm working in any error running worldserver because ashamane has missed any trinity's patches and there are any missing columns.
Fixes for updates:

Delete parche 2019_06_08_00_characters.sql

add patch manually:
UPDATE creature_template_scalingSET VerifiedBuild=0 WHERE entryIN(16345, 131089,16443,136945,140136,16357,127381,129788,126983,16250,15965,140149,16322,16323, 17655,129550,16601,16347,134572,15958,16274,134629,16339,139425,137204,133605,16327,136086, 131850,131677,135552,16245,126841,16199,129601,129599,130850,16337,136108,95204,135060,16238, 134990,134617,135846,126918,16198,16304,16353,16313,15409,129697,134025,135635,16348,135289, 136084,138762,135048,16252,16665,16200,129602,16293,129559,129547,138718,129527,129598,129600, 136087,129645,127106,16317,126969,16528,135987,130086,136154,16342,139108,15969,134616,15652, 134991,15655,133379,15668,139097,16318,16403,134691,129548,134686,134364,16319,134487,134599, 139422,135971,16331,137879,136696,131856,135624,136391,135562,15650,127480,16355,127485,135254, 135313,129437,16402,135553,131819,131585,16220,16343,137830,16202,131586,16542,131685,16344,16302, 130024,127119,16480,140138,129526,127352,16292,127315,128435,103785,107657,105938,107170,16239,16204, 130400,16295,16316,16310,16224,16335,15648,16219,16213,16340,16354,16330,137036,15420,100997,15670,15657, 15641,16196,15658,15636,15644,15402,16183,15945,15924,15645,15937,15966,16263,122971,15950,15642,127879, 133944,15408,16924,15949,15968,122969,134602,15647,16294,122973,122972,17210,128434,122984,17086,129553, 16464,15649,129552,128455,122963,125977,122965,122967,122968,16329,137233,131289,16231,16320,132126,128956, 16197,122970,16321,129517,16309,126734,125828,16246,16314,19456,16201,125868,16325,16311,130025,127503, 130087,135629,135341,136161,136085,136094,16352,138761,135556,135633,16463,131587,16315,16358,16341,17656, 131812,135240,135365,16334,16326,136330,134024,131670,131849,16332,16301,131669,16351,129732,129743,128551, 16303,130522,127124,126845,127111,126919,126928,126832,127757,130521,16162,130011,16308,16300,135989,16349, 112861,127799,130404,93679,107924,93654,109620,129529,107169,126848,112636,16291,16462,126847,16350,136539, 130012,16333,16205,129673,16253,16237,16324,16469,130902,122986,129699,130099,16346,138463,130172,130090, 16305,129448,134828,139970,129359,140144,15638,135816,129747,138705,130912,16328,15967,140145,140119,139300, 136406,134714,136408,139163,15643,143693,135445,135336,137857,136291,136407,17849,136404, 16203,15941,134600, 15407,15656,142929,15651,15637,15669);
before of patch 2020_02_18_00_world.sql or when you get error with that patch.

Comment-- ALTER TABLE item_appearance DROP COLUMN IF EXISTS SubclassID;
in patch 2020_02_17_00_hotfixes.sql,the column dont exist.

Change lines in 2020_02_18_00_hotfixes.sql instead of modify,columns dont exist:

ALTER TABLE artifact_tier ADD VerifiedBuild int(11) NOT NULL DEFAULT '0' AFTER MinimumEmpowerKnowledge;

ALTER TABLE artifact_unlock ADD VerifiedBuild int(11) NOT NULL DEFAULT '0'AFTER ArtifactID;

from ashamanecore.

Sure m8,just in this moment i got everything ok and server is running good and updated ^^.
Beside of the steps which I commented up, you have to copy in ashamanecore/hotfixes the patch of update/hotfixes 2019_10_26_00_hotfixes,ashamanecore forgot to apply it. And everything will work ^^.
I will post here a link with the 4 dbs when I have uploaded it.

from ashamanecore.

respect my friend, you are a real gentleman!

from ashamanecore.

https://mega.nz/file/jRpzgLpb#zbCct34DAePK3Y-9cG1rVlUi-LzooOo8LTkT66UtBnM
That are the 4 dbs. I have renamed the dbs so you dont forget to change the name of dbs in bnetserver.config and worldserver.config so server can connect or you can change the name of db in every file changing line:

USE auth_ashamanecore_bfa;
for
USE your db name;
;)

from ashamanecore.

Thanks! This is a great job!

from ashamanecore.

your database should be used as 8.3 !!! ;)

from ashamanecore.

Thank you for your work, Daniel25.

from ashamanecore.

Closed by @Daniel25 PR (thx)

from ashamanecore.

works perfect for me, tested and imported all DB including updates.

Random guess is your issue is related to this #179 (comment)

from ashamanecore.

no, there is some misstakes on comas and dots and like creatyres table more then half is grey not in sql query, but just marked as text. before i did it was working last time i downloaded not working. okay i will try 1 more time to download it but i am not sure if it works.

from ashamanecore.

the database is correct (except for the necessary modification #179 (comment ) )

I suggest to check if the database is really not damaged (full file)

from ashamanecore.

[SQL] Query ADB_world_820.00 start
[ERR] 5 - Out of memory (Needed 3053336 bytes)
[ERR]
when i try to execute the sql

from ashamanecore.

You mysql server is enough memory for the drop files size

from ashamanecore.

You mysql server is enough memory for the drop files size

what??
i dont understand

from ashamanecore.

srry got it im stupid nvm

from ashamanecore.

[SQL] Query ADB_world_820.00 start
[ERR] 5 - Out of memory (Needed 3053336 bytes)
[ERR]
when i try to execute the sql

It sounds like to me Server is inadequate for the demand or severly misconfigured on this one.

from ashamanecore.

databases still cause installation errors. Someone found a way out of the situation?

from ashamanecore.

The db update need full clean, if you put in the latest hotfix, the hotfix delete many table. and the update sql files, a littlebit outdted for 8.0 mysql. i mean if exists-> column if exists. and have freezes in the core.

from ashamanecore.

I install a new repack and mysql bases are also installing new ones. It is not about updating an already running server.

from ashamanecore.

Hello,I was wondering which is the way to install ashamanecore dbs. First I copy ADB 820.00 files in my server folder so it updates automatly and then....?It update the ashamene updates automatly too or I have to update ashamane updates mannually?I'm confuse with trinitycore autoupdate in ashamanecore....Sorry for asking it here,forum and website are down...Thanks you guys

from ashamanecore.

I changed the value of max_allowed_packeds at 5000m, now I also ran into an error with the update.
Applying of file 'C:/server/BFA/sql/ashamane/characters/2019_06_08_00_characters.sql' to database 'characters' failed!
Maybe you should try changing to 32000m)))

from ashamanecore.

In the last half hour, I fixed or deleted many update files. But I keep getting errors. It breaks my brain ... Daniel25 if you have the strength and patience to figure it all out, could you make backups of the databases and post a link to download them. I and many others would be immensely grateful to you.

from ashamanecore.

solved / integrated in latest commit

from ashamanecore.