Wiping out the player database?

[skigoggles 0]

so I'm running a test server locally to help out with a public server. I have it up to 1.8.6.1 and all is well.  I'm testing out missions, AI, inventory and the like.

 

I thought I had a good handle on the database. I've been editing inventories and adding items. No problem.  

 

I believed I messed up one of the players(there are only 3) so I thought I'd just delete everything from character_data, character_dead, player_data and player_login and start over.  Unfortunately this doesn't work. The server starts, but users get stuck on the 'waiting for server to start authentication' and in the arma2aoserver.rpt you get something like 'cannot sync PLAYER1 no characterID'

 

I've recreated what i think are the rows from a saved copy. I have definitely found the correct PlayerUID (confirmed in the game and in the logs). 

 

I would think you could wipe those tables and start over. Is there something cached in the file system on the server??

 

 

[skigoggles 0]

ok, so I'll answer my own post. I needed to delete anything that my character owned in object_data (delete from object_data where characterid=10' [where 10 was my characterid from the character_data table]). Since I was wiping out the player db, I just deleted it all and respawned the vehicles, etc.

 

now I know just a little bit more!