Cannot sync aowow with world database about aowow HOT 4 CLOSED

Ok after some magic database partially synchronized.
But no icons and some tables are still empty.
If it's ok - I can post link to db here.

from aowow.

After few reinstallation now I have a mostly working db (except few issues), ticket can be closed.
Probably for someone provided info in my first message can help in future.

from aowow.

Sorry for the delay. If you still have any problems, feel free to ask me.

Also, it would be nice if you could describe how you solved this error here. Maybe i can easily iron it out or at least anticipate it in the future.

from aowow.

Actually I don't know, I just tried few times

$ php aowow --sql
$ php aowow --firstrun

And now db looks ok. But after that I found another issue - not all icons and images are extracted from MPQ files (e.g. for 43599 item). I tried to extract them from all MPQ files that I have found. And solution for me - take missing icons from another similar project - https://github.com/Exodius/WoW-Armory/ (only big icons, anothers sizes are different from which we need for AoWoW) and convert tiny and small icons with imagemagick (from big icons).

from aowow.