LandSandBoat / server

:sailboat: LandSandBoat - a server emulator for Final Fantasy XI
https://landsandboat.github.io/server/
GNU General Public License v3.0
298 stars 599 forks source link

🐛 <Automaton equipment screen missing head, frame and attachments.> #5555

Open Goliance opened 6 months ago

Goliance commented 6 months ago

I affirm:

OS / platform the server is running (if known)

Windows 11

Branch affected by issue

base

Steps to reproduce

This happened after I received the sharpshot frame from Ghatsad, any previous attachments and the harlequin head and frame were gone and only recent attachments added show up. Logging in as puppetmaster shows nothing on the automaton equip screen. changing jobs does show the sharpshot frame and head but nothing else and only any attachments recently added. Making the character a GM and giving them the frames also did not work.

Expected behavior

Head, Frame and attachments should all be the same before and after changing them or changing jobs.

image

github-actions[bot] commented 6 months ago

✨ Thanks for the report! ✨

This is a friendly automated reminder that the maintainers won't look at your report until you've properly completed all of the checkboxes in the pre-filled template.

WinterSolstice8 commented 6 months ago

Will look into this tonight, no promises of a tonight fix though

WinterSolstice8 commented 6 months ago

What level is your PUP?

Goliance commented 6 months ago

What level is your PUP?

Level 12. I'm wondering if this happens every time you get a new frame?

And no worries, I'm just reporting it and if it gets fixed then thats great. Thanks for checking it out.

WinterSolstice8 commented 6 months ago

couldn't reproduce, image

Can you get me a dump of the table char_pet row for your character id?

Goliance commented 6 months ago

Sorry Winter, I'm not familiar with how to do that, is it through heidi or via visual studio?

WinterSolstice8 commented 6 months ago

Heidisql

WinterSolstice8 commented 6 months ago

can you print the output of /ver in game? If you have any dat mods, does it still happen with them off?

Ideally, use a completely vanilla client with no mods/addons/plugins and see if you still have the problem

Goliance commented 6 months ago

charpet.csv

Where do I get /ver? And I have no mods, running it straight off the server repo.

WinterSolstice8 commented 6 months ago

It's a built in client command to FFXI

You are not running windower or ashita?

Goliance commented 6 months ago

Ah sorry I got it on windower, its ver30240327_1

I'll try it without any addons, etc now.

WinterSolstice8 commented 6 months ago

So no .DAT mods of any kind? Just a vanilla install with windower, up to date, etc?

Goliance commented 6 months ago

Correct.

Edit: image

No addons or plugins installed.

WinterSolstice8 commented 6 months ago

Well, I certainly produced... something with your db values.

image

Goliance commented 6 months ago

Yep that looks about right.

WinterSolstice8 commented 6 months ago

I had to manually query the db to insert the blobs and it looks better now: image

but it's still missing the original head/body, and not sure how many attachments. at least it looks real similar to your original error.

p.s. it seems LSB is not sending attachment equips until you open equip->master first, then equip->automaton will show (more) stuff

Goliance commented 6 months ago

I'm not sure how I got here, even the skill levels are back at 0 and there's a plethora of attachments missing. I'll create a new character and see if I can reproduce it.

The turning point though was right when I received the head+frame from the quest.

WinterSolstice8 commented 6 months ago

image will give you back your frame/head that's missing

can you run the chat logger addon if you are going to remake and try to reproduce?

Goliance commented 6 months ago

Those commands reset the skill levels on the automaton but still no harlequin head+frame and no missing attachments.

WinterSolstice8 commented 6 months ago

that's weird. They immediately came back for me... when was the last time you updated LSB?

Goliance commented 6 months ago

I updated it today actually.

WinterSolstice8 commented 6 months ago

Alright, there was a period of time where blobs were written with some potentially wrong default values so I wonder if this was a side effect of it, but that entirely depends on when your character was created

Goliance commented 6 months ago

I'd say it was created last week. Now that I notice those commands give me an error, I'm supposed to run them inside the game correct?

WinterSolstice8 commented 6 months ago

yeah you need to be a level 5 GM and you need to target yourself/the other player

Goliance commented 6 months ago

image

Frame command went through but not body and it still displays nothing.

image

WinterSolstice8 commented 6 months ago

Whoops, i cropped my screenshot wrong, image its head and frame

WinterSolstice8 commented 6 months ago

Once you run the commands, zone and then open the master equip then automaton equip, does it look normal then?

Goliance commented 6 months ago

Still nothing after zoning and opening the menus in that order, I also get this in the info bar;

image

WinterSolstice8 commented 6 months ago

p.s. from your blob this is what I got for attachments: image

Goliance commented 6 months ago

Those attachments are correct, I added them around the time I got the sharpshot and then all the other ones disappeared.

WinterSolstice8 commented 6 months ago

paranoia check: try going outside to a non-city and seeing if the behavior changes?

Goliance commented 6 months ago

image

I had to activate for the automaton equip screen to update but it shows 0 skills and no attachments. Progress? lol.

WinterSolstice8 commented 6 months ago

Check the blob again in heidi, I wonder if it's zeroed on attachments

Goliance commented 6 months ago

Yep, shows NULL or a character that isn't recognized.

WinterSolstice8 commented 6 months ago

can you upload it again? I know where to look sort of now at least...

Goliance commented 6 months ago

charpet.csv

WinterSolstice8 commented 6 months ago

yup. you do have less attachments now... I don't really know what to think about this. I can't seem to reproduce the exact problem, BUT I am running on linux. Can you confirm it happens on a new char, too? If so I will boot up my VM and try to fix it maybe tomorrow. Assuming there's some obvious indicator of what breaks this

Goliance commented 6 months ago

Thats a copy, I'll get it done for you tomorrow, gonna have to call it a night here.

WinterSolstice8 commented 6 months ago

I tried windows on my own just in case and couldn't replicate it. I am curious though... Is the server running on a non-english windows? Or see if this checkbox is checked on the server? (for now, make sure it is unchecked)

image

Goliance commented 6 months ago

I wasn't able to reproduce the bug, which is great but that was weird...It was unchecked and its in english.

WinterSolstice8 commented 6 months ago

No reproducing on a new character, right? That's suspicious.

Any chance you could upload the busted character's rows from the database so I can see if I can reproduce it locally? your char info doesnt include passwords or anything, so no worries.