Thread: OP site error
View Single Post
  #1  
Old 11-01-2010, 12:34 PM
Animewolf17 Animewolf17 is offline
Jonin
 
Join Date: Jun 2006
Posts: 1,748
OP site error

Upcoming tournaments on the OP site is messed up I tried to lookup my locals schedule for this month and this is what came up

Query failed SELECT locationwebsite, locationphone, gametypeid, tournamentname, locationname, locationadd1, locationadd2, locationcity, locationstate, locationzip, tournamentlevel, date_format(tournamentdate , '%m/%d/%Y %l:%i %p') as tournamentdate, meijin, userfirst, userlast, notes FROM `tournaments` inner join locations ON tournaments.locationid = locations.locationid left outer join users ON users.userid = tournaments.meijinid WHERE (locationcountry='USA') AND (locationstate LIKE '%TX%') AND (tournamentdate >= '2010-11-01') AND (tournaments.approved ='1') AND (tournaments.gametypeid ='2') AND (locationname LIKE '%The Castle%') AND (tournaments.tournamentlevel LIKE '%%') ORDER BY tournamentdate
Reply With Quote