SMF Support > SMF 2.0.x Support

sql error

(1/4) > >>

tjl:
Here is the error:


--- Code: ---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
--- End code ---

And here is the offending query:


--- Code: ---SELECT b.id_board, bp.add_deny
FROM smf_board_permissions AS bp
INNER JOIN smf_boards AS b ON (b.id_profile = bp.id_profile)
LEFT JOIN smf_moderators AS mods ON (mods.id_board = b.id_board AND mods.id_member = 0)
WHERE bp.id_group IN (-1, 3)
AND bp.permission = 'moderate_board'
AND (mods.id_member IS NOT NULL OR bp.id_group != 3) AND (FIND_IN_SET(-1, b.member_groups))
--- End code ---

Is there any way I can fix this? Perhaps reducing the number of rows queried? If so, would this require refactoring of the query? And if that is true, what would be the correct way to refactor it?

Thanks for your help.

kreativekarma:
How many members do you have?

tjl:
There are 366 members registered.

kreativekarma:
Do you have access to the mysql configuration file?

tjl:
I would need to contact my host. What specifically are you interested in?

Navigation

[0] Message Index

[#] Next page