Players don't save to Account Table

[Ethos 3]

I have an issue where players don't save to the account table in my exile database, they show up in players and recent players but if they disconnect and reconnect they have the whole "spawning as a rabbit" business where they are at feet level on the map and cant move around etc. if they commit suicide and try to re-spawn the game kicks them saying error character request timed out.

MySQL is not in strict mode either lol, any suggestions? if you need more info I'd be happy to provide, just let me know what you need.

currently the server is running Exile and CBA with DMS missions

[Ethos 3]

bump?

[~EL BARTO~ 55]

Only players or admin's too? So finally all players?

Be sure ur extdb is running and exile is connected to the db...all tables are implemented?

Which exile version are running?

[Ambu5h 31]

We are having the exact same problem.
Also running CBA. Seen this comming back a few times before in other topics that CBA might be the culperate.
Gonna have to test this tomorrow.

Running Tanoa with latest Exile version.
Mods: CBA, CUP w/v/u, Ryan zombies, DMS, Zupa Capture Points with infistar.
 

[22:03:28:282877 +00:-1] [Thread 109200] extDB2: SQL_CUSTOM_V2: Error No Custom Call Not Found: Input String setAccountMoneyAndRespect:70:320:76561198057206805
[22:03:28:282919 +00:-1] [Thread 109200] extDB2: SQL_CUSTOM_V2: Error No Custom Call Not Found: Callname setAccountMoneyAndRespect

These errors are the only ones showing up in the DB log.

Edited July 26, 2016 by Ambu5h

[Ambu5h 31]

Additionaly, the problem lies within the DB where the account table is not filled in but the players table includes the player and its statistics.
This will make them spawn underground with a blanco character.

Made this Query to give you insight over who cant connect.
 

SELECT * FROM `player` WHERE `account_uid` IS NOT NULL AND NOT EXISTS( SELECT `uid` FROM `account` WHERE `uid` = `account_uid`)

This gives you all the players that are pressent in the Players table but NOT in the accounts table.

[second_coming 836]

I stopped most of the rabbit spawning by inserting this at the top of the mission file init.sqf

http://pastebin.com/KpapFQBF

[second_coming 836]

42 minutes ago, Ambu5h said:

Additionaly, the problem lies within the DB where the account table is not filled in but the players table includes the player and its statistics.
This will make them spawn underground with a blanco character.

Made this Query to give you insight over who cant connect.
 

SELECT * FROM `player` WHERE `account_uid` IS NOT NULL AND NOT EXISTS( SELECT `uid` FROM `account` WHERE `uid` = `account_uid`)

This gives you all the players that are pressent in the Players table but NOT in the accounts table.

a simpler way of doing that is:

SELECT * FROM player WHERE account_uid NOT IN (SELECT uid FROM account)

 

[Ambu5h 31]

17 minutes ago, second_coming said:

a simpler way of doing that is:

SELECT * FROM player WHERE account_uid NOT IN (SELECT uid FROM account)

 

Haha alright... well back to getting some SQL lession i guess :p.
Ill try and add that to the mission init.sqf see if that changes some things.

THX ALOT of the reply! Very limited stuff seems to be available on this problem.

Edited July 29, 2016 by Ambu5h

[Kobayashi 86]

You could create a trigger on the player table to just handle it

delimiter //
CREATE TRIGGER `player_before_insert` BEFORE INSERT ON `player` FOR EACH ROW BEGIN
  if new.`account_uid` not in (select distinct `uid` from account) then
  insert into account (`uid`, `name`) values (new.`account_uid`, new.`name`);
  END IF;
END
//
delimiter ;

This will make an entry in account if the uid doesn't exist already. You may need to change this up though, just an example of how to do it.

[[SKS]Goliath 37]

how can you resolve the this error