Errors when 2 posts at once.

[classic]

Sorry for the dual post (First one in the wrong section).

 

I have an app developed in Delphi PHP. I have trimmed the app down to duplicate the error:

80.5.54.164:8080/map/test4.php code below:

 

<?php

require_once("vcl/vcl.inc.php");

//Includes

use_unit("dbtables.inc.php");

use_unit("forms.inc.php");

use_unit("extctrls.inc.php");

use_unit("stdctrls.inc.php");

session_start();

//Class definition

class Unit15 extends Page

{

      public $dbmapping1 = null;

      public $Button1 = null;

 

      function Button1Click($sender, $params)

      {

 

                  $thisreq = 't030s001n123456';

                  $thistype = 'Instant poll';

                  $today = date('Y-m-d');

                  $time1 = date('H:i');

                  $devicename = 'testdb';

 

      $query  = "SELECT * FROM users WHERE num = 1";

      $result = mysql_query($query);

 

 

            while($row = mysql_fetch_array($result, MYSQL_ASSOC))

  {

 

 

      $user = $row['User_Name'];

          }

      $sql = "insert into requests(`Request`,`Request_By`,`Request_Date`,`Customer_ID`,`Request_Time`,`Request_Type`,`Device_Name`)". // indicate all fields here

                  "values ('".$thisreq."','".$user."','".$today."','1','".$time1."','".$thistype."','".$devicename."')";

      $this->dbmapping1->Execute($sql); // Run Insert command

 

      mysql_free_result($result);

 

 

 

 

 

 

      }

 

}

 

global $application;

 

global $Unit15;

 

//Creates the form

$Unit15=new Unit15($application);

 

//Read from resource file

$Unit15->loadResource(__FILE__);

 

//Shows the form

$Unit15->show();

 

?>

 

If two users hit the button at the same time it kills PHP (on IIS) and I have to refresh the page in Apache. I have set up apache using wampserver (:8080) as this seems more robust.

 

I am getting some random errors:

 

 

Warning: session_start() [function.session-start]: open(C:\WINDOWS\TEMP\\sess_ttujau3kokf14fb574c9l2rip6, O_RDWR) failed: Permission denied (13) in C:\Websites\Mapping\vcl\forms.inc.php on line 130

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '80.5.54.164' (10061) in C:\Websites\Mapping\vcl\mysql.inc.php on line 257

 

 

 

Notice:  Undefined index:  file in C:\Websites\Mapping\vcl\classes.inc.php on line 128

 

 

 

Notice:  Undefined index:  line in C:\Websites\Mapping\vcl\classes.inc.php on line 128

 

 

 

Notice:  Undefined index:  line in C:\Websites\Mapping\vcl\classes.inc.php on line 129

 

 

 

Notice:  Undefined index:  file in C:\Websites\Mapping\vcl\classes.inc.php on line 129

 

Application raised an exception class EDatabaseError with message 'Cannot connect to database server'

Click for detailed information

Callstack #0 File: C:\Websites\Mapping\test4.php Line: 183 |_Callstack #1 File: C:\Websites\Mapping\vcl\classes.inc.php Line: 1878 |_Callstack #2 File: C:\Websites\Mapping\vcl\classes.inc.php Line: 1974 |_Callstack #3 File: C:\Websites\Mapping\vcl\classes.inc.php Line: 587 |_Callstack #4 File: Line: |_Callstack #5 File: C:\Websites\Mapping\vcl\classes.inc.php Line: 510 |_Callstack #6 File: C:\Websites\Mapping\vcl\classes.inc.php Line: 1232 |_Callstack #7 File: C:\Websites\Mapping\vcl\db.inc.php Line: 391 |_Callstack #8 File: C:\Websites\Mapping\vcl\system.inc.php Line: 330 |_Callstack #9 File: C:\Websites\Mapping\vcl\mysql.inc.php Line: 76 |_Callstack #10 File: C:\Websites\Mapping\vcl\db.inc.php Line: 431 |_Callstack #11 File: C:\Websites\Mapping\vcl\mysql.inc.php Line: 261

 

 

Warning: Unknown: open(C:\WINDOWS\TEMP\\sess_ttujau3kokf14fb574c9l2rip6, O_RDWR) failed: Permission denied (13) in Unknown on line 0

 

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct () in Unknown on line 0

 

I am presuming the sessions are not starting as there is no permisions set on the SBS server machine. What is the (idiot level please) way to cure the problem.

 

Cheers

 

SteveW

[classic]

sorry the link should be tesdb.php

 

I have set the pup session to c:\windows\temp and can see the sessions being created. We have turned of the just in time debugger. We now get a windows error saying the ??? apache exe has crashed.

 

Getting desperate now any ideas on how to trace this error

[classic]

More information.

 

Please find error log PHP.ini & apache ini .

 

Application popup: httpd.exe - Application Error : The instruction at "0x006aad49" referenced memory at "0x00050014". The memory could not be "read".

 

 

[attachment deleted by admin]