Page 1 of 1

Help plz. Weird bug

Posted: 14 Mar 2021, 08:01
by Gнosт
I have 2 logs with the spinny icon thing that cant be picked up, sawed, or N'd. I found the terrain ID they are located on with $TerrainSelection::debug_drawCellInfo = 1;
and deleted what was there in the DB and restarted the server, but they are still there. i went back in and checked for stuff in the adjacent tiles.. nothing.

they can be stood on but your character vibrates when on top of them. you cant hit them with a seige torch and cant be blown up with a sapper charge. i tried 10.
they are not on a claim or admin land.

I'm out of ideas.

Re: Help plz. Weird bug

Posted: 14 Mar 2021, 09:49
by Nyuton
you can't just delete objects from the DB without fully rewriting the objects_patch table.

Re: Help plz. Weird bug

Posted: 14 Mar 2021, 17:18
by Gнosт
Sorry I'm an sql noob.

Do I just delete the entries at that geoID in the objects_patch table, then reboot?

Re: Help plz. Weird bug

Posted: 14 Mar 2021, 20:30
by Nyuton
the records in objects_patch have a version number that must be consecutive for each terrain ID.
if you delete a record somewhere, there will be a version number missing and the server won't start. so you'd have to edit all the following records and lower their version number to get consecutive numbering. finally you have to update the objects_version column in the terrain_blocks table with the new final version number.

TL;DR: don't delete objects from database. it's a hideous, daunting task.

Re: Help plz. Weird bug

Posted: 14 Mar 2021, 21:54
by Gнosт
got ya. bury the logs and forget about them.

hopefully they will unbug themselves eventually. i'll check on them every couple weeks.

Thank you