benedmunds/CodeIgniter-Ion-Auth — Issue #154: $this->ion_auth->get_users(); generating database error 1104
Author: cereb
Created: 2012-01-12 15:57:06+00:00
State: open

When calling $this->ion_auth->get_users();
I am getting,
"Error Number: 1104

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"
Now I have checked the MAX_JOIN_SIZE and it is set at 900,000 so that is quite high and there are 2500 users in the system. I am guessing it is something to do with the JOINs but am not 100% sure how to fix this.

David