Bug #398

Customer getting Unknown Table Races error

Added by Walter Pate 4 months ago. Updated 4 months ago.

Status:In ProgressStart date:07/21/2019
Priority:NormalDue date:
Assignee:Jamie Pate% Done:

0%

Category:Lineup GenerationSpent time:6.00 h
Target version:Customer needs to fix

Description

MMRA emailed this issue July 21 2019

issue 398 unknown races table.JPG (637 KB) Walter Pate, 07/21/2019 11:10 PM

issue 398 where to change the race setting.JPG (265 KB) Walter Pate, 07/21/2019 11:22 PM


Related issues

Copied to Support #399: Customer does not think race results are displaying correctly ( Little T Connecticut) In Progress 07/21/2019

History

#1 Updated by Walter Pate 4 months ago

  • Status changed from New to In Progress

Never mind. Still same error. I thought I made progress

Sent from my iPhone

On Jul 20, 2019, at 10:46 PM, Michigan Midgets <> wrote:

Said found 4 errors.
So I go to heat grids, don’t overwrite and it doesn’t show an error but doesn’t bring in any grids as if there was no info. I tried again with overwrite selected and it gives me the same error

Sent from my iPhone

On Jul 20, 2019, at 10:41 PM, Michigan Midgets <> wrote:

I will try that. I have not yet. We have a race tomorrow if it doesn’t rain.

Sent from my iPhone

On Jul 20, 2019, at 10:40 PM, Walter Pate <> wrote:

Sorry about this reply, my phone sent it before I finished typing and correcting !

Walter Pate

Maximum Overdrive Software Company

1-604-576-6631

On 2019-07-20 7:36 p.m., Michigan Midgets wrote:

<image1.jpeg>

Sent from my iPhone

On Jul 20, 2019, at 10:14 PM, Walter Pate <> wrote:

Jen, email me at , or call me at 1-604-576-6631.
some eWhat version of Moscore-QM are you using ( it is displayed in the center of the top toolbar

Get Outlook for Android
Hi Jen,

I fixed the link on the website so it should work now. In dev.moscore.com you need to create an Issue and set it up as customer support.

Have you tried going to Tools/Archive\Repair then Repair All Tables?

If we can set up a time and phone number connection we may be able to remote connect to your computer to see if we can find the issue

Walter Pate

Maximum Overdrive Software Company

604 576 6631

On Sat, Jul 20, 2019 at 5:02 PM -0700, "MMRA" <> wrote:

Walter,

We tried to use your website to contact tech support with no luck - received error message for mail.

We are receiving the following error message after qualifying and going to print forms, grids, heats, heat grids.

SQL Error: Unknown table 'races' in order clause.

We did do an update to see if it would fix the problem which was unsuccessful.

Please help!

Thank you
Jen Venezia
MMRA Secretary
Clarkston, MI

#2 Updated by Walter Pate 4 months ago

  • Tracker changed from Support to Bug
  • Assignee changed from Walter Pate to Jamie Pate

Hi Jen,

It looks like there is an issue with the format that you have created for this race. ( Club race W/Qualifying) We are looking into it to try to resolve this issue.

In the mean time I have a work around so you can run your race tomorrow!

If you use the Club race w/Qualifying mode, register the cars then run your normal qualifying ,

After Qualifying is complete print out your Qualifying pages.

Then write numbers on the sheet beside each driver in order of qualifying results (from 1 to 41 if 41 cars entered )

Go to Quick Edit Registered cars and edit the Draw number for each driver to to match the numbers that you reassigned to each driver ( you can sort by class, or Sort by draw number by clicking on the title at the top of the table)

Next change your Format to one that uses Random draw for Qualifying mode

after you have entered all the draw numbers go to Print Forms/Grids/Heats/Heat Grids... it should work

call us at 1-604-315-1509 if you have any questions

Walter Pate

Maximum Overdrive Software Company

#3 Updated by Walter Pate 4 months ago

I did an MYSQL Query on the MMRA issue and found they had the Tie Breaker in the Main event setup is set to 'Race Number', but the number of heats is only set to 1
If they change the Tie Breaker to Random,registration order or Draw then it will work. see the JPG images attached

#4 Updated by Walter Pate 4 months ago

  • Copied to Support #399: Customer does not think race results are displaying correctly ( Little T Connecticut) added

Also available in: Atom PDF