Kurrel

After reading up on it, I've changed error_reporting to error_reporting = E_ALL & E_NOTICE & ~E_STRICT It's providing some more details to work with. Thanks for that tip, even if it doesn't answer THIS problem it's useful to know about.

Hi there, I've checked the apache error logs and it contains details of recent restarts. I can see errors I'd expect from other things if I look a week or two back, but nothing related to this. How would I check for a memory leak? I've watched task manager for a while but it doesn't give very particular date. I have error reporting set to the following : error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT Is there a way to check these details despite the 500 error (seeing as it dominates the screen)

So, filling 50 rows with data and trying just the set of cURL processes results in the same timeout. 35, 36 and 37 records succeeds but 39 does not so I am able to send a few more. I'm now sure it must be a time out somewhere, but trying to figure out where remains elusive.

1, I didn't include the loop, just the CURL call that is inside the loop. 2, I'm almost certain it's returned via my server. It's a full on white screen without me printing out the response... is there any further way to make sure of this? 3, Unfortunately, the script is pretty specific to APIs I know on all three systems. However, you have got me thinking. I'm going to load a large set of dummy data and remove one, then the other and finally both exterior calls from the script. If one is breaking, that'll be a big step in the right direction.

Hi there, I'm writing an application that pulls from two separate web based APIs, collates the data into a single array of data. Once done, it then enters a loop that cycles through the array and executes a cURL call for each cycle. This worked perfectly for a controlled set of 10 artificial records and so I've started testing with live data. On running the code, I eventually the following : Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. I'm not sure how to debug this and so I'm hoping I can find some help here. I'm running WAMP, and the php.ini contains the following: max_execution_time = 0 ; Maximum execution time of each script, in seconds max_input_time = 0 ; Maximum amount of time each script may spend parsing request data Through testing, I have discovered the following : The script can do exactly 35 iterations through the loop in under 2 minutes. Any number greater than this causes the error. If I skip the first 20 curl submits, I can then do 21 to 55 iterations before failure, so I do not believe it is the 36th value. If I put a sleep(5) command into the loop, I can still do 35 and no more iterations than that. If I put a sleep(10) command into the loop, it fails on 35 and needs less. $action = "post"; $url = "http://url.url.url/api/v1.0/udo_Position/create"; // I've replaced the actual URL out of necessity // set user agent { print("Setting CURL options, using URL ".$url."<br>"); $cd = curl_init(); curl_setopt($cd, CURLOPT_HEADER, 1); curl_setopt($cd, CURLOPT_URL, $url); curl_setopt($cd, CURLOPT_USERPWD, 'username:password'); curl_setopt($cd, CURLOPT_RETURNTRANSFER, 1); // Don't send return value to screen curl_setopt($cd, CURLOPT_USERAGENT, "Firefox/2.0.0.1"); // spoofing FireFox 2.0 curl_setopt($cd, CURLOPT_VERBOSE, true); // } if ($action == 'get') { ; } elseif ($action == 'post') { print("POST set;<br>"); print("<pre style='font-family:verdana;font-size:13'>"); print_r($pointval); print("</pre>"); $pointval["save"] = "Save"; // The AddNew step form requires this. curl_setopt($cd, CURLOPT_POSTFIELDS, $pointval); } else { print("Invalid usage. Please see example<br>"); return; } $reply = curl_exec($cd); $http_status = curl_getinfo($cd, CURLINFO_HTTP_CODE); print("<pre style='font-family:verdana;font-size:13'>"); print_r($http_status); print("</pre>"); print("Here is the reply from the AddNew function: <br>"); print("<pre style='font-family:verdana;font-size:13'>"); print_r($reply); print("</pre>"); if (curl_error($cd)) { print("Error: ".(curl_error($cd))."<br>"); } curl_close($cd); print("Insert Successful.<br>"); I am uncertain whether it is a PHP, Apache or cURL issue at this point. I have another script that pushes a great deal more cURL calls to the same system but pulls from only one external resource, instead of two. Any help or suggestions would be appreciated.

Also, try this to get a listing of the files in the directory base. You may find that the program is referencing a different directory base to the one you're expecting. if ($handle = opendir("../")) { while (false !== ($file = readdir($handle))) { print($file."<br>"); } closedir($handle); }

Problem resolved by creating a download function, not using any of the includes in my main program, that was called by the href. I suspect a header problem with text being passed before the header but I can't find it.

After '$newtotal = $amount * 0.9; ' add '$newtotal = round($newtotal, 2);' Kurrel, -All smiles.

Hi PHPers, I've written code that allows a user to input the location of a csv file. My code then takes the CSV file, reads the contents and adds some additional fields calculated from several contained fields. $source = $_FILES["filesource"]; $sourcehandle = fopen($source["tmp_name"], "rb+"); $destination = FIRSTBASE."/calculator/masscalcs/"; $destname = "updated ".$source["name"]; $desthandle = fopen($destination.$destname, "w"); $count = 0; while (!feof($sourcehandle)) { // Math stuff and lots of fwriting } fclose($sourcehandle); fclose($desthandle); This file is created on the server side fine. The problem comes in trying to download the darn thing back to the user's machine. So far I can get a file named correctly but filled with php code, from the previous page so far as I am aware. This has been accomplished with : header("Content-type: text/x-csv"); header("Content-Disposition: attachment; filename=\"".$destname."\""); header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past I've tried a couple of variations on this, including form downloads but the results have varied between the php-spam in the file to an empty file simply named 'updated', no extension and no contents. Help? ??? Kurrel, - All smiles.

Fixed. For reference and anyone that may be interested, placing a wait delay before the reference allows the getElementsByName function to reference an arrayed name. Kurrel -All smiles.

Hi PHPers, I've been creating a large form for submission, with several dozen fields. The data is posted to a separate function through form submission, and I've found it easier to sort all the data by making the names of each input into arrays, <input id='inputname".$count."' name='conf[tasks][name]' value='".$taskval["name"]."' style='width:100%;'> for example. However, in creating a calendar date picker, I've had to use 'getElementsByName'. This works fine if the name of the referenced input is not an array, but will not work in the above cited example. Is there a way to make this work, or am I doing something really bad in what I'm doing above? Kurrel, - All smiles.

I've started building that, and it looks good so far. Thank you, I'd not seen the 'HAVING' before.

Hi everyone, I've a table that has all the status updates of several dozen units and I need to create a list of each unit's 3 most recent updates. MySQL server versio : 5.0.27-community-nt $sql = "select dtTime , liGPSID , fLatitude,fLongitude from GPSData where liGPSID > " . $lastpoint . " and dtTime > '$start' ORDER by dtTime"; This currently pulls all the records from the database, ordered by most recent. This can be over 50k records, though, sometimes a 100 for each unit. The table structure : (I can't do a direct pull right now, I'll try update this asap.) Id, dtTime, liGPSID, fLatitude, fLongitude, truckid, userid, deleted I've tried limiting by time, but some of the units are updated several times a minute and some are updated only once every few hours. I tried a group and order combination, but they don't return all the other details included in those records. Is there any SQL command to return the most recent update, and from that the 3 most recent? They're all stamped with unix dates. Please, help? Kurrel.

The issue was that the constant was defined in index.php and did not exist in the new .php file. Fixing that has resolved the issue and it now downloads sweetly.

Okay, that works so far as not throwing errors, but the pdf is then empty, containing no data. Double-checking, the original remains working and has all details in it but not the copied version. I wonder if the constant FIRSTBASE and file path are not coming through correctly? <?php $filepath=FIRSTBASE."/images/graphs/driverpdf.pdf"; // change your dir path $filename="driverpdf.pdf"; // change your file name downloadFile($filename,$filepath); function downloadFile($filename,$filepath) { header("Content-type: application/pdf"); header("Content-disposition: attachment; filename=".$filename); header("Content-Length: " . filesize($filepath)); header("Pragma: no-cache"); header("Expires: 0"); readfile($filepath); return; } ?> Also, the new file is named to driverpdf-1.pdf rather than remaining the same as the original. Is this significant?