CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 OUT OF MEMORY ERROR

Print topic Send  topic

Author Message
gulamc

Posts: 15
Posted: 10/09/2016, 3:16 PM Quote message

Hi,

I am using v5.1.1.18992 with php/mysql. I have a table with some customer billing data with about 150K records in it.

I have developed a simple query where someone can search his/her records based on a reference number. This should be quite straight forward, but when I run the program, I get the following error:

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 32 bytes) in /home/xyz/public_html/scripts/bills/Common.php on line 993

I increased the memory limit in PHP upto 512M, but still get the same issue.

When I look at line 993 in common.php, it reads

"a/p" => array("(a|p)", ccsAmPm),

In the table I have one date field which I have formatted as dd/mm/yyyy for display.

What could be the problem?

Gulam
View profile  Send private message
DataDoIT
Posted: 10/09/2016, 7:18 PM Quote message

I think the error may be misleading. 536870912 = 536M.

Check your date fields and look for mismatches.
gulamc

Posts: 15
Posted: 10/09/2016, 11:17 PM Quote message

Hi,

I am not sure I have understood your point.

I increased the memory limit in PHP from 128M to 256M to 512M and in all cases got the fatal memory error. The error I reported is after increasing to 512M.

I have checked the database, I have only one date field and I don't see any mismatch.

Has this got to do with the number of records in the table?

Gulam
View profile  Send private message

Add new topic Reply to topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.