GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   PHP pro's, got an interesting problem.... (https://gfy.com/showthread.php?t=710439)

StuartD 02-28-2007 01:53 PM
PHP pro's, got an interesting problem....
 
I recently upgraded my PHP to 5.2.1 and now have an interesting problem.

I have a query grabbing results from a database. The results then loop in a while loop and get dumped into an array for storage.

The problem is, it worked before.... but now it dies out after it hits a certain point.

I don't get any "out of memory" errors, it just.... stops.

I know the code is ok, I can get results from other queries that don't return as much information, and it worked on 5.2.

I bumped the memory usage to 100Mb in the ini file, and it still dies at the same point.

Thoughts?

Adultnet 02-28-2007 01:55 PM
maybe its a time out server side ?

psili 02-28-2007 01:56 PM
Did you try:

set_time_limit(0)

?

Maybe it is a timeout somewhere.

StuartD 02-28-2007 02:00 PM
Nah, it gives me a blank screen within 2-3 seconds. So it's dying out during the loop pretty fast.

psili 02-28-2007 02:14 PM
I saw a post made today somewhere about drupal and php 5.2.1 not playing nice with each other - throwing memory errors or something. Not sure what it could be as you'd think a simple loop would run fine. Are you running it from command line or a browser?

Adultnet 02-28-2007 02:15 PM
Quote:
Originally Posted by StuartD (Post 11989053)
Nah, it gives me a blank screen within 2-3 seconds. So it's dying out during the loop pretty fast.
I guess the script page does not receive the variables of the query page.
Try to check the code and look if the page variables are received with $_get or $_post since if this is not determined it might be the problem.

StuartD 02-28-2007 02:21 PM
Quote:
Originally Posted by StuartD
I know the code is ok, I can get results from other queries that don't return as much information, and it worked on 5.2.
Quote:
Originally Posted by Adultnet (Post 11989143)
I guess the script page does not receive the variables of the query page.
Try to check the code and look if the page variables are received with $_get or $_post since if this is not determined it might be the problem.
Thanks for the help though.

StuartD 02-28-2007 02:22 PM
Quote:
Originally Posted by psili (Post 11989128)
I saw a post made today somewhere about drupal and php 5.2.1 not playing nice with each other - throwing memory errors or something. Not sure what it could be as you'd think a simple loop would run fine. Are you running it from command line or a browser?
I run it from within the browser.

I'm pretty sure it is a memory error, but like I said, I'm not getting the error. I turned on _ALL and even turned on the logging to throw errors to the apache error log and yet... I get nothing.

Just a blank page in my browser where I should see results.

woj 02-28-2007 02:44 PM
wow, didn't even notice we are up to 5.2.1, seems like yesterday when 4.2.1 was out...

Adultnet 02-28-2007 03:00 PM
Quote:
Originally Posted by StuartD (Post 11989176)
Thanks for the help though.
the code could work fine on your last version of php to increase security some defaults were changed and you might need to optimize your code or your php settings.
For best idea of what could be changed just review it at php.net :)

Nookster 02-28-2007 03:01 PM
try it from the command line, if it doesn't work there than there was a problem with the installation so you'll need to re-install. If it works then it's your software. Doesn't anyone know how to use trial and error these days? :disgust

Nookster 02-28-2007 03:02 PM
Quote:
Originally Posted by Adultnet (Post 11989461)
the code could work fine on your last version of php to increase security some defaults were changed and you might need to optimize your code or your php settings.
For best idea of what could be changed just review it at php.net :)
And yes, that could also be the issue.

StuartD 02-28-2007 03:06 PM
Quote:
Originally Posted by Nookster (Post 11989467)
try it from the command line, if it doesn't work there than there was a problem with the installation so you'll need to re-install. If it works then it's your software. Doesn't anyone know how to use trial and error these days? :disgust
Thanks for your wonderful insight, but yes, I did try it and I still have the same problem, and yes I have re-installed and yes, the loop works 1200 times before it just stops so using $_GET most likely isn't the problem... no matter what new security features there are.

Doesn't anyone use common sense these days? :glugglug

Damian_Maxcash 02-28-2007 03:10 PM
Damn - this came up on a WP forum I was looking at the other day.

I will have a search through my history, but it could have been on my laptop that I have loaned out.

I will get back to you.

jimbona 02-28-2007 03:29 PM
Doing some searching via google, shows many people are suffering from memory leaks on heavy array use, you can see the changes of the PHP core here

Quote:
php.net/ChangeLog-5.php
(sorry could not post url)

You may want to provide some sample code so people can advise/test locally what is failing.

Have you tried checking if anything has changed in your PHP setup with a phpinfo.php page with
PHP Code:
<?php phpinfo();?>
inside.
You can also try putting errors on in php.ini or via .htaccess.

When you get a white page straight away it usally means a code error has taken place so seeing the code could route out the problem. Just because you are using similar code else where and it works, doesnt mean this version does. You could have a rogue .,'" etc etc.

StuartD 02-28-2007 03:33 PM
Quote:
Originally Posted by jimbona (Post 11989620)
Doing some searching via google, shows many people are suffering from memory leaks on heavy array use, you can see the changes of the PHP core here


(sorry could not post url)

You may want to provide some sample code so people can advise/test locally what is failing.

Have you tried checking if anything has changed in your PHP setup with a phpinfo.php page with
PHP Code:
<?php phpinfo();?>
inside.
You can also try putting errors on in php.ini or via .htaccess.

When you get a white page straight away it usally means a code error has taken place so seeing the code could route out the problem. Just because you are using similar code else where and it works, doesnt mean this version does. You could have a rogue .,'" etc etc.
this is the code:

PHP Code:
while($line = mysql_fetch_array($result, MYSQL_ASSOC)){
    $list[] = $line;
} 
I figured it was a code error at first, because of the white page. However, as I said, if I throw in an output... it'll give me 1200 lines or so before it stops outputting... .without giving an error. It just ends the while statement and then won't output anything following the loop either.

And my phpinfo() looks the same from what I could see. I tried to keep all my settings the same.

Tempest 02-28-2007 03:52 PM
There's been a lot of problems with 5.2.. thankfully 5.2.1 fixed my biggest problem but I'm sure there's more...

I see you have all the logs turned on.. Have you confirmed that it would report an error by "forcing" one in your mysql query? I've been having a lot of issues with my queries where I didn't before so would be interested to know if the query actually works or fails and that the problem is after that.

jimbona 02-28-2007 03:58 PM
Hi,

If it is writing 1200 lines a failing, have your tried running a similar query along through PHPmyadmin or similar to see if any of the fields you are pulling are empty.

Do you do any outputting in the page?

try putting in some checking

i.e.

PHP Code:
while($line = mysql_fetch_array($result, MYSQL_ASSOC)){ 
    if(!empty($line))
    {
        $list[] = $line;
    }
} 
can you also show a dummy of what $result it?
What type of field/size are you pulling into the array?

HomeFry 02-28-2007 04:26 PM
It sounds like your MySQL database has alzheimers.

StuartD 02-28-2007 04:47 PM
Quote:
Originally Posted by jimbona (Post 11989763)
Hi,

If it is writing 1200 lines a failing, have your tried running a similar query along through PHPmyadmin or similar to see if any of the fields you are pulling are empty.

Do you do any outputting in the page?

try putting in some checking

i.e.

PHP Code:
while($line = mysql_fetch_array($result, MYSQL_ASSOC)){ 
    if(!empty($line))
    {
        $list[] = $line;
    }
} 
can you also show a dummy of what $result it?
What type of field/size are you pulling into the array?
That checking is a good idea, however it still blanks out the page if it goes too many rows.

I checked and the mysql_num_rows tells me that there's 2900+ results. So it's pulling the data properly... it's all there.

However once I start looping it and putting it into the array, it dies.

If I alter the code to just output the fields in $line, it outputs everything quite nicely.

It's dumping the information into the array that causes it to choke out.

Damian_Maxcash 02-28-2007 05:05 PM
Quote:
Originally Posted by StuartD (Post 11990010)
That checking is a good idea, however it still blanks out the page if it goes too many rows.

I checked and the mysql_num_rows tells me that there's 2900+ results. So it's pulling the data properly... it's all there.

However once I start looping it and putting it into the array, it dies.

If I alter the code to just output the fields in $line, it outputs everything quite nicely.

It's dumping the information into the array that causes it to choke out.
I know you have already checked this, but just in case - whats max_execution_time in php.ini?

Have you got safe mode on or off?

Obvious stuff - but I have missed it before on a new server.

StuartD 02-28-2007 05:07 PM
Quote:
Originally Posted by damian2001 (Post 11990101)
I know you have already checked this, but just in case - whats max_execution_time in php.ini?

Have you got safe mode on or off?

Obvious stuff - but I have missed it before on a new server.
60 seconds, tried changing it in the code to 0 and to 999... neither helped.

And safe mode is turned off.

Good thinking. I hadn't actually checked to see about safe mode, just assumed... but now that you mentioned it, I checked just to be sure.

jimbona 02-28-2007 05:24 PM
Hi,

try doing

PHP Code:
while($line = mysql_fetch_array($result, MYSQL_ASSOC)){  
    if(!empty($line)) 
    { 
        $list[] = $line; 
        echo $line."<br>";
    } 
} 
or
PHP Code:
while($line = mysql_fetch_array($result, MYSQL_ASSOC)){  
    if(!empty($line)) 
    { 
        $list[] = $line; 
    } 
}  
print_r($list); 
See what is last in the line and find out the value after it.
What type of data are you dumping? String?, links? string lengths?

If you want to PM me I could have a direct look if needed to help debug it, im just interested in what would cause such an issue. :/

StuartD 02-28-2007 05:49 PM
Ok, I found it... took me forever though!

php 5.2.1 put in a second php.ini file.... one in the php folder and one in the apache folder.

The new one had a memory limit of 8, but it was reporting what I saw in the other php.ini.

And therefore, my memory limit was way lower than I thought it was. Once I changed the second php.ini file, all was good!


Thank you to everyone for helping me to solve this :thumbsup

psili 02-28-2007 05:52 PM
Quote:
Originally Posted by StuartD (Post 11990324)
Ok, I found it... took me forever though!

php 5.2.1 put in a second php.ini file.... one in the php folder and one in the apache folder.

The new one had a memory limit of 8, but it was reporting what I saw in the other php.ini.

And therefore, my memory limit was way lower than I thought it was. Once I changed the second php.ini file, all was good!


Thank you to everyone for helping me to solve this :thumbsup

I've had the stupid issue happen to me and it drove me crazy where a "ghost" php.ini file existed somewhere. Since then, I try and remind myself to check php_info() and make sure shit's where I think it should be.

borked 02-28-2007 11:25 PM
Quote:
Originally Posted by StuartD (Post 11990324)
Ok, I found it... took me forever though!

php 5.2.1 put in a second php.ini file.... one in the php folder and one in the apache folder.

The new one had a memory limit of 8, but it was reporting what I saw in the other php.ini.

And therefore, my memory limit was way lower than I thought it was. Once I changed the second php.ini file, all was good!


Thank you to everyone for helping me to solve this :thumbsup
Glad you got it sorted - I also had a major prob with the 5.2.1 upgrade - as it turned out, the upgrade rearranged the order of loaded extensions and putting mysql.so and pspell.so as the last to load fixed the pb. (took me a while to fix that one!)


All times are GMT -7. The time now is 11:20 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123