Final Furlong Forum
Final Furlong
Nov. 22, 2021 6:00am

Final Furlong Forum - A Quick Question

Welcome, Guest. Please login or register.
November 22, 2017, 10:00:47 AM

Home Help Search Calendar Login Register
Final Furlong Forum  |  General  |  Questions  |  Topic: A Quick Question
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: A Quick Question  (Read 384 times)
Shorty
Guest
« on: April 13, 2011, 09:12:41 PM »

I am trying to enter my horse in a race but all I get is

racequery: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND h.Leased = 0) OR (l.Leaser = AND h.Leased = 1 AND l.Start <= '2015-04-14')' at line 13
SELECT r.ID, r.Date, r.Num, t.Name AS Track, rt.Type, r.Name, rg.Grade, ra.Age, r.Distance, t.DTSC, r.Purse, r.Gender, rg.Abbr, COUNT(re.Horse) AS Entries FROM ff_races r LEFT JOIN ff_nomraces nr ON r.ID = nr.Race LEFT JOIN ff_trackdata t ON r.Location = t.ID LEFT JOIN ff_race_types rt ON r.Type = rt.ID LEFT JOIN ff_race_grades rg ON r.Grade = rg.ID LEFT JOIN ff_race_ages ra ON r.Age = ra.ID LEFT JOIN ff_raceentries re ON r.ID = re.Race LEFT JOIN ff_horses h ON re.Horse = h.ID LEFT JOIN ff_leases l ON l.Horse = h.ID WHERE r.Date > '2015-04-14' AND r.Date <= '2015-05-14' AND r.ID IS NOT NULL AND nr.Race IS NULL AND (((h.Owner = AND h.Leased = 0) OR (l.Leaser = AND h.Leased = 1 AND l.Start <= '2015-04-14')) OR re.Horse IS NULL) AND (r.Gender != 'F' OR r.Gender IS NULL) AND (ra.Age LIKE '%+' OR ra.Age LIKE '%4%') AND (rt.Type = 'Allowance' OR rg.Grade = 'Ungraded' OR rg.Grade = 'Grade 3' OR rg.Grade = 'Grade 2' OR rg.Grade = 'Grade 1') GROUP BY r.ID ORDER BY r.Date, Track, r.Type

What can I do?
Logged
Mintano
Guest
« Reply #1 on: April 13, 2011, 09:48:39 PM »

Report it as a bug here.

http://www.finalfurlong.org/bugs.php
Logged
Shorty
Guest
« Reply #2 on: April 14, 2011, 02:02:27 AM »

Thank you!  ;D
Logged
Pages: [1] Go Up Print 
Final Furlong Forum  |  General  |  Questions  |  Topic: A Quick Question « previous next »
 
SMF 2.0.13 | SMF © 2017, Simple Machines
Final Furlong Forum, A Quick Question - Theme by Mustang Forums