SQLite3 extension

[brisargr]

Issue Summary

Error message that SQLite3 extension is missing and have no clear what to do.

Troubleshooting Questions

• Does this happen for all sites in Local, or just one in particular? All

• Are you able to create a new, plain WordPress site in Local and access it in a Browser? YES

Replication

Fresh install of Wordpress, install Hello theme, install Elementor, Install PhastPress. Receive the following error:
Sorry, PhastPress requires a PHP extension that is not installed.

The PDO extension needs to be installed with the SQLite3 database driver available.
Currently we’re getting this error: could not find driver

Sorry, PhastPress requires a PHP extension that is not installed.

The PDO extension needs to be installed with the SQLite3 database driver available.
Currently we’re getting this error: could not find driver

Ask your hosting provider to install the [PDO_SQLITE extension], or downgrade to [PhastPress 2.1]

System Details

• Which version of Local is being used? Latest fresh install

• What Operating System (OS) and OS version is being used? Windows 11 Professional

  • For example: macOS Catalina or Windows 10 Professional

• Attach the Local Log. See this Help Doc for instructions on how to do so:

  • Retrieving Local’s Log
    local-logs.zip (51.7 KB)

Security Reminder

Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

[Nick-B]

@brisargr

SQLite3

Hi @brisargr!

PDO is enabled on the latest versions of PHP within Local. If you open PHP info in Local, you can ctrl-f for PDO and see which drivers it is compiled with - in this case, we only compile with MySQL.

What is your OS and what PHP version are you utilizing?

Lastly, we also have a feature request for SQLite3 support which I’ll link below if you want to vote and comment!

SQLite Support?

Is Local ever going to support SQLite? People keep asking about it, and the answer is always “Local is optimized for WordPress”…and some links to articles about PECL and compiling PHP extensions. Is anyone on the Local team aware that SQLite isn’t a PECL supported package anymore and hasn’t been since 2008? SQLite is part of the default PHP package, and the Local team removes it by compiling with the following flags: ‘–without-sqlite3’ ‘–without-pdo-sqlite’ What does removing SQLite have to d…