training error?

when i tried to give my horses a workout I recieved this message at the bottom of the screen where the horses would typically be .

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
SELECT h.Name AS HorseName, (2012 - DATE_FORMAT(h.DOB, ‘%Y’)) AS Age, h.Gender, h.ID AS HorseID, h.EnergyCurrent AS Energy, h.Fitness, e.Equipment AS DefaultEquip, h.DefaultJock1 AS DefaultJock, ts.*, tsh.Schedule AS ID2, re.ID AS RaceEntry, track.Name AS TrackName, h.DefaultWorkoutTrack FROM ff_horses h LEFT JOIN ff_training_schedules ts ON h.ID = ts.Horse LEFT JOIN ff_training_schedule_horses tsh ON h.ID = tsh.Horse LEFT JOIN ff_equipment e ON h.DefaultEquip = e.ID LEFT JOIN ff_raceentries re ON h.ID = re.Horse LEFT JOIN ff_trackdata track ON h.Location = track.ID LEFT JOIN ff_horse_status st ON h.Status = st.ID LEFT JOIN ff_leases l ON l.Horse = h.ID, ff_users u WHERE ((h.Owner = u.ID AND h.Leased = 0) OR (l.Leaser = u.ID AND h.Leased = 1 AND l.Active = 1)) AND st.Status = ‘Racehorse’ AND h.InTransit = 0 AND track.Name != ‘Farm’ AND u.Username = ‘turtlefirOXO’ GROUP BY h.ID ORDER BY h.Name

I’m getting the exact same thing.  ???

Please no me too posts.

This will get fixed when I get a chance.  In the meantime, chill out.


hmm. the page comes up but when i train i get this:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8g DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/ Server at Port 80

What is the URL when you get that page?  I successfully ran workouts on my horses this morning.

I just ran i workouts that i need to except one. Silver n Shine. If I work any other horse it will run but if it is him alone or he is included in a group it refused to run and i get that page again.

This is the url it gives in the address bar: