[FX.php List] Re: FX.php_List Digest, Vol 76, Issue 1

[Gjermund Gusland Thorsen]

I never delete from a webscript, I always mark records for deletion;
unless the table is only for temporary data that are not stored elsewhere.

Caches are better if you write them to file such as '../tmp/myCache' .
key( $_SESSION ) . '.txt'

ggt

2010/11/2 Bradley Creamer <creamerbradley at fhda.edu>:
> Hi Leo,
>
> Thank you for the ideas. Keep them coming!
>
> For this system, I have increased PHP execution and memory allowance triple
> the normal amount. There are other functions/scripts that I use that are
> much more processing intense than this "delete found records" script. And,
> there's nothing in the error log/access log of the server that indicates a
> time out. The server is set to show any and all warnings and errors (it's a
> DEV server). But I get nothing, just a blank page after about 30 seconds.
>
> Just a point of clarification, in FMPv6, the script - and the resulting Web
> page - worked fine. I know that there are (many) new things to consider in
> FMPv11, including script execution permission. I'm working out the kinks in
> the upgrade. Aside from the additions to the FMPv11 version of the script I
> mentioned below, am I missing anything else that might be causing the Web
> page hang up?
>
> Many thanks for leads and suggestions,
> Bradley
>
>
>
> On 11/1/2010 3:51 PM, fx.php_list-request at mail.iviking.org wrote:
>
> Message: 1
> Date: Sat, 30 Oct 2010 11:29:47 +0200
> From: "Leo R. Lundgren" <leo at finalresort.org>
> Subject: Re: [FX.php List] Script executes, but hangs web page
> To: creamerbradley at fhda.edu,	"FX.php Discussion List"
> 	<fx.php_list at mail.iviking.org>
> Message-ID: <59E1F042-C582-46C3-A057-6D371A5AB509 at finalresort.org>
> Content-Type: text/plain; charset="us-ascii"
>
> Could it be a timeout in PHP? You don't mention how long it takes before you
> get the blank page in the browser.
>
> Try to establish whether it takes the same amount of time before it blanks
> out, each time you try it. If so, it might be that the PHP script takes too
> long, so the PHP engine shuts it down to prevent stale scripts.
>
> There's a setting for this in PHP's configuration called max_execution_time.
> You can also set it in the script itself using set_time_limit() (see
> php.net/set_time_limit). I believe the default is 30 seconds.
>
>
> 30 okt 2010 kl. 01.32 skrev Bradley Creamer:
>
> Hi FX folks,
>
> I have a script that deletes a found set of records. I've found the script
> executes fine from a Web page call, but the resulting Web page hangs, in
> other words, after many seconds, a blank page is returned.
>
> Having converted the database from FMP6 to FMP11/FMPSA11, I've updated the
> script to have the "Confirm" statement and I even added the "Exit Script"
> directive after that; still it hangs.
>
> But, again, the script does execute in the background, deleting all found
> records, so I'm pretty sure I have the permissions set correctly. However, I
> set a global field to capture script results (as stated in the "Exit Script"
> directive) but nothing is captured.
>
> So, it's deleting the found records, not returning the result, and hangs the
> Web page.
>
> Any thoughts? Below is the script in it's entirety.
>
> Thanks for any and all help,
> Bradley
>
> **************** Script:
>
> Delete All Records [No dialog]
> Commit Records/Requests [Skip data entry validation; no dialog]
> Exit Script [Result: "All Deleted"]
>
>
>
>
> --
>
> ****************************************************
> De Anza Web Team / Technology Resources Group (TRG)
> webteam at deanza.edu
> ----------------------------------------------------
> Update Your Firefox Browser! (www.firefox.com)
> ****************************************************
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>