Help! problem with new spell db

[tycone]

After testing on 6 different DOL 1.8 servers and 3 different computers but used the same database version and manager. I still had the problem with the new sql spell packages but I have concluded that it is definitely a problem from the database it is a problem on my end, i use mysql 4.1 and 5.0 for my database and navicat mysql editor for my mysql manager. Think one of those could be causing my problem. Also anyone have any recomendations to change those 2?

[Etaew]

4.1 should be considered stable, 5 should be ok too.

[Supgee]

TBH, I would recommend using MySQL 4.1.

I've had nothing but grief with MySQL 5.0, trying to run a DOL server.

4.1 is the way too go!

[tycone]

Would Navicat be causing me problem then?

[Overdriven]

Navicat doesn't effect the DBs when loading up the game.


Go to 4.1 and test again, since no one seems to be able to reproduce this error. (Considering Tired and Myself both use this database..)

[Nebulus]

Where is the key?
"SpecialValue" Server don't create the key automatic or not implementet yet in the last release.?
in stylesubstitute.SQL and style.SQL

[Etaew]

Hurt me if I'm wrong but wasn't SpecialValue removed recently, if you use the latest SVN, make sure you use the latest database release from DOL too.

[Overdriven]

Hurt me if I'm wrong but wasn't SpecialValue removed recently, if you use the latest SVN, make sure you use the latest database release from DOL too.

If that's correct, I'll need to re-release.



EDIT: - Nope, even with latest SVN I don't error.
EDIT2: - Will re-release DB soon as latest SVN doesn't have it in the core so it won't support the field.
EDIT3: Released

[tycone]

I downloaded the newest database but it still didnt work

[Overdriven]

I downloaded the newest database but it still didnt work

What error this time?

[tycone]

Its technicaly not an error but it gets the same message it gets before I think I have figured out wtf is going on, when I have spellline in the db and nothing else I get the same message but it boots up. Let me explain: the message was "SpellLine , 21260 spells" And every minute or so it says it again and it keeps it up until I decide the server isnt working. But when it has 0 spells in the db instead of "SpellLine , 21260 spells" I get "SpellLine , 0 spells" and also instead of apearing evering minute it apears every .01 seconds. They just fly across my screen about 100 times then it works. But when theres 21260 spells in the db all those messages i need to get take longer to procces therefor it takes longer to boot up. So technicaly if I gave the server enough time it should work. but I left my comp up for over 6 hours and that still wasnt enough time to boot up. I dont wanna wait like days each time i need to bring my server back up. Any suggestions?

[Etaew]

None that I can think of, but the official DOL server starts proper testing tomorrow it will use a blank SVN and only the databases we've provided, we will see what that turns up with.

[Tired]

Here's what I see in the database currently:

Code: Select all

Spell Table - 4,252

SpellLine Table - 151

LinexSpell Table - 4354

It is beyond my comprehension how you got, "SpellLine , 21260 spells", to show up.

As Etaew said, we'll see when the server goes up.

[Tired]

From my calculations, it looks like you keep importing the database into one another.

Code: Select all

21260 divided-by 4252 = 5

It was done 5 times.

[kederav]

say i have same error as tyler, i run dol 1.8, i use navicat, mysql4.1