Author Topic: MySQL error after adding custom fields (Read 1874 times)

backdrifting · April 13, 2008, 10:17:52 pm

I added more custom fields to an existing profile and now I'm getting the following MySQL error:

Sorry. A non-recoverable error has occurred.

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

The event reg. form was working fine until I added more fields. Now it appears that MySQL can't handle it?

Any suggestions here? I'm getting the error when trying to process the form as a test transaction, and also when trying to add another custom field.

Running CiviCRM 1.9 on Drupal 5.7 with MySQL 4.1.

Donald Lobo · April 13, 2008, 10:29:10 pm

I suspect you are using way too many custom fields in one group / profile (more than 30 probably).

2.0 addresses these limitation by using a database table for every custom group and a column in the table for every custom field. This reduces the number of left join's a fair amount (assuming you have quite a few fields / group)

You probably should consider upgrading to 2.0 for the above and other reasons (its a pretty big release and improvement over 1.9)

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: MySQL error after adding custom fields (Read 1874 times)

backdrifting

MySQL error after adding custom fields

Donald Lobo

Re: MySQL error after adding custom fields