libsqlite3.dll (present but) not found

Problems with the Windows version of XAMPP, questions, comments, and anything related.

libsqlite3.dll (present but) not found

Postby pschleppi » 09. January 2020 11:27

Hi,

I have a fresh install of XAMPP 3.4.2. When starting Apache, there is an error message telling that libsqlite3.dll could not be found. This message appers even twice. In the log, there are the lines given below. Nevertheless, the Apache modules becomes green on XAMPP's control panel and localhost is available. I tried to set up an SQLite database as described in the documentation (/dashboard/docs/use-sqlite.html), but it fails with the eror that sqlite3 is not recognised as a command. In phpinfo, sqlite is missing.
The strange thing is that the libsqlite3.dll file is present in the php folder. It is a version dated 2019-12-17.I tried to register this DLL with regsvr32, just out of my general knowledge about DLLs. No success. Another DLL mentioned in the log (see below) is php_pdo_sqlite.dll. It is also present, in the ext folder under php.
Is there a way to correct this problem?

Patrick
--

[Thu Jan 09 10:51:56.059482 2020] [mpm_winnt:notice] [pid 1432:tid 252] AH00455: Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.4.1 configured -- resuming normal operations
[Thu Jan 09 10:51:56.059482 2020] [mpm_winnt:notice] [pid 1432:tid 252] AH00456: Apache Lounge VC15 Server built: Aug 11 2019 12:20:04
[Thu Jan 09 10:51:56.059482 2020] [core:notice] [pid 1432:tid 252] AH00094: Command line: 'c:\\internet\\xampp\\apache\\bin\\httpd.exe -d C:/Internet/Xampp/apache'
[Thu Jan 09 10:51:56.059482 2020] [mpm_winnt:notice] [pid 1432:tid 252] AH00418: Parent: Created child process 3176
[Thu Jan 09 10:51:56.543082 2020] [ssl:warn] [pid 3176:tid 264] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Thu Jan 09 10:51:56.621083 2020] [ssl:warn] [pid 3176:tid 264] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlite' (tried: C:\\Internet\\Xampp\\php\\ext\\pdo_sqlite (Le module sp\xc3\xa9cifi\xc3\xa9 est introuvable.), C:\\Internet\\Xampp\\php\\ext\\php_pdo_sqlite.dll (Le module sp\xc3\xa9cifi\xc3\xa9 est introuvable.)) in Unknown on line 0
[Thu Jan 09 10:51:58.541486 2020] [mpm_winnt:notice] [pid 3176:tid 264] AH00354: Child: Starting 150 worker threads.
pschleppi
 
Posts: 2
Joined: 09. January 2020 09:50
XAMPP version: 3.2.4
Operating System: Windows 7 64 bit

Re: libsqlite3.dll (present but) not found

Postby gsmith » 09. January 2020 19:46

Copy the one from the php folder to Apache's bin folder.
gsmith
 
Posts: 265
Joined: 29. November 2013 18:04
Location: San Diego
XAMPP version: 0.0.0
Operating System: Win 10/2012R VS 14,15,16

Re: libsqlite3.dll (present but) not found

Postby pschleppi » 10. January 2020 23:10

Thank you gsmith!
This was the solution! The file was there, but not at the right place.

Cheers.

Patrick
pschleppi
 
Posts: 2
Joined: 09. January 2020 09:50
XAMPP version: 3.2.4
Operating System: Windows 7 64 bit

Re: libsqlite3.dll (present but) not found

Postby master777 » 02. March 2020 02:06

gsmith wrote:Copy the one from the php folder to Apache's bin folder.


Hi gsmith,

I registered only to thank you. I had the same problem but copying the file was the solution.

Thank you again!
master777
 
Posts: 1
Joined: 02. March 2020 02:02
XAMPP version: v3.2.4
Operating System: Windows 7 Home Premium

Re: libsqlite3.dll (present but) not found

Postby rene-n » 30. March 2020 07:44

Alternatively, you might want to make sure that libsqlite3.dll is referenced in the PATH environment variable when httpd is started.
rene-n
 
Posts: 1
Joined: 29. March 2020 18:54
XAMPP version: 3.2.4
Operating System: Windows 10 / 64bit

Re: libsqlite3.dll (present but) not found

Postby Altrea » 30. March 2020 08:56

XAMPP tries to avoid using the PATH variable, registry, etc. All needed settings and files should be inside the xampp folder for portability reasons.
There are a few exceptions from this like the uninstaller or using windows services to autostart components, but a simple dll should not be such a reason.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10265
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 71 guests