DB error

҉ THT ҉ · 10/31/2009, 01:06

After I used Zombe Database cleaned .bak files i got some errors
(I know its not he's fault

)

I got some pics;

This is when I try to login after I made me char

This is when I make a character

~~zjesus~~ · 10/31/2009, 01:10

Do you have all class like dev in db? exemple: [DEV]Knight

҉ THT ҉ · 10/31/2009, 03:59

no,, me DB is compeltly empty now

EDIT:
I know what the bug is
When I make a char most cols in db get <NULL> valua ,, how can i fix it?

antondude · 10/31/2009, 10:34

[DEV]Knight
[DEV]Hunter
[DEV]Summoner
[DEV]Magician
[DEV]Segnale
[DEV]Warrior
[DEV]Aloken

These must be in database to log into the character format.

҉ THT ҉ · 10/31/2009, 16:54

in the "user_character" if yes , i did and not working

Gevdugaei · 10/31/2009, 19:42

Is verry hard to remake by hand all 6 characters, so I suggest you to restore the db(character)....If you implemented anti-gm, I can give you the line's from user_character....

҉ THT ҉ · 10/31/2009, 23:50

i didnt implented yet cuz, its not public

can you send me the lines?

Gevdugaei · 11/01/2009, 08:57

kk...

Spoiler

Zombe · 11/01/2009, 11:01

Hmm... That's weord. I use my own database without any problens :/

҉ THT ҉ · 11/01/2009, 17:17

Quote:

Originally Posted by Zombe

Hmm... That's weord. I use my own database without any problens :/

was it completly empty?

vanquish187 · 11/01/2009, 17:48

Quote:

Originally Posted by [GM]iHacker

was it completly empty?

I used Zombe's DB and no it was not empty.
It does include the chars in the DB that were posted above.
[DEV]Knight
[DEV]Hunter
[DEV]Summoner
[DEV]Magician
[DEV]Segnale
[DEV]Warrior
[DEV]Aloken

I do not know why you have these error's whithout sounding rude are you sure you done everything correctly ?
Maybe you did not force the restore and are still left with an empty DB ?

Zombe · 11/01/2009, 18:01

Quote:

Originally Posted by [GM]iHacker

was it completly empty?

no, it has the guild mastercode, the valid strings and the DEV chars.... hmm...

Gevdugaei · 11/01/2009, 18:49

I recomand you to restore the database...maybe you deleted the lines by wrong or you changed the character_NO of those 6 characters befone applying the script...zombe script is fully working....I tested it 3 or 4 times on differend PC's and it doesn't have bug's...if you use silkbooter 1 click server, you have to stop anti-gm job from db and add the lines that I mentioned in user_character...you can check on other tabels from character db to see they are completly empty or not...if they aren't, it meens you have problems only with user_character

~~[GM]Force~~ · 11/01/2009, 20:58

Yea,It's the best that you just restore the data base

It won't take you much of your time..

Edit: Dekaron style had the same problem

And we just restored our data base..It's the best way..

҉ THT ҉ · 11/02/2009, 10:52

Quote:

Originally Posted by vanquish187

I used Zombe's DB and no it was not empty.
It does include the chars in the DB that were posted above.
[DEV]Knight
[DEV]Hunter
[DEV]Summoner
[DEV]Magician
[DEV]Segnale
[DEV]Warrior
[DEV]Aloken

I do not know why you have these error's whithout sounding rude are you sure you done everything correctly ?
Maybe you did not force the restore and are still left with an empty DB ?

i did that but wasnt working

...
But that lines helped me

thanks to all!

EDIT: Close plz