I24 Common Setup Issues

How to debug a few common issues that can occur during/after setup...

ERROR: Player.txt error

When running mapserver.exe you will come across an error pertaining to player.txt.

• Player.txt error message:

  [need image]

• Solution: In MapServer\srv\srv_init.c comment out line #437:

  // playerCreatedStoryArc_GenerateData();

ERROR: Loading costumes

• If you really want to use the I24 costumes.bin with the leaked source, delete "InternalProducts" from ParseMaskSet[], ParseCostumeCostumeTexSet[], ParseCostumeCostumeGeoSet[], and ParseCostumeBone[] in Common/gameData/costume_data.c and fix whatever compile errors you get as a result
• Need to update client side too
  • Results before:
  • After modification:

ERROR: Loading templates for Dbserver.exe

You will begin getting errors once you try to launch dbserver.exe around “Loading Templates….”. To resolve this issue, you must run mapserver.exe -productionmode -templates to generate new templates and attribute files (for any missing attributes).

Templates location: Root_Directory_ServerFiles\\server\db\templates. Folder should look like the following:

[Need image]]

Location of template files:

Additionally, you will need to create a coh_data\attributes directory in your C:\ drive. The mapserver.exe will drop .attribute files that will need to be moved to the templates folder mentioned before (templates location).

Contents of attributes folder after mapserver.exe runs successfully:

In case you just want to jump right in, [here are the template files].

Also, [here is the maps.db file].

ERROR: Version difference between client/server

Add version.ini in the server executable directory, containing:

Version=XXXXX

where XXXXX is the client version.

ERROR: Character slot issue

in dbserver\clientcomm.c:

• Change lines #1045-46 to:

  if (con)

  { con->logged_in = 1; con->slot_count = 20; }

Users have been able to bypass this using accountStatus = 1 and VIPShard = 1.

UPDATE [cohauth].[dbo].[user_account] SET [subscription_flag] = 1 WHERE [account] = 'youraccountnamehere'

SQL: Setting up SQL database for servers

Requirements: Microsoft SQL Express edition or SQL Server (2012 recommended)

CoH DB Schemas are located here.

SQL: Invalid precision values

Connecting to the SQL server with dbserver produces “Invalid precision value” errors.

• Don’t use the “SQL Server” ODBC driver in your connection string in servers.cfg.
• Instead, use “SQL Server Native Client XX.0” (depending on what version you have installed, check Data Sources (ODBC) for possible Drivers)

SQL: Acquiring ODBC driver version and setting it up in servers.cfg

• To get your OBDC driver version, you must open ODBC Data Sources in Windows.
  • Once ODBC Data Source Administrator is open, navigate to the “Drivers” tab as shown:

  [Need image]

• After acquiring the SQL Server Native Client version you have, you will need to edit the servers.cfg located in your Root_Directory_ServerFiles\ specified in <gamedatadir.txt>\server\db directory. The following line needs to be edited with your SQL Server Native Client driver:

SqlLogin "Driver={Your_DriverVer};server=127.0.0.1;database=cohdb;trusted_connection=Yes;"