errors with the grid mode

A place for users and developers of the Xataface to discuss and receive support.

errors with the grid mode

Postby Jean » Tue Jul 17, 2012 12:10 am

Hi Steve,

I have problems with the grid mode on big tables though I have solved another error in small tables.

On big tables I have
Code: Select all
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 35 bytes) in C:\xampp\htdocs\xataface-1.3.2\PEAR.php on line 872


Pear line is
Code: Select all
     $this->backtrace = debug_backtrace();

May be you'll have a clue, how I can solve this.

Thank you

Jean
Jean
 
Posts: 259
Joined: Wed Nov 07, 2007 1:30 am
Location: Pau, France

Re: errors with the grid mode

Postby shannah » Tue Jul 17, 2012 2:43 pm

How big is the table? (how many records are you showing per page)? It looks like its just running out of memory.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: errors with the grid mode

Postby Jean » Wed Jul 18, 2012 2:43 am

I have just 63 items and pages are 30 items each.
Jean
 
Posts: 259
Joined: Wed Nov 07, 2007 1:30 am
Location: Pau, France

Re: errors with the grid mode

Postby shannah » Thu Jul 19, 2012 12:36 pm

So this is using the grid module? It is hard to say where the memory leak is occurring without actually looking at the application and tinkering with the code.

You could try increasing the memory limit even more, though you already seem to have a healthy amount allotted. Is your grid just using the default table or is it making use of related fields? (There is an undocumented feature that allows you to include related fields in the grid.. which can increase memory requirements).

If you change the -limit to a number smaller than 30, does this change anything? (e.g. try changing it to 20 or 10 or 1) - just to see what happens to the memory.

-Steve
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: errors with the grid mode

Postby tomtom8 » Mon Jul 30, 2012 7:10 am

Hello!
I have the same error, I have two tables one primary "odl" with 160 records and one as view "odl_view" with same records , however, the error I get is only on the odl table

Michele
tomtom8
 
Posts: 17
Joined: Mon Jul 30, 2012 6:56 am


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 36 guests

Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved