Forums FAQForums FAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Login to check your private messagesLogin to check your private messages   LoginLogin 

Machine location search errors.
 
This topic is locked you cannot edit posts or make replies    DDR Freak Forum Index -> Site Feedback
View previous topic :: View next topic  
Author Message
MRG06
Basic Member
Basic Member


Joined: 08 Apr 2007
0. PostPosted: Wed Nov 05, 2008 12:23 pm    Post subject: Machine location search errors. Reply with quote

Is it me or is everyone else having the same problems searching for machine locations? Every time I put in a zip code or a city, I'll come to a page that looks like this. error in query: SELECT ML_Locations.locationID, ML_Locations.name, ML_Locations.city, shortName, miles, stateAbbr, modifyID, Location2.status as status FROM ML_Locations, ZipCodeDist left join ML_Machines on ML_Locations.locationID = ML_Machines.locationID left join versions on ML_Machines.versionID = versions.versionID left join ML_Modifications on ML_Modifications.locationID = ML_Locations.locationID left join ML_Locations as Location2 on Location2.locationID = ML_Modifications.modifyID left join ML_States on ML_States.stateID = ML_Locations.stateID WHERE ML_Locations.status='approved' and ML_Locations.zip5=zip2 and zip1='32569' and miles < 10 order by miles
Back to top
View users profile Send private message
VxJasonxV
Maniac Member
Maniac Member


Joined: 08 Feb 2002
Location: Castle Rock, CO
1. PostPosted: Sun Nov 09, 2008 9:40 am    Post subject: Reply with quote

It's not just you, but it's going to require a bit more involvement for me to figure out the root cause.

Just letting you know.
_________________


Amusing Pictures: lolddrfreak | Road of LoQ
Back to top
View users profile Send private message Visit posters website Xbox Live Gamertag
VxJasonxV
Maniac Member
Maniac Member


Joined: 08 Feb 2002
Location: Castle Rock, CO
2. PostPosted: Sun Nov 23, 2008 9:54 am    Post subject: Reply with quote

You may have already seen it, but: It's been fixed
_________________


Amusing Pictures: lolddrfreak | Road of LoQ
Back to top
View users profile Send private message Visit posters website Xbox Live Gamertag
Display posts from previous:   
This topic is locked you cannot edit posts or make replies    DDR Freak Forum Index -> Site Feedback All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2 © 2001, 2002 phpBB Group