Apache Friends Support Forum

Hello XAMPP Team,

When we install XAMPP and we start, error: libsqlite3.dll is missing.

After several months/years, the problem is always here in xampp-windows-x64-7.4.14-0-VC15 and other I think.

Can you solve this problem into all builds and do not remove it?
Can you fix the conf?

In \xampp\apache\conf\extra\httpd-xampp.conf

Search:
LoadModule php7_module "/xampp/php/php7apache2_4.dll"

Add after:
LoadFile "/xampp/php/libsqlite3.dll"

Thanks in advance.

Hi Neustradamus,

Thank you for reporting this. Unfortunately, I haven't been able to reproduce your issue. Can you give us more details on this? Which filename are you using exactly? Which is your Windows version?

I tested all files from SourceForge without facing any issues starting Apache or MySQL and getting to the phpinfo page using the browser. I used Windows Server 2019 to test them

Clean install on Windows, the \xampp\apache\conf\extra\httpd-xampp.conf has not:
- LoadFile "/xampp/php/libsqlite3.dll"

All installer must be solved.

Hi,

According to the test I did, adding that line in the configuration was not necessary, as Apache started fine. I tested all files available in SourceForge for Windows version 7.4.14-0. Can you give us more info? We would like to reproduce the issue.

I confirm that you must to delete all XAMPP data from you machine, install again, apache does not work, the solution is:

In \xampp\apache\conf\extra\httpd-xampp.conf

Search:
LoadModule php7_module "/xampp/php/php7apache2_4.dll"

Add after:
LoadFile "/xampp/php/libsqlite3.dll"

Thanks to solve the problem in all builds.

Hi Neustradamus,

Sorry for the late reply. I have been trying to reproduce this issue but I couldn't. I launched a fresh new server in which no other XAMPP installation has been performed previously and starting Apache worked just fine. I also tried with a Windows 10 VM on my local computer without issues.

Just in case, can you double-check that you execute the setup_xampp.bat script before opening the control panel and trying to start the Apache process?

Can you give us any other information to try to reproduce it?

Reproduce:
Load either of the php sqlite extensions.

Problem: (the web of depencies)
When I look at the php.ini files in xampp 7.3, 7.4 & 8.0 7z packages I see pdo_sqlite3 being loaded out of box.

This wasn't a problem in versions prior to 7.4 because the sqlite library was compiled into the extensions. Beginning with php 7.4 they are linking the extensions to a shared library (libsqlite3.dll) which becomes a dependency of php's. You can see the difference looking at the files sizes of the php extensions between 7.3 & 7.4.

Apache in xampp loads php as a module and like any other module in Apache (deflate, http2, lua, md, ssl, xml2enc), their dependencies need to be in Apache's bin folder, or using LoadFile, or in the system's path.

Thank you gsmith for your investigation and the detailed information. We reproduced the issue and we are working on releasing a new version fixing this. I will post another message here once we release it.

Regards,
Gonzalo

Just a quick note to let you know that versions 7.3.27-1, 7.4.16-0 and 8.0.3-0 include the fix for these issue.