DB error

[҉ THT ҉]

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]

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

[҉ THT ҉]

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]

[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 ҉]

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

[Gevdugaei]

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 ҉]

i didnt implented yet cuz, its not public
can you send me the lines?

[Gevdugaei]

kk...

 Spoiler

DEKARON0000001 [DEV]KNIGHT 19999999999991 0 0 0 0 0 0 1000 1000 6 3 4 2 336 363 336 366 7 7 0 0 1 0 10 0 0 0 0 0 0 0 0 20050325 5/31/2008 1:13:15 AM 5/31/2008 1:13:15 AM <Binary> 0 0 0 0 0
DEKARON1000001 [DEV]HUNTER 19999999999991 0 0 0 0 0 0 1000 1000 3 6 3 3 336 215 336 216 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 20050325 5/31/2008 1:13:15 AM 5/31/2008 1:13:15 AM <Binary> 0 0 0 0 0
DEKARON2000001 [DEV]MAGICIAN 19999999999991 0 0 0 0 0 0 1000 1000 2 3 2 8 354 146 354 146 7 7 0 0 1 2 0 0 0 0 0 0 0 0 0 20050325 5/31/2008 1:13:15 AM 5/31/2008 1:13:15 AM <Binary> 0 0 0 0 0
DEKARON3000001 [DEV]SUMMONER 19999999999991 0 0 0 0 0 0 1000 1000 4 3 4 4 284 146 232 158 0 0 0 0 1 3 117 0 0 0 0 0 0 0 0 20050325 5/31/2008 1:13:15 AM 5/31/2008 1:13:15 AM <Binary> 0 0 0 0 0
DEKARON4000001 [DEV]SEGNALLE 19999999999991 0 0 0 0 0 0 1000 1000 2 5 3 4 354 146 354 146 7 7 0 0 1 4 0 0 0 0 0 0 0 0 0 20050325 5/31/2008 1:13:15 AM 5/31/2008 1:13:15 AM <Binary> 0 0 0 0 0
DEKARON5000001 [DEV]WARRIOR 19999999999991 0 0 0 0 0 0 1000 1000 6 2 5 2 354 146 354 146 7 7 0 0 1 5 0 0 0 0 0 0 0 0 0 20050325 5/31/2008 1:13:15 AM 5/31/2008 1:13:15 AM <Binary> 0 0 0 0 0

[Zombe]

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

[҉ THT ҉]

Originally Posted by Zombe

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

was it completly empty?

[vanquish187]

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]

Originally Posted by [GM]iHacker

was it completly empty?

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

[Gevdugaei]

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]

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 ҉]

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