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
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, webmaster@finalfurlong.org 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/5.0.2.2635 Server at www.finalfurlong.org Port 80
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.
