php-windows Digest 14 Feb 2006 04:10:59 -0000 Issue 2887
Topics (messages 26692 through 26697):
Re: PDO with prepared statements
26692 by: Travis Raybold
Upload files problem
26693 by: Ing. Tomás Liendo
26694 by: trystano.aol.com
Strange access violation
26695 by: Dbird..
26696 by: Dbird..
26697 by: Armando
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
looks like this is a bug with 5.1.1 and 5.1.2, but works with 5.1.0.
http://bugs.php.net/bug.php?id=35671
--trabis
Travis Raybold wrote:
i'm using PHP 5.1.2, and trying to manipulatre a database with
PDO_ODBC accessing a MS SQL Server database. i can execute normal
queries with no problem. but when i start executing prepared
statements i run into problems. has anyone successfully used multiple
parameter prepared statements with MSSQL and PDO? one thing that would
help is if i could get the full text of whatever PDO is trying to send
to SQL Server, does anyone know of a way to get that?
i set up a test table zTestTable, with a TestID autoincrement primary
key int, a Test (nvarchar(200)) and a TestNumber(int). when i execute
the following code, it inserts a row with the value 1 for Test and
TestNumber. the same thing happens if i try to use ? parameters
instead of named parameters.
$oConnection = new PDO($sDSN);
$sSQL = 'INSERT INTO zTest_TBL (Test, TestNumber) VALUES (:Test,
:TestNumber) ';
$oStatement = $oConnection->prepare($sSQL);
$s='test insert string passing an array to execute';
$i=1;
$oStatement->execute(array(':Test'=>$s,':TestNumber'=>$i));
print_r($oStatement->errorInfo());
the second bit of code is an attempt to bind parameters and run the
same insert. this one inserts a row with NULLs for Test and TestNumber.
$oConnection = new PDO($sDSN);
$sSQL = 'INSERT INTO zTest_TBL (Test, TestNumber) VALUES (:Test,
:TestNumber) ';
print $sSQL;
$oStatement = $oConnection->prepare($sSQL);
$s2='test insert string binding a parameter';
$oStatement->bindParam(':Test', $s2, PDO::PARAM_STR);
$oStatement->bindParam('TestNumber', $i, PDO::PARAM_INT);
$oStatement->execute();
thanks in advance,
--travis
--- End Message ---
--- Begin Message ---
Hi I have problems to upload files...
The error: "failed to open stream: Permission denied"
I just deactivated the read-only option of the upload folder but I still
having the same problem...
What can I do?
Thank you,
Tom.
--- End Message ---
--- Begin Message ---
You need to set the correct permissions on the folder inwhich you want to
upload the files into.
Tryst
--- End Message ---
--- Begin Message ---
I'm running php version 4.3.7 on Windows 2003 Server and IIS 6.0
I have several websites which are all using php extensively but I have one
website where I am consistantly getting the following error:
"PHP has encountered an Access Violation at 01930AFD"
The error occurrs on every page, but where on the page it shows up varies.
I have NO loss of functionality on the website so this really has me
baffled.
Where is the error coming from? How can I find out more information as to
the source of the error? How can I simply remove that error message from
being displayed into my web pages and wreaking havoc on their format?
I've been on this one for a couple of days and I'm really stumped on this
one.
Thanks in advance.
--- End Message ---
--- Begin Message ---
To make this even more interesting is that when I reboot the server, the
error goes away for a period of time, usually about 30 minutes.
Any ideas?
""Dbird.."" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'm running php version 4.3.7 on Windows 2003 Server and IIS 6.0
>
> I have several websites which are all using php extensively but I have one
> website where I am consistantly getting the following error:
> "PHP has encountered an Access Violation at 01930AFD"
>
> The error occurrs on every page, but where on the page it shows up varies.
> I have NO loss of functionality on the website so this really has me
> baffled.
>
> Where is the error coming from? How can I find out more information as to
> the source of the error? How can I simply remove that error message from
> being displayed into my web pages and wreaking havoc on their format?
>
> I've been on this one for a couple of days and I'm really stumped on this
> one.
>
> Thanks in advance.
--- End Message ---
--- Begin Message ---
If it goes away on a server reboot for a period of time, then it sounds
suspiciously like a memory leak, ie; the application is trying to
reference an area of memory it doesn't have access to. I've seen this
problem with other applications... they'd run fine for a period of time
after a reboot then start throwing out errors in the event log. Reboot,
fine for another period of time. Maybe check your event log for any
errors? Can you perhaps expand on the differences between this site and
your others? Are there other modules it's using that your other sites
are not? Cheers.
Armando
Dbird.. wrote:
To make this even more interesting is that when I reboot the server, the
error goes away for a period of time, usually about 30 minutes.
Any ideas?
""Dbird.."" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
I'm running php version 4.3.7 on Windows 2003 Server and IIS 6.0
I have several websites which are all using php extensively but I have one
website where I am consistantly getting the following error:
"PHP has encountered an Access Violation at 01930AFD"
The error occurrs on every page, but where on the page it shows up varies.
I have NO loss of functionality on the website so this really has me
baffled.
Where is the error coming from? How can I find out more information as to
the source of the error? How can I simply remove that error message from
being displayed into my web pages and wreaking havoc on their format?
I've been on this one for a couple of days and I'm really stumped on this
one.
Thanks in advance.
--- End Message ---
