Page 1 sur 1

More than 49 Fields?

Posté : lun. 25 oct. 2010 14:37
par sebem
Hello!
First of all I want to thank you for this great component.
I just have one problem.
For my collction I need more than 50 fields. If I create more than 49 fields I will get this error message in the frontend and there is no record in the collection list (see picture)!
Do someone has a solution?
regards
sebem

Re: More than 49 Fields?

Posté : ven. 5 nov. 2010 01:00
par steevo
Hi and thank you,

Could you execute in your sql:

Code : Tout sélectionner

SHOW VARIABLES LIKE 'max_join_size';
I think that this parameter is too low for all your datas.

Re: More than 49 Fields?

Posté : ven. 5 nov. 2010 01:35
par sebem
Hi Steevo,
I executed the code you posted!
The result was:

Variable_name Value
max_join_size 18446744073709551615
I dont know what that means???

Last time the error occured after 51 records?
Any clues?

sebem

Re: More than 49 Fields?

Posté : ven. 5 nov. 2010 20:37
par steevo
Hi,

That's because the request is too big with all your fields.
I have to review the way i retrieve the datas to avoid that.
I'm sorry but for the moment, i think that you can't do anything...