CiviCRM Community Forums (archive)

When using the "Fancy Participant Listing" custom search, and some smart groups made on Event data, I'm getting this error


Database Error Code: Too many tables; MySQL can only use 61 tables in a join, 1116
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => Select  contact_a.id            as contact_id  , p.id as participant_id, '' as participant_link,
contact_a.sort_name   as display_name, contact_a.first_name, contact_a.last_name,
civicrm_email.email as email, civicrm_phone.phone as phone, civicrm_address.street_address as street_address,
civicrm_address.supplemental_address_1 as supplemental_address_1, civicrm_address.city as city ,civicrm_address.postal_code as postal_code,
civicrm_state_province.abbreviation as state, p.registered_by_id, contact_b.sort_name as registered_by_name,li__.id as li___id,
                    li__.qty as li___qty,
                    li__.unit_price as li___unit_price,
                    li__.line_total as li___line_total,
                    li__.participant_count as li___participant_count ,
                    li__.label as li___label, li_104_438.id as li_104_438_id,
                    li_104_438.qty as li_104_438_qty,
                    li_104_438.unit_price as li_104_438_unit_price,
                    li_104_438.line_total as li_104_438_line_total,
                    li_104_438.participant_count as li_104_438_participant_count ,
                    li_104_438.label as li_104_438_label, li_105_443.id as li_105_443_id,
                    li_105_443.qty as li_105_443_qty,
                    li_105_443.unit_price as li_105_443_unit_price,
                    li_105_443.line_total as li_105_443_line_total,
                    li_105_443.participant_count as li_105_443_participant_count ,
                    li_105_443.label as li_105_443_label, li_105_440.id as li_105_440_id,
                    li_105_440.qty as li_105_440_qty,
                    li_105_440.unit_price as li_105_440_unit_price,
                 
)
Etc. Full Pastebin here: http://pastebin.com/AEvvyp3u

Civicrm 4.5.0 / Drupal 7.