php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #34674 php randomly stops echo and exits after 30,000
Submitted: 2005-09-28 23:25 UTC Modified: 2005-09-28 23:44 UTC
From: starlite at starlitedvd dot com Assigned:
Status: Not a bug Package: Unknown/Other Function
PHP Version: 4.4.0 OS: Windows Server 2003
Private report: No CVE-ID: None
View Developer Edit
 [2005-09-28 23:25 UTC] starlite at starlitedvd dot com 
Description:
------------
When using a MySQL script to pull back 2 small pieces of information, and echoing them onto my screen for copying and pasting into other applications, php can only pull back 30,000 or so lines. I saw it randomly brought back 30,298 then 39,447.

Reproduce code:
---------------
http://www.starlitedvd.com/mycode.html

Expected result:
----------------
An output of all of the data from ROW 1 to ROW 90,000 from MySQL.

Here's some copied from the output, but not all of it:

You can see 1 being the auto_increment that has the data. the next number is a UPC code and the last are some ASIN codes. basically you can fill a database will data as long as this, with 90,000 lines of MySQL data, and you shouldn't be able to get past the problem i'm having.



Actual result:
--------------
1 733961730463 B000AABL6M
2 733961730265 B000AABL12
3 730003715099 B00009ZY9S
6 675754862121 B000AYELYM
9 658769028430 B000065B32
10 658769028539 B000065B0N
17 733807882110 B0001EJJMK
22 736899099626 B0009OUBLU
26 738329009250 B000006PFD
27 758781110349 B00005QKHP
29 669198222085 B0001NBMZS
30 669198222054 B0001NBMY4
31 669198222061 B00026L8XU
32 669198222078 B0002J4YOC
33 669198210068 B0002VEVR0
34 669198800009 B0001BMLY6
35 669198800016 B0001BMLYG
36 669198800023 B0001BMLZU
37 669198800030 B0001BMM04
38 669198800047 B0001BMM0E
39 669198800061 B00018D5QM

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-09-28 23:29 UTC] tony2001@php.net 
Do you have display_errors On and error_reporting set to E_ALL ?
 [2005-09-28 23:39 UTC] starlite at starlitedvd dot com 
I just removed the error_rerporting(0); from my functions file, and I receive this: However I have the execution time set to 9999 in php and MySQL, maybe there is a code I can put in my script that will fix this? You guys are fast and smart ;)

Fatal error: Maximum execution time of 30 seconds exceeded in F:\Program Files\Apache Group\Apache2\htdocs\functions.php on line 2185
 [2005-09-28 23:42 UTC] tony2001@php.net 
Sorry, but your problem does not imply a bug in PHP itself.  For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions.  Due to the volume
of reports we can not explain in detail here why your report is not
a bug.  The support channels will be able to provide an explanation
for you.

Thank you for your interest in PHP.
 [2005-09-28 23:44 UTC] starlite at starlitedvd dot com 
set_time_limit(9999); fixed this problem.

However I still think something like this should be included in you guys setup, like:  "Will you be processing scripts that may output large amounts of data in more than 30 seconds of time?" :P

Thanks for the help, i know you guys are busy.

Thx
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved. 		Last updated: Wed Oct 07 09:00:02 2026 UTC