• This is a reminder of 3 IMPORTANT RULES:

    1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.

    2- Do NOT post in other languages. English-only.

    3- Crack/Warez/Piracy talk is NOT allowed.

    Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.

    Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.

    Thank you!

DB Master 14/15 Problems

9-Ball

Youth Team
I'm trying to create 6-700 players to add to the game.

I've edited players.txt, teamplayerlinks.txt and playernames.txt in Excel, after exporting tables from the DB via DB Master.

I can successfully import the players.txt and teamplayerlinks.txt (and regen using i68 Controller) and they display properly in DB Master 14 (i.e. the edited tables show up) and in game, where my created players show on the correct teams with the correct stats.

The problem is all my created players have blank/empty names. I am 101% sure the players table has the correct firstname and lastname values.

I thought I'd solved this before by simply not knowing to hit Reset Squads in the game editing menu, but after completing all my edits and retesting I see now the playernames.txt table just isn't being imported or updated and the players show up in game but nameless.

Anyone else run into this and know of a fix? Is there a hard limit to the playernames.txt table's number of records? I have 24547 versus 23162 in the vanilla DB. The max value for the playernames table seems to be 28000 according to the .xml file so I don't think this is the issue.

I've also tried adding the names to the dcplayers table but still no display in-game.

Any advice or suggestions much appreciated.
 

bangus

Starting XI
9-Ball;3756913 said:
I can successfully import the players.txt and teamplayerlinks.txt (and regen using i68 Controller)
db files do not need to be regenerated after editing. Edits need to be saved of course, but regenerating is unnecessary. Try not regenerating and see if the names show up.

Every time someone here posts this same issue - names not showing up in the db - it turns out they're using moddingway db or some other edited db. I've been editing with the default db since day 1, and I've added names to the playernames table with no issues. Use the default db if you're not already. Also, if a table isn't being imported back into the db, it's because there is an error in the table. You often won't get an error message, it just won't import.

Past all that, sounds like you need to do some trouble-shooting testing. If no player names are showing up in-game, then the issue has to do with your procedure. So start again with the default db, then add one player. Go into the game and see if that player shows up. If he didn't then you're doing something wrong. If he did, then test again by adding 5 more players. Check again. Do they show up in-game or not? This is the fastest way to track down the specific issue.

This is the correct forum for this thread BTW. ;)
 

9-Ball

Youth Team
Hey Bangus,

thanks for the feedback.

I started with the DB file posted in this thread, soon after the game was released. I've never used Moddingway DB or any other variant. I guess the one posted here (this thread: http://www.soccergaming.com/forums/showthread.php?t=190747) isn't somehow default?

I'll follow your advice here. I've never tried it without the regeneration as I believed that was necessary. If it isn't for the DB then what's regeneration for, generally? Heh.

It sounds like I also need to go through my playernames table for errors. Do we know if any unusual characters may cause problems there? I don't have anything obviously odd but will check. I know the structure is good.

It may indeed mean going a few rows at a time to see but then I can't get anything to import over the playernames table. Back to testing.
 

9-Ball

Youth Team
Quick thought: I noticed my teamplayerlinks table has a lot of duplicate player squad numbers. Any known issue on that? I have plenty of cases where one player is added to a team with a unique squad number, but in some cases given I cut and paste the data, players share a number within the same squad. Again, doesn't cause a crash but I wondered if it might factor in to the lack of player names (seems unlikely) or cause other (known) issues.
 

bangus

Starting XI
9-Ball;3757114 said:
Quick thought: I noticed my teamplayerlinks table has a lot of duplicate player squad numbers.
That's because many players are linked to two teams, league and national. EDIT: Do you mean team id numbers or jersey numbers?

I'm not sure what you mean by looking for errors in the playernames table, how do you recognize/know what is and isn't an error?

It seems to me you need to trouble shoot one step at a time. I strongly suggest you start again as a test, add only one player, then see if the player shows up in-game. If it does, add a few players. Then try 20, then 50. Keep checking to make sure they show up, and take note if and when they don't.

You can make all this easier by deleting all the free agent players, then create your new players as free agents. That makes it easy to look in the free agent pool, to check to see if your added players are there each time.
 

bangus

Starting XI
Question: Are these new players you're adding, on new teams you've created and added? If so, maybe that's part of the issue. I've added players with new names without issues, but I'm only adding them to default teams or the FA pool.
 

9-Ball

Youth Team
Bangus,

these are only new players, added to existing teams or the FA pool. No new teams. I aim to do that but it's very much on the back burner till I can get this working.

I went back to a new DB and I'm trying to add 1 at a time to see if I hit a problem, or when. The odd thing I added 50 as a first test and all worked, so, something goes amiss here eventually, I am guessing.
 

9-Ball

Youth Team
Making progress on this now. I have the players added, names working and teamplayerlinks working.

I find my players are all headless, however. Short of secret French Revolutionary types in the database, I'm wondering why they are headless. I'm assuming 'hashighqualityhead' and 'headtypecode' factor in here but I believe I've copied those values from fully headed players as a test - still no heads. If someone could point me in the right direction by explaining the value ranges for those two columns in the players table as well as anything else that might cause this, I'd appreciate it.

Maybe easier to fix with CM15 rather than editing Excel tables?
 


Top