Xataface Forums

Hi,

I'm having a fatal error when trying to view some tables of my database with datagrid,
could it be that the database is too big?? the message is
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 35 bytes) in /myservername/www/xataface/PEAR.php on line 872

Datagrid is really a major tool on Xataface for me, I'm also surprised there's no specific topic for it on the forum.
Any ideas someone?
Darova

Hmm... This is strange. It shouldn't depend on the size of the table. Only the number of rows you are showing on the page. How many rows are you trying to show per page?

I just tried to display 30 records per page and it gave a different message, looks like the issue is on the server side(?):
Notice: MySQL server has gone away in /myserver/www/xataface/Dataface/Table.php on line 975

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /myserver/www/xataface/Dataface/Table.php on line 978

Fatal error: Error performing mysql query to get column information from table 'movies'. The mysql error returned was : 'MySQL server has gone away'.
On line 477 of file /myserver/www/xataface/Dataface/Table.php in function printStackTrace()
On line 2349 of file /myserver/www/xataface/Dataface/Table.php in function Dataface_Table(movies,Resource id #11,)
On line 879 of file /myserver/www/xataface/Dataface/Application.php in function loadTable(movies)
On line 1594 of file /myserver/www/xataface/Dataface/Application.php in function handleRequest()
On line 6 of file /myserver/www/dbase/index.php in function display()
in /myserver/www/xataface/Dataface/Table.php on line 477

Then I tried 10 records per page and it was worse:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.

But, there's only two tables on the three that returns errors, the third one works just fine.
Could it be the table content? special characters, accents maybe? I'll try again in a couple of days just to be sure this is not an error from the server, by the way I couldn't find the error log to post here but I'll try to do that.

Thanks for your help!

I suspect that these 2 errors were coincidental with your mysql server crashing - and may not be related to the first memory error. You may need to restart mysql (but sometimes these mysql server gone away errors seem to just fix themselves it you let it sit for a bit).

This error could be related to this issue:
viewtopic.php?f=4&t=5375