Results 1 to 4 of 4

Thread: all you need is n00bs....like me

  1. #1
    Join Date
    Apr 2003
    Location
    Nürnberg
    Posts
    2

    all you need is n00bs....like me

    K, first post ever on a mysql thread:
    I installed mysql, php, and jana server2 (for the first time)
    installed the command center for mysql and played a bit. now after a few tutorials i did the first database but when i try to querry it i get this: (I can still querry from dreamweaver mx - but cannot insert any more data into the table from mysql)

    "[server] ERROR 1104: The SELECT would examine too many
    records and probably take a very long time. Check your
    WHERE and use SET OPTION SQL BIG SELECTS=1 if the SELECT
    is ok"

    i got the set sql big selects to 1 but still nothing..

    thank you guys for the attention.
    cheers!

  2. #2
    Join Date
    Apr 2003
    Location
    Nürnberg
    Posts
    2

    i got to mention this

    that from the command line (mysql.exe) querry works just fine. it is just the control center that gives me this nice error.

    i have red on a sql forum that this is a bug in the new 0.9.1 beta and it gives some sort of remedy:

    "Edit your server and in the "MySQL Options" tab, set a reasonable value
    for "Automatically limit SELECT queries to" and set the value for "Maximum

    Join Size" to 1000000. That should fix these problems"

    I find this message criptic and don't know where the mysql options tab is , searched for it ...but nothing.

    ...thought it would help.

    George

  3. #3
    Join Date
    Apr 2003
    Posts
    1
    Can't say that I know a lot about Command Center but a really good alternative to that GUI is MySQL-Front. I'm pretty sure it has all the features of Command Center. However the development for this program has been discontinued. The last release is still available for download, you can get it at http://mysqlfront.sstienemann.de/.

  4. #4
    Join Date
    Apr 2003
    Location
    London
    Posts
    1
    HI, no expert myself having just started out using MySQL. However, using winmysqladmin.exe, if you go to the variables tab then you can change the max_join_size parm.

    Hope it helps, Col

Posting Permissions

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