Welcome to WebmasterWorld Guest from 54.162.205.151

Forum Moderators: open

Message Too Old, No Replies

Database Search Error - This is maddening - Please advice

Database search error

     
4:16 pm on Jan 8, 2009 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 28, 2003
posts: 43
votes: 0


My friend owns this site but he has been unable to use it cause when you do a search on the site, you get this error
==
Ooops!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
===

I have heard it could be a problem to do with indexes in the database tables which im not sure what that means. Please advice me on what could be the problem and the solution to this

kind regards
3Mice

[edited by: coopster at 5:30 pm (utc) on Jan. 8, 2009]
[edit reason] no personal urls please TOS [webmasterworld.com] [/edit]

5:39 pm on Jan 8, 2009 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12541
votes: 1


Did you check the manual [dev.mysql.com] yet?