I24 Common Setup Issues

From OuroDev
Revision as of 23:04, 25 April 2019 by Echo-99 (talk | contribs)

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; }

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;"