Problems with flush()

uruloki · 09-26-2003, 06:11 AM

Sorry for my english, I'm spanish. I work over win2000/IIS with PHP 4.3.0 and MySQL 3.23.55. I have been working on your "motor search", adapting to our requirements. I have the problem that sometimes when i'm updating and at the end of the process, the mysql service give me an exception and erases/corrups some tables.
I looked for the problem an it occurs at the end of the spider process when it calls the flush() function.

the code:
...
//display something to avoid browser-side timeout
echo "Entrada -> Liber**** el Buffer.<br />";
flush();
echo "Salida -> Liber**** el Buffer<br />";
}
}
unset($lien);
echo $br;
.....

If you notice any problem like this one, answer this post.
Thanks
PHPDIG rules! (I hope you understand me

)

uruloki · 09-26-2003, 10:24 AM

Maybe bug problems with MySQL version, I have instaled the last one a runs correctly. What's your opinion?

Charter · 09-26-2003, 05:34 PM

Hola. My initial guess would be that there was some sort of timeout issue. The flush command is there just to prevent the browser from timing out. There are some issues about flush listed at www.php.net. Perhaps one of those issues was causing the problem? Do you happen to have the text from the MySQL exception, along with what tables were affected?

09-26-2003, 06:11 AM	#1
uruloki Green Mole Join Date: Sep 2003 Posts: 6	Problems with flush() Sorry for my english, I'm spanish. I work over win2000/IIS with PHP 4.3.0 and MySQL 3.23.55. I have been working on your "motor search", adapting to our requirements. I have the problem that sometimes when i'm updating and at the end of the process, the mysql service give me an exception and erases/corrups some tables. I looked for the problem an it occurs at the end of the spider process when it calls the flush() function. the code: ... //display something to avoid browser-side timeout echo "Entrada -> Liber** el Buffer.<br />"; flush(); echo "Salida -> Liber** el Buffer<br />"; } } unset($lien); echo $br; ..... If you notice any problem like this one, answer this post. Thanks PHPDIG rules! (I hope you understand me )

09-26-2003, 10:24 AM	#2
uruloki Green Mole Join Date: Sep 2003 Posts: 6	I think the answer is in MySQL version Maybe bug problems with MySQL version, I have instaled the last one a runs correctly. What's your opinion?

09-26-2003, 05:34 PM	#3
Charter Head Mole Join Date: May 2003 Posts: 2,539	Hola. My initial guess would be that there was some sort of timeout issue. The flush command is there just to prevent the browser from timing out. There are some issues about flush listed at www.php.net. Perhaps one of those issues was causing the problem? Do you happen to have the text from the MySQL exception, along with what tables were affected? __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.