In a profile of the user gives out errors:

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 query: SELECT DISTINCT avatar, avs.name, avs.weight FROM avatar_selection avs LEFT JOIN users u ON u.picture = concat (and #039; files/avatar_selection / and # 039;, avs.avatar) LEFT JOIN avatar_selection_roles avsr ON avs.aid = avsr.aid WHERE u.picture IS NULL AND (avsr.rid IS NULL OR avsr.rid IN (2,3)) ORDER BY avs.weight, avs.name, avatar LIMIT 0, 20 in a file /sites/all/modules/avatar_selection/avatar_selection.module in line 442.

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 query: SELECT count (distinct avs.aid) FROM avatar_selection avs LEFT JOIN users u ON u.picture = concat (and #039; files/avatar_selection / and # 039;, avs.avatar) LEFT JOIN avatar_selection_roles avsr ON avs.aid = avsr.aid WHERE u.picture IS NULL AND (avsr.rid IS NULL OR avsr.rid IN (2,3)) in a file /sites/all/modules/avatar_selection/avatar_selection.module in line 440.

Comments

stella’s picture

stella commented
Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

what database type and version are you using?

ivcons’s picture

ivcons commented

MySQL 5.0.77

ivcons’s picture

ivcons commented
Status: Postponed (maintainer needs more info) » Active
stella’s picture

stella commented
Status: Active » Closed (cannot reproduce)

The sql query is okay, though the 'concat' part looks a bit strange but I think that's just a formatting/pasting issue. The error itself is related to the number of tables joined to, but it's only 3 which should be well within normal limits. Have you tried doing as the message suggests - i.e. increasing MAX_JOIN_SIZE in your mysql config? Please try increasing that and trying again.