Bug #78957 [Fbk->Csd]: pdo_sqlite extension does not load after upgrading from 7.3.12 to 7.4.0
Edit report at https://bugs.php.net/bug.php?id=78957&edit=1
ID: 78957
User updated by: silverwoodchuck47 at yahoo dot com
Reported by: silverwoodchuck47 at yahoo dot com
Summary: pdo_sqlite extension does not load after upgrading
from 7.3.12 to 7.4.0
-Status: Feedback
+Status: Closed
Type: Bug
Package: PDO SQLite
Operating System: Win7-32/Apache 2.24.41
PHP Version: 7.4.0
Block user comment: N
Private report: N
New Comment:
So this is not a bug, but a change in how to install PHP that is not documented in https://www.php.net/manual/en/migration74.windows-support.php.
Previous Comments:
------------------------------------------------------------------------
[2019-12-16 00:41:16] silverwoodchuck47 at yahoo dot com
I finally figured it out.
Copy libsqlite3.dll that comes with php (in my case, php-7.4.0-Win32-vc15-x86.zip) to somewhere in
the Windows path (in my case, I chose c:\windows\). Then restart the web server. Go to
phpinfo.php: that shows the PDO drivers: sqlite and SQLite Library 3.30.1.
So this is not a bug, but a change in how to install PHP that is not documented in https://www.php.net/manual/en/migration74.windows-support.php.
Please close this bug report.
------------------------------------------------------------------------
[2019-12-13 16:15:01] silverwoodchuck47 at yahoo dot com
How much troubleshooting have you done?
As much as I can do. That's why I wrote this bug report.
Any errors?
Yes, as shown in Actual result.
And are you using libsqlite >= 3.5.0 as stated in the documentation?
I don't know. How does one check? It doesn't show up in phpinfo. Should it?
The sentence "As of PHP 7.4.0 » libsqlite ⥠3.5.0 is required." in the
documentation is not helpful to me. The link goes to the sqlite website, but there is no
"libsqlite" file that I can find. Does "libsqlite" refer to
"libsqlite3.dll" that comes with the php-7.4.0-Win32-vc15-x86.zip? If it does, can the
documentation be improved for those of us who are not professional programmers?
------------------------------------------------------------------------
[2019-12-13 04:13:29] requinix@php.net
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
How much troubleshooting have you done? Any errors?
And are you using libsqlite >= 3.5.0 as stated in the documentation?
https://www.php.net/manual/en/ref.pdo-sqlite.php
------------------------------------------------------------------------
[2019-12-13 02:25:05] silverwoodchuck47 at yahoo dot com
Description:
------------
My scripts that depend on sqlite don't work work anymore because pdo_sqlite extension does not
load. It works for 7.3.12, but not 7.4.0.
Test script:
---------------
$dbhnd = new PDO("sqlite:". $database);
Expected result:
----------------
I expect that if I replace php 7.3.12 with 7.4.0 AND there's no mention of removing sqlite
extension from PHP core, that php scripts that depend on the sqlite extension to work.
All other extensions ("gd", "mbstring", "exif", "xsl") load
just fine. pdo_sqlite does not.
Actual result:
--------------
For example, one error message is
PDOException: could not find driver in D:\xxx\x.php:110 Stack trace: #0 D:\xxx\x.php(110):
PDO->__construct('sqlite:lkp/lkpM...') #1 D:\yyy\y.php(65):
include('D:\\Data\\xxx\\i...') #2 {main}
Another
PDOException: could not find driver in D:\xxx\x.php:42 Stack trace: #0 D:\Data\xxx\x.php(42):
PDO->__construct('sqlite:lkp/lkpM...') #1 {main}
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=78957&edit=1
Thread (5 messages)