Re: mysql_query() & mail() - something weird is going on !

I had a problem similar to this and it required that we update the mssql.textsize and mssql.textlimit in the php.ini file. Hope that helps, ROn dash php wrote: > > Just a thought: > > How long does that SQL query take? Have you tried setting the timeout period > to be longer than 30 seconds? Take a look at this: > http://www.php.net/manual/en/function.set-time-limit.php > > Another thought: From my experience, sending mail from a Windows host takes > longer than from a *nix host. That could be an issue right there. > > -Dash > > -----Original Message----- > From: Chris Knipe [mailto:savage@savage.za.org] > Sent: Thursday, September 12, 2002 8:25 AM > To: php-windows@lists.php.net; php-general@lists.php.net > Subject: [PHP-WIN] mysql_query() & mail() - something weird is going on ! > > Lo all, > > I get a timeout on line 523 of my code (posted and marked below). However, > I fail to see where the timeout is occurring, and even debugging > (mysql_error()) doesn't report anything wrong! > > I'm baffled as to what exactly is causing this timeout.... The code is > currently on Apache (Win32) with PHP 4.2.3. When I move the code over to a > *nix system, it works perfectly via sendmail_path in php.ini, but when it > calls the SMTP server via a remote address, it fails. > > The mail server's exim-3.36, receiver and sender verification has been > turned off. The mail does go through the mail server. I also tried > bouncing the messages through a local Exchange server, and the result of > this, is that the email get's additional headers that becomes part of the > body! > > Line 523 is indicated with a ** > > <SNIP> > // Insert the Technical Administrator's details into the Database as the > Company > // Administrator. > $MakePassword = new GeneratePassword(16,5); > $Password = $MakePassword->makePassword(); > > $SQL = "INSERT INTO CompanyContacts (ContactActive, CompanyID, "; > $SQL .= "ContactName, IDNumber, EMailAddress, CellNumber, Password) > VALUES ('1', '"; > $SQL .= mysql_escape_string($CompanyID) . "', '" . > mysql_escape_string($_POST['TechName']) . "', '"; > $SQL .= mysql_escape_string($_POST['TechID']) . "', '" . > mysql_escape_string($_POST['TechEMail']) . "', '"; > $SQL .= mysql_escape_string($_POST['TechCell']) . "', > PASSWORD('" . > mysql_escape_string($Password) . "'));"; > $TechRegisterSQL = mysql_query($SQL) or die(mysql_error()); > > // Mail the login details for the Company Administrator, Redirect him to > the login > // page, and we're done!. > $msg = ""; > $msg .= "Dear " . $_POST['TechName'] . ",\n"; > $msg .= "\n"; > $msg .= "Below follows your login details for MegaMonitor. As the > registrar of\n"; > $msg .= " " . $_POST['CompanyName'] . ",\n"; > $msg .= " you have been given the rights of Company Administrator.\n"; > $msg .= "\n"; > $msg .= "This allows you to log in at the MegaMonitor web site, and add > further\n"; > $msg .= "configurations for your company. These may include account > contacts, \n"; > $msg .= "technical contacts, time periods, service checks, and > everything else \n"; > $msg .= "needed to setup monitoring for your company.\n"; > $msg .= "\n"; > $msg .= "You also may request for any number of additional services from > MegaLAN\n"; > $msg .= "Corporate Networking Services, including access to a wider > spectrum of\n"; > $msg .= "monitoring by purchasing more licenses for IP addresses.\n"; > $msg .= "\n"; > $msg .= "MegaLAN Corporate Networking Services also will be offering > other\n"; > $msg .= "excellent value added services over the not to distant future. > We are\n"; > $msg .= "hard at work to get these up and running, and as a client, we > will notify\n"; > $msg .= "you when they become available. Some of these services > include:\n"; > $msg .= "\n"; > $msg .= " - MegaMAIL, a e-mail virus scanning service for corporates. > We scan all\n"; > $msg .= " in and outgoing e-mails on your behalf to ensure > your company\n"; > $msg .= " does not get infected with viruses via > e-mail.\n"; > $msg .= " - MegaDNS, a DNS hosting and administrating service for > corporates,\n"; > $msg .= " where we will provide access to DNS > administrative tools, as\n"; > $msg .= " well as secondary domain hosting - free of > charge.\n"; > $msg .= "\n"; > $msg .= "To log in to MegaMonitor and configure your company's profile, > please visit\n"; > $msg .= "http://www.imadethis.co.za/login.php\n"; > $msg .= "\n"; > $msg .= "Your Username: " . $_POST['TechEMail'] . "\n"; > $msg .= "Your Password: " . $Password . "\n"; > $msg .= "\n"; > $msg .= "You may change your password at anytime via our administrative > interface on\n"; > $msg .= "our web site.\n"; > $msg .= "\n"; > $msg .= "Thank you for your interest in MegaMonitor, and we hope we will > benefit\n"; > $msg .= "your company tremendously.\n"; > $msg .= "\n"; > $msg .= "MegaLAN Customer Support.\n"; > $msg .= "\n"; > mail($_POST['TechEMail'], "MegaMonitor Registration Details", $msg, > "From: MegaLAN Customer Support <support@imadethis.co.za>\r\n"); > > // Mail everything to MegaLAN support for confirmation. > // Look up the bank name in the Database. > ** $BankQuery = mysql_query("SELECT BankName FROM GlobalBankNames WHERE > BankID='" . mysql_escape_string($_POST['BankInstitution']) . > "';") or die > (mysql_error()); > while ($BankList = mysql_fetch_array($BankQuery)) { > $BankLongName = $BankList['BankName']; > } > if ($_POST['BankAccountType'] == "3") { > $BankAccountTypeLong = "Cheque Account"; > } elseif ($_POST['BankAccountType'] == "2") { > $BankAccountTypeLong = "Transmission Account"; > } elseif ($_POST['BankAccountType'] == "1") { > $BankAccountTypeLong = "Savings Account"; > } else { > // We should never get this!!! > $BankAccountTypeLong = "Error - Confirm with Client"; > } > > $msg = ""; > $msg .= "New company registration for MegaMonitor service:\n"; > $msg .= "-------------------------------------------------\n"; > $msg .= "Company Name: " . $_POST['CompanyName'] . " (ID: > $CompanyID)\n"; > $msg .= "Telephone Number: " . $_POST['TelNumber'] . " Fax > Number: " > . $_POST['FaxNumber'] . "\n"; > $msg .= "\n"; > $msg .= "Physical Address:\n"; > $msg .= " " . $_POST['PhysAddress1'] . "\n"; > $msg .= " " . $_POST['PhysAddress2'] . "\n"; > $msg .= " " . $_POST['PhysTown'] . "\n"; > $msg .= " " . $_POST['PhysCode'] . "\n"; > $msg .= "\n"; > $msg .= "Postal Address:\n"; > $msg .= " " . $_POST['PostAddress1'] . "\n"; > $msg .= " " . $_POST['PostAddress2'] . "\n"; > $msg .= " " . $_POST['PostTown'] . "\n"; > $msg .= " " . $_POST['PostCode'] . "\n"; > $msg .= "\n"; > $msg .= "Banking Details:\n"; > $msg .= " Bank Name " . $BankLongName . "\n"; > $msg .= " Account Type " . $BankAccountTypeLong . "\n"; > $msg .= " Branch " . $_POST['BankBranch'] . "\n"; > $msg .= " Account Number " . $_POST['BankAccount'] . "\n"; > $msg .= "\n"; > $msg .= "Technical Administrator Details:\n"; > $msg .= " " . $_POST['TechName'] . " (" . > $_POST['TechEMail'] . ")\n"; > $msg .= " Contact Number " . $_POST['TechCell'] . "\n"; > $msg .= " ID Number " . $_POST['TechID'] . "\n"; > $msg .= "\n"; > $msg .= "\n"; > mail("c.knipe@imadethis.co.za", "MegaMonitor Company Registration > Details", $msg, > "From: MegaLAN Customer Support <support@imadethis.co.za>\r\n"); > ?> > <table border="0" cellpadding="5" cellspacing="0" > height="100%" > width="100%"> > <tbody> > </SNIP> > > I really don't see anything wrong here at all!!! > > HELP! ;) > > -- > me > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php