speedscreens missing lap times not updating racers times

Speedscreens Not Updating/Showing Lap Times

Give an introduction to the topic of this How-to article. For example, let's consider that this article explains how to use article template

Create a step-by-step guide

• Step 1: SQL Script
• Step 2: PHP Version of CS-Speedscreens

Step 1: SQL Script

// The below SQL script has fixed this issue in the past.

• -- Note: PDO does NOT accept GO statements, and CREATE VIEW must be the first statement in a batch
  CREATE VIEW [dbo].[ActiveRaceLapCount_V] AS
  SELECT
        hm.TrackNo
      , rd.HeatNo
      , COUNT(DISTINCT rd.ID) AS LapCount
      , COUNT(DISTINCT RacingDataSector.RacingDataSectorID) AS SectorCount
  FROM dbo.HeatMain hm
  INNER JOIN dbo.RacingData rd
      ON rd.HeatNo = hm.HeatNo
  LEFT JOIN RacingDataSector
      ON rd.HeatNo = RacingDataSector.HeatNo
  WHERE
      hm.HeatStatus = 1 -- Race currently running
  GROUP BY
        hm.TrackNo
      , rd.HeatNo;  
  
  
• If the above script returns an error that the view already exist delete the view in SQL and run the script again.
  
  
  
  
  STEP 2:
• Check that the PHP Version of CS-Speedscreens is up-to-date in IIS. 
  • If it is not up to date, and you are unsure of how to update it reach out to co-workers/supervisors.

Related Articles