I got a content type with a lot of CCK fields... When i export in CSV via Bonus Export module, the CSV file is empty and i have an error like this :
user warning: Too many tables; MySQL can only use 61 tables in a join query

Can I make something in order to make it work ? does anyone have an idea ?

Comments

neclimdul’s picture

neclimdul
He/Him
commented
Title: Export CSV problem with too many CCK field » Too many CCK fields breaks Views query
Project: Views Bonus Pack » Content Construction Kit (CCK)
Version: 5.x-1.2-alpha1 » 5.x-1.x-dev
Component: Code » Views Integration

That's not going to have anything to do with Views Bonus Pack. The Export Plugin only themes the output of the query built by views. You're going to see this problem no matter what style plugin you choose.

I think you're probably going to want to file this against CCK. If there's anything to be done I think they'll be the ones to help you.

Please update the issue with the version of CCK you're using.

karens’s picture

karens commented
Status: Active » Closed (won't fix)

Closing old issues. None of us is using the D5 version any more, so hard to provide any support. Sorry.

SteveChamtlcclub’s picture

SteveChamtlcclub commented
Version: 5.x-1.x-dev » 6.x-1.x-dev
Issue tags: +25+ CCK fields and Views repeating

I am new to Drupal, however, I am running into a problem: if I create 29 (or so) CCK fields, the data repeats when query is called from Views. Not sure what to do as this point...my project calls for profiles that are detailed. Is there a way that this can be fixed? Or, if there is a limit to how many CCK fields can be queried through View, can I join 2 Views together? I'll try doing this, but if anyone has any suggestions, please let me know... /*Help 'cause I'm not sure what to do.*/