azerothcore / aowow

Database viewer AoWoW adapted for AzerothCore
https://wowgaming.altervista.org/aowow/
33 stars 33 forks source link

No longer working since update #20

Closed noisiver closed 1 year ago

noisiver commented 1 year ago

Describe the bug and how to reproduce it Install the database viewer. It errors out almost instantly.

It tries to run the query and the columns it tries to use doesn't exist..

SELECT EnchantID AS ARRAY_KEY, Chance AS procChance, ratePerMinute AS ppmRate FROM spell_enchant_proc_data

Screenshots image

System:

noisiver commented 1 year ago

I downgraded to PHP 8.0 and it passed the above error but now it gets stuck elsewhere instead. See below.

image

noisiver commented 1 year ago

Just for the record, I did try the official repository by Sarjuuk, with TDB, and it works like it should with exactly the same version of PHP (8.0) and the same mpqdata.

Helias commented 1 year ago

I've just updated it and tested locally, download the master branch, it will work.

I am still doing some tests and check if there is some info missing

note: I updated the README.md too

noisiver commented 1 year ago

I will test it now. Will respond when I know how it turns out. Thank you for taking the time with this, by the way.

You updated the README to say PHP > 7.1 but it won't run unless you have at least 8.0. Is that intentional?

Helias commented 1 year ago

you're right, you need PHP8+, I will update that detail

noisiver commented 1 year ago

It does get further along but now it crashes here instead image

Helias commented 1 year ago

try to update now please

noisiver commented 1 year ago

It's installing right now, just to let you know I'm on it.

noisiver commented 1 year ago

It did successfully install but now it can't show pages. I tried looking at npcs, objects, items and spells but they always say page not found. I tried forcing a sync of all the data and it still says it. image

noisiver commented 1 year ago

Actually, gameobjects do seem to work. So does achievements, emotes, hunter pets, races, classes, titles, factions and a few other things. It seems to be mainly spells, creatures, items, currencies and quests that show a page not found error. There may be more though because I haven't gone through every possibility.

noisiver commented 1 year ago

Heh, it also stopped working because of updates to AzerothCore. image

Helias commented 1 year ago

Please, contact me on Discord Helias#1661, so we can figure out easily any related issue.

Keep in mind that https://wowgaming.altervista.org/aowow/ works now with this version https://github.com/azerothcore/azerothcore-wotlk/commit/b874760efee9a1f31a121effb1a56788a7d82e34 So the AC of one week ago, but it could work also with the latest data if there are nochanges in the db structure

noisiver commented 1 year ago

I've downloaded the specific commit of AzerothCore that you linked and I made sure to have the latest commit of this repository. It's currently installing and if I still have the same issue - the one saying page not found - , should I bother posting here or just go straight to Discord?

Helias commented 1 year ago

you can ping me on discord for this