Bug #76648 [NEW]: I don't show warning in execute SQL on PostgreSQL, when script run on PHP 64bit
| From: | slawek_x at o2 dot pl | Date: | Thu, 19 Jul 2018 21:06:52 +0000 |
| Subject: | Bug #76648 [NEW]: I don't show warning in execute SQL on PostgreSQL, when script run on PHP 64bit | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-216374@lists.php.net to get a copy of this message | ||
From: slawek_x at o2 dot pl
Operating system: MS Windows 7/10 64bit
PHP version: 7.2.8
Package: PostgreSQL related
Bug Type: Bug
Bug description:I don't show warning in execute SQL on PostgreSQL, when script run on PHP 64bit
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 bug report at https://bugs.php.net/bug.php?id=76648&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=76648&r=trysnapshot54
Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=76648&r=trysnapshot55
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=76648&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=76648&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=76648&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=76648&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=76648&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=76648&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=76648&r=support
Expected behavior: https://bugs.php.net/fix.php?id=76648&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=76648&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=76648&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=76648&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=76648&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=76648&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=76648&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=76648&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=76648&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=76648&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=76648&r=mysqlcfg