homepage Welcome to WebmasterWorld Guest from 54.196.63.93
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Database Search Error - This is maddening - Please advice
Database search error
3Mice

10+ Year Member



 
Msg#: 3822024 posted 4:16 pm on Jan 8, 2009 (gmt 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]

 

coopster

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



 
Msg#: 3822024 posted 5:39 pm on Jan 8, 2009 (gmt 0)

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved