gulamc
Posts: 17
|
Posted: 10/09/2016, 3:16 PM |
|
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
|
|
|
DataDoIT
|
Posted: 10/09/2016, 7:18 PM |
|
I think the error may be misleading. 536870912 = 536M.
Check your date fields and look for mismatches.
|
|
|
gulamc
Posts: 17
|
Posted: 10/09/2016, 11:17 PM |
|
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
|
|
|
|