[FIXED] Database Bugs

I'm sure there will be a TON of bugs discovered. List them here and we will cross them off the list as they are fixed.

Re: Database Bugs

Postby adosorken on Thu Aug 25, 2016 3:07 pm

Thu Aug 25 10:03:16 2016 - CCharModelData loading normal file type for 3DDATA\NPC\LIST_NPC.CHR
Thu Aug 25 10:03:16 2016 - CCharModelData Failed to load normal file type for 3DDATA\NPC\LIST_NPC.CHR
Thu Aug 25 10:03:16 2016 - CCharModelData loading VFS file type for 3DDATA\NPC\LIST_NPC.CHR

Keep in mind that I have not yet unloaded the VFS. I only just barely found the tool that could do the job, which, of course, is Sniper's VFSEditor.exe (Universal VFS Extractor.exe and VFS Extractor.exe both crash). I will copy these files into the directory and see if the problem still manifests.
Evolve this!!
User avatar
adosorken
Smoulie
Smoulie
 
Posts: 61
Joined: Sat Aug 20, 2016 3:29 pm
Location: Windsor, VT

Re: Database Bugs

Postby adosorken on Thu Aug 25, 2016 3:11 pm

Okay... now I see what's wrong. It looks like there may be an error in the VFS file itself.

Image
Evolve this!!
User avatar
adosorken
Smoulie
Smoulie
 
Posts: 61
Joined: Sat Aug 20, 2016 3:29 pm
Location: Windsor, VT

Re: Database Bugs

Postby PurpleYouko on Thu Aug 25, 2016 3:17 pm

so you still couldn't extract the VFS fully?

Looks like I might have to upload the whole extracted VFS some place.
I'm actually considering deleting the entire VFS and just working from files anyway

Trouble is it's almost 2gig on my HD lol

Ah what the heck. I'm zipping it up and uploading it to my mega account. I'll let you know when its ready
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: Database Bugs

Postby adosorken on Thu Aug 25, 2016 3:24 pm

Not only can I not extract the VFS fully, but this is where TRose.exe is crashing. I am assuming that the uploaded file is corrupt in some way. Looks like the index is loading fine, but the data itself is corrupt.
Evolve this!!
User avatar
adosorken
Smoulie
Smoulie
 
Posts: 61
Joined: Sat Aug 20, 2016 3:29 pm
Location: Windsor, VT

Re: Database Bugs

Postby PurpleYouko on Thu Aug 25, 2016 3:29 pm

if you are crashing at this point and you haven't yet extracted your VFS then you have hit the bug that I already described in my introduction post.

There is at least one file type that cannot be loaded from VFS. I don't know which type as i haven't bothered to put in any time to figure it out. I just know it always crashes if I don't have a fully extracted VFS.

From your information I conclude that the actual bug is being caused by not having a valid check to see if the file (of the unknown type) is missing in normal file format. I had to go through them all and add this kind of check for each file type one by one and I obviously missed at least one. It will get fixed eventually but it's WAY the heck down low in terms of things that i need to work on.
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Re: Database Bugs

Postby WiseGuy on Thu Aug 25, 2016 3:48 pm

Thanks PY
I solved the error. My bad, I have wrong extraction the client

but found missing another sql, storage
It is nice to be important
but very very important to be nice
User avatar
WiseGuy
Pomic
Pomic
 
Posts: 112
Joined: Sat Nov 21, 2009 4:03 am
Location: Jakarta

Re: Database Bugs

Postby PurpleYouko on Thu Aug 25, 2016 4:11 pm

WiseGuy wrote:Thanks PY
I solved the error. My bad, I have wrong extraction the client

but found missing another sql, storage


We don't use the "storage" table any more. My server uses "charstorage" and "backupstorage"

Just checked and found some legacy code in playerdata.cpp that was still attempting to save to it.
I have commented that code out and pushed the modified file to the repo.

Guess that won't help if you are using my binaries though. Better update worldserverVS.exe too I suppose. :D
Need to lookup information on NARose items, skills, quests?
Now featuring a newly completed skill tree for all classes
Formatting fixed for different resolutions
Image

"A Gazelle is nothing but a giraffe plotted logarithmicaly"
User avatar
PurpleYouko
Rose Guru
Rose Guru
 
Posts: 4733
Joined: Fri Aug 10, 2007 2:05 pm

Previous

Return to BUGS

Who is online

Users browsing this forum: No registered users and 3 guests