Some pages have same display

Sarjuuk / aowow

Database viewer for TrinityCore based on aowow by @LordJZ, based on the JS-Engine of Wowhead

204 stars 217 forks source link

Some pages have same display #155

Closed TheWinchesters closed 6 years ago

TheWinchesters commented 6 years ago

I do not know why but some pages like /?help=screenshots-tips-tricks show content from /?help=commenting-and-you. This is the db table: https://ibb.co/er62S0

What did I do wrong?

I can edit it by hand, but where can I find the content for those pages?

TheWinchesters commented 6 years ago

Found the content I need to change, I will change it by hand. Why did this happen? No idea.

TheWinchesters commented 6 years ago

Finally, if someone has the same problem, just delete the entries and insert them again. The insert query needed is in db_structure.sql

Sarjuuk commented 6 years ago

Why did this happen? No idea.

Pretty much this. Either you are the first with this issue or nobody else bothered reporting it. Every other table with predefined content is fine?

TheWinchesters commented 6 years ago

Everything else is fine. The problem is only with this table, in those entries where type and typeId are NULL.

I can tell you how to reproduce the problem, (or it is still just a problem for me). I speak spanish so I was trying to translate those articles.

I made the first one (tooltips), making a copy of the original one, changing locale 0 to 6 and spanish content.
Everything good.
I made the second one (aboutus) with another spanish content ofcourse.
Now, tooltips and aboutus have the same text in 'article'.

Sarjuuk commented 6 years ago

uh... so it was fine until you started editing the articles? (and presumably queried an update with a non-unique key)

aowow_articles should have two unique keys and you should use one of them in your update statements. In your case the latter, to be precise: type-typeId-locale and url-locale

TheWinchesters commented 6 years ago

Mmmm, not sure if I touched anything first but probably that is the reason. What kind of type / typeId can I use for esES? So, no problem then! Sorry for making this unuseful issue. Thank you for your help!

Last question: Where could I ask a few doubts I have about aowow?

Sarjuuk commented 6 years ago

Again, you need to specify either of the available key pairs. If the article you are editing has an url set, you can't use type/typeId as the values are NULL.