CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP


Print topic Send  topic

Author Message

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


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?

View profile  Send private message
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.

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


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?

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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

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