Opac- search error - (SELECT would examine more rows than MAX_JOIN_SIZE)

Help
joaodf
2014-03-28
2014-05-14
  • joaodf

    joaodf - 2014-03-28

    Hi,

    Now a days Justhost & Bluehost are putting restrictions on mysql joins.

    When I do a long query in the OPAC, mysql returns the following error

    "The SELECT would examine more rows than MAX_JOIN_SIZE, check your WHERE and use SET SQL_BIG_SELECTS = 1 or SET MAX_JOIN_SIZE = # if the SELECT is okay"

    For example, I search for "Quem roubou o meu queijo?"

    more details

    https://www.evernote.com/shard/s246/sh/a40f0275-31c4-4203-bc61-7e067262a48c/a1bf68043e1ae2f6f4e7f3980d2d9642

    Here there is a solution ('SET SESSION SQL_BIG_SELECTS = 1'.)

    https://drupal.org/node/361967

    But I do not know where to place this code. Can anyone help me solve this problem?

    Sorry my bad english.

     


Anonymous

Cancel  Add attachments





Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks