[Monoman]

Hellow, i have a really odd problem, any pointers will be apreciated.

I upgraded my old, still functional xp os, to windows 7 and mounted my server again on the new machine, everything works fine with it but now my characters can't loot from gameobjects anymore, they kneel but no loot window pops up, and they get bugged in kneeling down position after they move away. I had only encountered this bug inside instances before, but not in the general world.

So far, i have changed mysql server from 5.0 to 5.1, i've tried to install a clean version of the mangos database, install another version of the database with another table set, and using the back up mangos database from the server. All of them had the same issue.
So i imagine that the database is not the problem here... but so far can't figure out what is causing this.

I have a very old YTDB_0.11.2_R541_MaNGOS_R9651_SD2_R1660_ACID_R304_RuDB_R37.4 and i have worked on it for at least 5 to 6 years and so far i haven't had issues with it.

Besides that all other tipes of looting are still functional, skinning, creature mining and herbgathering and looteable items.

Again thank's for your answers.

[Razmataz]

Did you compile the server yourself or are you using a repack?

The loot stuck bug used to be all the rage on Blizzard live servers, and afaik it was attributed to latency in fetching the necessary data. In this case, it might be that, or it might be something more nefarious such as OPCode problems.

[Monoman]

It is a repack, i just downloaded the whole thing some 5 to 6 years ago.

The thing that bugs me is why it' didn't happen when the server was mounted on Xp but it does now that i have Win7.

The server report does not show any errors when someone get the loot stuck problem.

Latency problems might be a reason, though the rest of the loot tables seem to have no issues at all.

Finally, what do you mean with OPcode problems?

[Razmataz]

The issue with repacks is that you don't necessarily have the exact same files or dlls that they do, ergo it might run into issues. OPCodes is unlikely to be the cause and even if it was, because you're using a repack you wouldn't be able to amend it.

Try repairing your gameobject_loot_template table through your database editor. It might be corrupted and that could be the cause of the issue.

[Monoman]

I can try that, but repair how exactly? importing a clean gameobject_loot_template table maybe? or changing something on it?

I have QUICE as my database editor and sqlyog. Quice so far recognize everything in the gameobject_loot_template table even the latest loot entries as it is exactly the same table than in my original server.

I copied the entire folder containing all databases when i baked up before upgrading. though I'have already tried with a clean installation of the server using the original tables that came with the repack but that didn't work either.  A clean server install had the same "gameobject loot bug".

[Razmataz]

You want to execute the following query:

check table gameobject_loot_template;

If the status in the output is not ok, then:

repair table gameobject_loot_template;

There might also be a flag in gameobject_loot_template that has recently been triggered for one reason or another that is preventing you from looting them ordinarily. Or some quality assigned to the gameobjects in gameobject_template. I really can't say for sure.

[Monoman]

Hey again Raz, i did as you told me to, and executed the command check. It returned the Output Status: OK

and checked the loot flags and seem to be in the right order

also i applied the checking command to gameobject_template and returned OK too so,

could it be that the problem is elsewhere?

[Monoman]

Well, after a lot of work, and tinkering nothing happenedm and i could not resolve the issue. However i wanted to thank you for your support on the matter and the time for answering.

I will try an up to date server now and start over. maybe all this mess was for the better.

Again, Thank you Razmataz

Monoman.