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