I'm getting a couple of these errors when I open the 'Team' tab in the PCM Editor (the official one). I loaded the database with the Full Editor v4 and noticed something odd:
DYN_team does indeed have these values (for instance Acqua & Sapone uses 64, 37 and 37 for flkDequipment_marques_roue, cadre and helmet) but in the STA_equipment_marques I indeed don't see the value 37 nor the 64.
Am I missing something, or is my database not proper? It looks like the DYN_team table refers to the new content, but the STA_equipment-tables don't seem to be updated. Can someone explain this to me?
I'm not familiar with this editor, so I might make wrong assumptions, but I feel that this table should be updated as well, no?
STA_equipment_marques is for the brands that you see in the equipment selection menu. However, the marques (in STA_equipment) is also used for linking the equipment to the teams without this showing up in the menus. Therefore, there's a difference between the marques used in STA_equipment and those you can see in STA_equipment_marques.
This DB was made using the Full Editor V4. I haven't checked whether it's compatible with other editors.
Thank you for the reply. I think I understand what you're saying, but correct me if I'm wrong ;-)
STA_equipment_marques - Equipment screen in-game. STA_equipment - Equipment linked to specific teams.
Seeing how the official editor uses the STA_equipment_marques as the foreign key-reference in the DYN_team table, it hiccups because the IDs from the fkIDequipment column do not match the ones in the STA_equipment_marques.
I guess the official editor does not make a difference between those 2 tables, whereas the PCM-DB does. I guess that makes them incompatible.
STA_equipment contains all the equipment in the game. _marques contains the different brands, under which the equipment from STA_equipment is listed.
It's not compatible, because we use the non-used IDs from _marques to link the equipment from STA_equipment to the teams in DYN_team. So when the official editor looks for the brands, it notices that there's a lot of numbers in STA_equipment which are not in STA_equipment_marques - but as said, that's because those numbers are used for linking the equipment to teams, not for making brands which are visible in the game.
