Problem with large select database join [solved]

[fbarthelemy]

Hi,
I often used database join element with multiple select.
But, when I trie to select a lot of records (in my case, 370 lines) :
- the server gives me a 504 error and the site is unavailable til the error happens. If I close my window and reopen another one, the site doesn't works till the 504 error happens
- But it writes fine in repeat table the records
- But it doesn't run php plugin (I tried to disabled plugin and it's the same issue)

In details view I've the first 41 records but after the last (41th) it writes //..*../

• unknown label
• unknown label
• unknown label
• unknown label
• unknown label
• unknown label

Someone here knows why?

 

[troester]

did you enable Bigselects in Fabrik Options?
you may hit some mysql limits

Gesendet von meinem SM-G930F mit Tapatalk

 

[fbarthelemy]

It was'nt
I did it.
Now, It seems to be fine. All the records are displayed.
But I still have the 504 error.

 

[lousyfool]

Googling "error 504" will give you plenty of pointers.

 

[fbarthelemy]

Serioulsly ? What google is ? It looks great
The 504 error is only with big select.
But my problem seems to be, at least partially, solved.
So thx to you @troester .