Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

API returned an error: SQLSTATE[42000] The SELECT would examine more than MAX_JOIN_SIZE rows #7729

Closed
GeoffAU opened this issue Apr 21, 2015 · 2 comments
Labels
answered For when a question was asked and we referred to forum or answered it. Bug For errors / faults / flaws / inconsistencies etc.
Milestone

Comments

@GeoffAU
Copy link

GeoffAU commented Apr 21, 2015

Version 2.13.0-b2 and 2.13.0-b3

API returned an error: SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay at Pdo.php:234

@mattab
Copy link
Member

mattab commented Jul 14, 2015

@GeoffAU can you try again in 2.14.1-b2 (our latest beta) where this bug may be fixed? if it's not fixed, please let us know which URL returns this error.

@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Jul 14, 2015
@mattab mattab changed the title API returned an error: SQLSTATE[42000] API returned an error: SQLSTATE[42000] The SELECT would examine more than MAX_JOIN_SIZE rows Jul 15, 2015
@mattab mattab added this to the Mid term milestone Jul 15, 2015
@mattab
Copy link
Member

mattab commented Jul 15, 2015

We need more information, hopefully @GeoffAU you can send us bit more info here 👍

@mattab mattab closed this as completed Sep 11, 2015
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Sep 11, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it. Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Development

No branches or pull requests

2 participants