Weird names error in log and player_DATA

[269091]

After I set up the server three times I am very close to giving up and simply choosing another mod... Every time after a while of plying I start getting the following error. The players names in the database are getting changed to "Error" and then, after a certain time again back to their original player name. Here is a sample log entry (from HiveExt.log) and sample database entries from player_DATA:

 

2013-09-01 16:16:12 HiveExt: [information] Method: 101 Params: 1421xxxxx:11:Sonny:

2013-09-01 16:16:12 HiveExt: [information] Result: ["PASS",false,"1",[],[],[],[0,18,18],"Survivor2_DZ",0.96]

2013-09-01 16:16:27 HiveExt: [information] Method: 101 Params: 1421xxxxx:11:Sonny:

2013-09-01 16:16:27 HiveExt: [information] Result: ["PASS",false,"1",[],[],[],[18,18,18],"Survivor2_DZ",0.96]

2013-09-01 16:16:30 HiveExt: [information] Method: 307 Params:

2013-09-01 16:16:30 HiveExt: [information] Result: ["PASS",[2013,9,1,11,16]]

2013-09-01 16:16:43 HiveExt: [information] Method: 101 Params: 1421xxxxx:11:Sonny:

2013-09-01 16:16:43 HiveExt: [information] Result: ["PASS",false,"1",[],[],[],[18,18,18],"Survivor2_DZ",0.96]

2013-09-01 16:17:01 HiveExt: [information] Method: 307 Params:

2013-09-01 16:17:01 HiveExt: [information] Result: ["PASS",[2013,9,1,11,17]]

2013-09-01 16:17:03 HiveExt: [information] Method: 101 Params: 1421xxxxx:11:Sonny:

2013-09-01 16:17:03 HiveExt: [information] Result: ["PASS",false,"1",[],[],[],[18,18,18],"Survivor2_DZ",0.96]

2013-09-01 16:17:04 HiveExt: [information] Method: 102 Params: 1:

2013-09-01 16:17:04 HiveExt: [information] Result: ["PASS",[],[0,0,0,0],[],[],2500,11]

2013-09-01 16:17:18 HiveExt: [information] Method: 101 Params: 1421xxxxx:11:Error:No vehicle:

2013-09-01 16:17:18 HiveExt: [information] Changed name of player 1421xxxxx from 'Sonny' to 'Error'

2013-09-01 16:17:18 HiveExt: [information] Result: ["PASS",false,"1",[],[],[],[18,19,19],"Survivor2_DZ",0.96]

2013-09-01 16:17:30 HiveExt: [information] Method: 101 Params: 1421xxxxx:11:Error:No vehicle:

 

 

and later on....

 

2013-09-01 16:48:33 HiveExt: [information] Method: 101 Params: 1421xxxxx:11:Sonny:

2013-09-01 16:48:33 HiveExt: [information] Changed name of player 1421xxxxx from 'Error' to 'Sonny'

2013-09-01 16:48:33 HiveExt: [information] Result: ["PASS",false,"1",[267,[6678.28,2297.32,0.102]],[["ItemFlashlight","ItemKnife","ItemToolbox","Binocular","ItemHatchet","ItemWatch","revolver_EP1","LeeEnfield"],["20Rnd_762x51_DMR","PartWheel","ItemPainkiller","ItemPainkiller","10x_303","10x_303",["30Rnd_556x45_Stanag",6],["30Rnd_556x45_Stanag",18],"30Rnd_556x45_StanagSD","ItemSodaCoke","ItemBandage","ItemBandage","ItemBandage","ItemBandage","ItemBandage","ItemBandage","6Rnd_45ACP","6Rnd_45ACP"]],["DZ_TK_Assault_Pack_EP1",[["M4A1_Aim"],[1]],[["ItemBloodbag","ItemMorphine","ItemAntibiotic","20Rnd_762x51_DMR","ItemBandage","30Rnd_556x45_Stanag","30Rnd_556x45_StanagSD"],[1,2,4,1,1,2,1]]],[19,50,50],"Survivor2_DZ",0.96]

2013-09-01 16:48:33 HiveExt: [information] Method: 101 Params: 1421xxxxx:11:Sonny:

2013-09-01 16:48:33 HiveExt: [information] Changed name of player 1421xxxxx from 'Error' to 'Sonny'

 

 

 

database sql export:

 

('102xxxxxx', '[GH]Knusper-Knackwurst', 0, 0),

('105xxxxxx', 'Rebell ', 0, 0),

('110xxxxxx', '{Cdt}Braders', 0, 0),

('119xxxxxx', 'OatBoy', 0, 0),

('120xxxxxx', 'Error', 0, 0),

('120xxxxxx', '{Cdt}OliH', 0, 0),

('128xxxxxx', '[GH] Dead Butcher', 0, 0),

('141xxxxxx', 'Hypon', 0, 0),

('141xxxxxx', '[HOTD] SkyDruss', 0, 0),

('142xxxxxx', 'Error', 0, 0), --> This one is supposed to be Sonny

('146xxxxxx', 'Ash', 0, 0),

('146xxxxxx', 'nova88', 0, 0),

('195xxxxxx', 'WantedXXX', 0, 0),

('250xxxxxx', '[GH]Kotbeutel-Spender', 0, 0),

('272xxxxxx', '[R3] CeduCtion', 0, 0),

('272xxxxxx', '[R3] incrEDDYble', 0, 0),

('280xxxxxx', 'Michael Adrien', 0, 0),

('448xxxxxx', 'HAL', 0, 0),

('478xxxxxx', 'TavianaGuardg02g17', 0, 0),

('487xxxxxx', 'ergn', 0, 0),

('753xxxxxx', 'dvs felen', 0, 0),

('821xxxxxx', 'Arpikalu', 0, 0),

('884xxxxxx', 'Error', 0, 0),

('929xxxxxx', 'Error', 0, 0),

('945xxxxxx', '[DMR] Layzie', 0, 0);

 

 

That goes on and on until, at a certain stage, I have only players named "Error" in the database....

 

I have NO idea what causes that error, and, as mentioned above, it persists after setting up the server feshly. I really hope not to be ignored again like with my question about the mySQL changes....

 

I must admit that I am sick and tired and frustrated investing SO much time in this server just for getting errors over errors.... In fact right now i am paying (the server) for getting my daily dose of frustration... probably there are cheaper ways to achieve that.

 

Maybe theres someone out there who can identify the cause of those errors... :-( :-(

[Kind-Sir]

Make sure you are running on the server files built for your DayZ Epoch client version (e.g. 1.0.1.5 or 1.0.2)

Do NOT add in any custom files or additions. Test out the files on your server host.

Make sure you are having the @DayZ Epoch and @Dayz_Epoch_Server mods loaded with your server as well as the Arma 2 beta

files.

Another tip:

Please format your posts with the [ code] and [ spoiler] tags.

This will make your posts cleaner to read, and easier to comprehend. Using the enter key will not harm your fingers.

If you will need additional help, I would be glad to offer assistance.

[269091]

Make sure you are running on the server files built for your DayZ Epoch client version (e.g. 1.0.1.5 or 1.0.2)

Do NOT add in any custom files or additions. Test out the files on your server host.

Make sure you are having the @DayZ Epoch and @Dayz_Epoch_Server mods loaded with your server as well as the Arma 2 beta

files.

Another tip:

Please format your posts with the [ code] and [ spoiler] tags.

This will make your posts cleaner to read, and easier to comprehend. Using the enter key will not harm your fingers.

If you will need additional help, I would be glad to offer assistance.

 

Dear Sir, thanks for your kind reply.

 

Indeed I HAVE - of course - the files from 1.0.2. The server is hosted at Nitrado and they offer that update, and I used it.

Indeed I HAVE customizations on that server:

SARGE-AI

fuel script

a few sqf's with custom buildings, called in init.sqf

a few additional vehicle entries in dynamic_vehicle.sqf (I suspect they MIGHT have something to do with the error in 1.0.2 - DID work with previous versions though)

a few database entries with additional vehicles and weapons in traders_DATA and trader_ITEMS (Though still not sure wether the latter is of relevance or not, as my forum post was never answered)

 

All those customizations DID indeed work with 1.0.1.4 and 1.0.1.5.

 

Indeed I COULD invest another one or two days doing nothing else than adding one customization after the other, test it, and then I MIGHT find out what the reason is or - put better - what modification causes the errors (which would not mean the issue will be resolved, btw)

 

BUT: To do that I need not post on this forum!

 

I am posting here to save me from that, because I am NOT intending to do that.

 

Logfiles are, as far as I understood, supposed to deliver information about what causes such errors WITHOUT having to use a trial and error method. Just I MYSELF can't read them properly. So the reason for posting here was to find someone who CAN read them, and hint about the cause of this errors, lay out what those messages actually would tell us about what happens there.

 

PS: I found out that indeed it doesn't harm my fingers to format messages (wouldn't have expected that - glad you told me ;-)). In fact when you wrote that I was busy changing that format, as I was a bit surprised that he board would ignore my line breaks...

 

And I would be glad to accept your assistance in reading those logfile entries properly.... given you know what they are supposed to tell us :-)

[269091]

What I forgot to mention:

 

In game the players names are displayed correctly... Its just the database and the logfile where the errors appear....

[Kind-Sir]

If you are able to upload a clean arma2oaserver.rpt (rename or delete the old one, then start up the server and let it run for about 10 minutes with at least 2-3 players joining) as well as a clean hiveext.log (same deal as the server.rpt), I would happily take a look into them for you.

If nothing pops up within there, I could assist you in figuring out the problem through the server files.

The problem would have to be with the server files as all of the database-related queries are done through the server files.

[kaotix]

I'd just like to point out that I too am having this error, I have a number of mods installed so not sure if there could be something there causing issues?

I've noticed a number of players with the name 'Error' in the SQL but didn't actually notice the name change in game from their player name to Error and then back again. Just about to test it now as I'm actually one of the players who's name is showing as 'Error' in the SQL(?!)

 

I've just noticed that my console no longer logs player joins/disconnects so I can't provide a log. Unless I can change the logging through the HiveEXT.ini?

[269091]

@kaotix - do you run SARGE-AI? Or another mod that requires you to change lines in server_cleanup.fsm?

[kaotix]

I've used other AI but it's currently disabled. Nothing has been changed inside server_cleanup.fsm.

[axeman]

Do any of the mods require changes in DayZ_server.pbo ?

[kaotix]

Some of them required moving certain parts into the main code. The AI I had running was inside the dayz_server.pbo but that's since been removed.

What are you thinking?

[axeman]

Anything that replaces files in the server pbo will break something if they haven't specifically updated for this version of epoch.

Editing the mod code into the new server pbo is safer but still no guarantee. Though sarge is very careful with his variables so conflicts should be less likely. Not really seen the other AI package.

[kaotix]

Is that to say when things have hardcoded paths to files within the server pbo they wont work correctly if I've otherwise redirected them into the mission folder?

I can understand this causing problems. I think the best way around it will be to add things one by one and make sure things are still functioning correctly.

Thanks for the info axeman.

[axeman]

Is more that the addons, designed for old epoch (or other dayz mods), replace files that have been updated by the new epoch release.

Imagine copying bits of your windows 98 windows directory on to a windows 7 pc, probably a good reason why explorer doesn't work quite as well.?

Changing whole updated server or mission files with old code will break stuff, guaranteed.

Addons must be added in line by line, by the creator (or someone who knows how it works), to the new version of the the updated mod (epoch) code and tested before public use. Anybody who says different is probably telling porkies.

Even then Arma Will come and bite you in the arse for daring to tweak it ;)

[kaotix]

I always use the latest files and re-patch what I've added in. So if I need to add additional lines to the fn_SelfActions.sqf file, I'll snag the latest version from the pbo then modify it again since all my code is in blocks.

Not sure if this could still be causing issues?

[kaotix]

Shameless bump as I'm still having this issue on my server.

I've checked that I'm using the latest code even on parts I've modified and even tried not using the mods to test if it still happens and unfortunately it does.

 

What can I provide to help you guys debug this, if anything?

 

Thanks

[axeman]

Have since found that if the player has the same name as one of the built in Arma characters, that you see when logging, they will get that error..

[kaotix]

Can you elaborate? As I've seen some pretty 'odd' player names return 'Error' in the SQL.

For instance, players with clan tags and such.

I've just looked now and none of the 'Error' players have a correct name entry in the SQL (on each entry, dead or alive) so there might be a specific character that the game isn't agreeing with.

[axeman]

Are they trying to use reserved characters such as a single quote. Another thought is it could be an attempt to inject sql using the player name updating to the db.

When you log out there is a name on the screen, have seen John Smith and Matthew Lewis any of the names that appear here are the ones I've heard cause problems. Never tested this and have not looked for the names in arma code.

[kaotix]

Ah right I get you with the John Smith type names. I'd be curious if those were giving issues and why they would cause issues. I'm going to look out for someone with an 'Error' name and find out what their actual in-game name is to compare. I'd love to get to the bottom of this as it's quite annoying!

 

Don't think anyone is trying to inject sql using their name though, I'm pretty sure the names I've seen have been quite generic and not strings of syntax!