By lucasan37 on

Hi, I'm having an issue. I have a Content type with 71 Fields (CCK) and I need to generate a report, so I'm using the Views module to do that.

I did search before posting this, some people have posted it before but with no luck.

The Views module use a Join for each CCK Field so there's the error "user warning: Too many tables; MySQL can only use 61 tables in a join query"

Is there any way to get this query better? What can I do to generate my report with that many CCK Fields?

Thank you.

⋅ Categories: Drupal 6.x

Comments

jaypan’s picture

jaypan
Location Victoria, BC
commented

Are you sure you really need 71 fields? I mean, it's not impossible, but somewhat unlikely. There are usually better ways to do something - adding multiple values for a single field type or what not.

Contact me to contract me for D7 -> D10/11 migrations.

jason_gates’s picture

jason_gates commented

Hi,
I agree with Jay'c comment.

In addition, sometimes you have a customer who just insists on something hokey :) :) If that's the case, you could switch to a different database engine, see postgres here:
http://www.postgresql.org/about/ "Maximum Columns per Table 250 - 1600 depending on column types".

You can also code (or hire a coder) to create your report (instead of using the Views module).

lucasan37’s picture

lucasan37 commented

Thank you for your comments.

Yes, I need the 71 Fields, it's a report that works with computed fields, so every value is unique.

There's something strange, I run it twice and it worked fine, in fact I have the .xml report, but yesterday it showed me the warning and did not work again.

There has not been changes in the Content type or the fields.

I'm really lost.