SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Member
    Join Date
    May 2003
    Location
    Norway
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Too big Select?!

    I'm having problems with MySQL. I make a table (using MySQL Control Center..), put something in it, save and close, and when I want to return the rows it gives me this:

    "Error 1104: The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=..."

    As long as the table is empty, it does return with success, but when I put something in it and then try, it gives me the error and refuses to return anything at all. Any ideas on how to fix this? I'm pretty new to MySQL, so bare with me.

  2. #2
    SitePoint Zealot
    Join Date
    May 2003
    Location
    Dover, PA
    Posts
    135
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What is your database schema and the query you are trying to execute?
    http://www.statgfx.com

  3. #3
    SitePoint Member
    Join Date
    May 2003
    Location
    Norway
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm using the MySQL Control Center for all of this. That's where I'm getting the error. With PHP it works fine.. I'm just wondering what's wrong with it. =)
    My database is just a newly created test db.
    The CC is simply trying to display all of the rows in the table when this error occurs.

  4. #4
    SitePoint Zealot
    Join Date
    May 2003
    Location
    Dover, PA
    Posts
    135
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I thought you were asking about a query that you were running.

    This sounds like a bug in the control center in that case. I haven't used it. I like the command line.
    http://www.statgfx.com

  5. #5
    SitePoint Member
    Join Date
    May 2003
    Location
    Norway
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Fair enough. I'm not that advanced yet. =) For now I'll try PHPMyAdmin instead, a tip from another forum. Thanks for your assistance, though! =)

  6. #6
    SitePoint Zealot
    Join Date
    May 2003
    Location
    Dover, PA
    Posts
    135
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You shouldn't have any trouble with phpmyadmin. I've used it before and it's very popular (more usage means less liklihood of bugs/problems). This isn't the first time I've heard of some kind of error with Mysql Control Center.
    http://www.statgfx.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •