Overlapping Data

[perxx82]

Hey guys,
I'm not 100% sure this is the correct forum to post in, but here goes:

I've been given access to an old PW module (Dragon Myrth) that I'm trying to get up and running.
This module is already scripted to work persistantly with a SQL dBase, and was doing so fine, when it was in operation (some 5 years ago..)

I have no prior knowledge as of how exactly that SQL dBase was set up, but using trial and error (loading the mod, trying to connect as a player, looking at the nwnx_odbc.txt for errors, and then creating the tables and fields it was looking for), it seems, I've managed to create a dBase NWN is happy with. All fields are so far created as VarChar (50)
Data is being written to the SQL dBase, and NWN is able to read from the dBase.
Here's my problem though: While it is writing player data, such as account information, character location etc, it appears to only do so for 1 player. If another player joins later, it will be his data stored, but the first one is now missing.
Seeing as the mod previously ran with a fairly large playerbase, and nothing is altered in the mod (except updating it to use the expansionsets, and from CEP 1.52 to 2.3), I'm guessing the issue might be with the SQL dBase itself. I'm not sure what would be the cause of that though.
Do you guys have any suggestions what I might be looking at?

[perxx82]

Just to clarify a bit:
Data is being stored in the dBase, for instance in the accounts table:

~ VDKU7WLG lotr 060782 30
~ 060782 lotr VDKU7WLG 30

If I log out, and login with another accout, it'll look like this:

~ QLULH4WN lotr PerXX82 30
~ PerXX82 lotr QLULH4WN 30


However, it should be keeping both accounts, rather than overwriting what's already there. It should look like this:


~ VDKU7WLG lotr 060782 30
~ 060782 lotr VDKU7WLG 30
~ QLULH4WN lotr PerXX82 30
~ PerXX82 lotr QLULH4WN 30

[perxx82]

Allright, I'm thinking it's most likely due to the fact that there's no primary key right now.

I've tried setting the 'name' field (2. from right) as Primary Key, but that didn't appear to have any effect.

Which one would be the preferred PK in this setup?

[Fireboar]

Posting the actual code that's doing the inserts would be helpful. Otherwise we're flailing in the dark and can't really help.

[perxx82]

Actually, I got it fixed.
As I suggested in the first post, the scripts were fine. The problem was that all fields was created as VarChars. Once they was set to their proper types, and an index of player, tag and name was created, things started working as intended