CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • DB error on participant listing
Pages: [1]

Author Topic: DB error on participant listing  (Read 238 times)

davyivins

  • I post occasionally
  • **
  • Posts: 119
  • Karma: 2
    • PURCO SA
  • CiviCRM version: 4.5
  • CMS version: Drupal 6.33
  • MySQL version: 5.5.34
  • PHP version: 5.4.33
DB error on participant listing
September 18, 2014, 09:06:50 am
Drupal 6 / Civi 4.4.6

I am pulling participant reports using the Fancy Searches extension. My event has multiple sub events.

I can pull Participant Detail (one row per participant) reports individually, or for up to three events simultaneously, but as soon as I add a 4th event I get the error "Sorry but we are not able to provide this at the moment.
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc   Return to home page.  "

However it works fine if I pull reports for all 4 events using either the SUMMARIZED report or the Participant Detail (one row per line item) report.

Can anyone give me guidance to find the problem?
« Last Edit: September 18, 2014, 09:12:08 am by davyivins »
There are times I love technology...and then there are times I *love* technology :-)

davyivins

  • I post occasionally
  • **
  • Posts: 119
  • Karma: 2
    • PURCO SA
  • CiviCRM version: 4.5
  • CMS version: Drupal 6.33
  • MySQL version: 5.5.34
  • PHP version: 5.4.33
Re: DB error on participant listing (MariaDB Too many tables)
September 29, 2014, 05:57:35 am
I'm learning as I go :-)

The query is generating the following error:

Database Error Code: Too many tables; MariaDB can only use 61 tables in a join, 1116

Any pointers as to how I could fix this?

many thanks
Davy
There are times I love technology...and then there are times I *love* technology :-)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • DB error on participant listing

This forum was archived on 2017-11-26.