Bug #76648 [Opn->Nab]: I don't see warnings for execute SQL on PostgreSQL, when script run on PHP 64bit
Edit report at https://bugs.php.net/bug.php?id=76648&edit=1
ID: 76648
Updated by: cmb@php.net
Reported by: slawek_x at o2 dot pl
Summary: I don't see warnings for execute SQL on PostgreSQL,
when script run on PHP 64bit
-Status: Open
+Status: Not a bug
Type: Bug
Package: PostgreSQL related
Operating System: MS Windows 7/10 64bit
PHP Version: 7.2.8
-Assigned To:
+Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
> Additional I think the problem may arise from the use of the
> 32bit libpq.dll version for the 64 bit extension in PHP.
You simply can't load a 32bit DLL into a 64bit process. Why don't
you use a 64bit libpq.dll?
Previous Comments:
------------------------------------------------------------------------
[2018-07-19 21:17:42] slawek_x at o2 dot pl
Correct title
------------------------------------------------------------------------
[2018-07-19 21:06:51] slawek_x at o2 dot pl
Description:
------------
I use Apache 2.4.33 version 64bit for Windows with language PHP 7.2.7 (64bit).
I connected to database PostgreSQL 10.4 (64bit) for Windows from PHP - module PostgreSQL
(ext\php_pgsql.dll).
When I execute PHP wrong the code SQL then extension PostgreSQL for PHP don't show warnings.
This page with wrong code execute/load long time and finally the page is empty. No further PHP code
of webpage is executed.
I noticed so that problems don't have with wrong SQL, when I run webpage in environment 32bit -
Apache and PHP are 32bit version.
Extension Postgresql show warnings when I probably run wrong code SQL.
I tested different PHP 64bit: 7.2.4, 7.2.5, 7.2.6, 7.2.7 and 7.2.8 (download from https://windows.php.net/download/ (version VC15 x64
Thread Safe).
All versions 64bit don't show error when PostgreSQL returns messages as warnings.
While 32bit versions execute the code SQL for PostgreSQL as correctly, The error is message about
warnings.
Additional I think the problem may arise from the use of the 32bit libpq.dll version for the 64 bit
extension in PHP.
In php.ini always I use this the same settings in 32bit and 64bit PHP.
The files php.ini are identical in both versions.
Test script:
---------------
pg_query('SELECT 1 FROM parent');
/*
1) version 32bit PHP:
Warning: pg_query(): Query failed: ERROR: relation "parent" does not exist LINE 1: SELECT
1 FROM parent ^ in (...)
The code of PHP is executed to the end of webpage.
2) version 64bit PHP:
No warning. The webpage is blank, long time browser is waiting on load webpage.
The code of PHP isn't executed to the end of webpage.
*/
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=76648&edit=1
Thread (5 messages)