Doc #78957 [ReO->Csd]: pdo_sqlite extension does not load after upgrading from 7.3.12 to 7.4.0
| From: | cmb@php.net | Date: | Mon, 16 Dec 2019 09:36:07 +0000 |
| Subject: | Doc #78957 [ReO->Csd]: pdo_sqlite extension does not load after upgrading from 7.3.12 to 7.4.0 | ||
| References: | 1 | Groups: | php.doc.bugs |
| Request: | Send a blank email to doc-bugs+get-17131@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=78957&edit=1
ID: 78957
Updated by: cmb@php.net
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: Re-Opened
+Status: Closed
Type: Documentation Problem
Package: PDO SQLite
Operating System: Win7-32/Apache 2.24.41
PHP Version: 7.4.0
Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
This bug has been fixed in the documentation's XML sources. Since the
online and downloadable versions of the documentation need some time
to get updated, we would like to ask you to be a bit patient.
Thank you for the report, and for helping us make our documentation better.
Previous Comments:
------------------------------------------------------------------------
[2019-12-16 09:35:44] cmb@php.net
Automatic comment from SVN on behalf of cmb
Revision: http://svn.php.net/viewvc/?view=revision&revision=348532
Log: Fix #78957: pdo_sqlite extension does not load after upgrading from 7.3.12 to 7.4.0
------------------------------------------------------------------------
[2019-12-16 00:41:59] silverwoodchuck47 at yahoo dot com
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.
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=78957
--
Edit this bug report at https://bugs.php.net/bug.php?id=78957&edit=1