Skip to content
English
More support Sign in
Contact us
  • There are no suggestions because the search field is empty.

"Manage Bookings" Does Not Show Heats For Today's Races

Search

"Manage Bookings" Does Not Show Heats For Today's Races

Causes

This is most likely caused by date settings being incorrect for an Australian or British server.

These date settings include:

  • The server's culture (it affects the time in the bottom-right of the taskbar)
  • The SQL culture
  • The date format in c:\clubspeedapps\api\config.php
  • The date format in c:\clubspeedapps\admin\laravel\app\config\config.php

Let's check these one by one.

Note: A main engine and SQL server restart will be required. Follow these steps while the track is not open or running. The steps can be run in about 15 minutes.

Server Culture

  • Click the Start button.
  • Type "region".
  • Click "Region and Language".
  • Check the Format dropdown. If it's set to "English (United States)" for a non-American server, set it to whatever is appropriate. (Ex. "English (Australia)".)
  • Save your changes.

SQL Culture

  • Open SQL Server Management Studio.
  • Expand "Security", then "Logins".
  • Right click NT AUTHORITY\NETWORK SERVICE, and select Properties.
  • If at a non-American track, change default language (at the bottom) from English to the language that corresponds to their date format. (Ex. "British English", which works for both England and Australia.)
  • Save your changes. They won't take effect until a SQL restart.

API Config

  • Open c:\clubspeedapps\api\config.php
  • For British and Australian tracks, ensure that the dateFormat line is as follows:
  • $dateFormat = 'Y-d-m';
  • For American tracks, it should be: $dateFormat = ''Y-m-d';
  • Save your changes. They are immediate.

Note: A typo here can break the entire API. Be careful! :)

Admin Config

  • Open c:\clubspeedapps\admin\laravel\app\config\config.php
  • For British and Australian tracks, ensure that the dateFormat line is as follows:
  • 'dateFormat' => 'Y-d-m',
  • For American tracks, it should be: 'dateFormat' => 'Y-m-d',
  • Save your changes. They are immediate.

Restart SQL

  • Do not do this if the track is live. Wait for them to close.
  • Close SQL Server Management Studio.
  • Click the Start button.
  • Type "services", and click Services.
  • Scroll down to SQL Server (MSSQLSERVER) (may vary slightly), right click it, and select restart. It should be a service set to Automatic and currently running when you see it.

Restart Main

  • Do not do this if the track is live. Wait for them to close.
  • Open FireDaemon.
  • Right click "Club Speed Main Engine".
  • Click restart.

 

Related Articles