After WP Update 6.5.2 My Website doesn’t work anymore

Thanks for reaching out @salem80. The message you get regarding a MySQL update isn’t specific to the SQLite plugin. As this plugin must be installed on an existing WordPress site (with a MySQL database), the site must fulfill all WordPress 6.5.2 requirements. This is particularly true as some users may wish to revert back to a MySQL database.

BTW I don’t have MySQL installed on my VPS server.

This may be the cause of the fatal error on this particular site. Is the SQLite plugin is deactivated, it should fall back to a standard MySQL database. If you’re stating you don’t have MySQL installed, do you recall having MySQL installed at some stage for this site? If you have access to the sites wp-admin, feel free to share your Site Health information and we can take a look.

Is the SQLite plugin is deactivated

No, before I upgrade it was not disable .

do you recall having MySQL installed at some stage for this site?

No I didn’t install MySQL on my server at all, I use SQLite plugin for years because it is easy to deal with (backup immigration etc.)

If you have access to the sites wp-admin,

No I can’t access it, but my website main/inner pages are working fine now after I checki,

Anyway this is some important info from my php info file

PHP Version 8.0.30

Build System AlmaLinux release 9.2
Server API FPM/FastCGI
Additional .ini files parsed /etc/php.d/10-opcache.ini, /etc/php.d/20-bz2.ini, /etc/php.d/20-calendar.ini, /etc/php.d/20-ctype.ini, /etc/php.d/20-curl.ini, /etc/php.d/20-dom.ini, /etc/php.d/20-exif.ini, /etc/php.d/20-fileinfo.ini, /etc/php.d/20-ftp.ini, /etc/php.d/20-gd.ini, /etc/php.d/20-gettext.ini, /etc/php.d/20-iconv.ini, /etc/php.d/20-pdo.ini, /etc/php.d/20-phar.ini, /etc/php.d/20-simplexml.ini, /etc/php.d/20-sockets.ini, /etc/php.d/20-sqlite3.ini, /etc/php.d/20-tokenizer.ini, /etc/php.d/20-xml.ini, /etc/php.d/20-xmlwriter.ini, /etc/php.d/20-xsl.ini, /etc/php.d/30-pdo_sqlite.ini, /etc/php.d/30-xmlreader.ini
PHP API 20200930
PHP Extension 20200930
Zend Extension 420200930
allow_url_fopen On
display_errors Off
display_startup_errors Off
file_uploads On
hard_timeout 2
max_execution_time 30
max_file_uploads 20
max_input_time 60
memory_limit 128M
post_max_size 8M
cURL support enabled
SSL Version OpenSSL/3.0.7
json support enabled
libXML support active
OpenSSL support enabled
PDO drivers sqlite
SQLite Library 3.34.1
Session Support enabled
SQLite Library 3.34.1
$_SERVER[‘REQUEST_SCHEME’] https
$_SERVER[‘SERVER_SOFTWARE’] nginx/1.20

Appreciate the update @salem80.

No I didn’t install MySQL on my server at all, I use SQLite plugin for years because it is easy to deal with (backup immigration etc.)

In order to install the SQLite database integration plugin you would have had to have a live WordPress site using a MySQL database. This was always a requirement when the plugin was introduced in December 2022 (as part of the Performance Lab plugin).

Are you able to set up a new WordPress site using 6.5.2, before testing the plugin on a new install?

Hello,

I have the same problem here.

I can’t access the wp-admin after updating WordPress 6.5.2, the site asks me to upgrade the database but it comes with this error:

Error: WordPress 6.5.2 requires MySQL 5.5.5 or higher.

The site is set up with SQLite and so far everything was working fine.

The public site is accessible but there is no way to access the wp-admin to rollback…

Any suggestions on how to access avoiding the upgrade to rollback?

Thanks

Sorry to hear that @rafaelcosquiere. Have you tried upgrading your MySQL database from your hosting control panel? Alternatively, you can revert back to your MySQL database if you wish, as and then update your MySQL database, before then activing the SQLite Database Integration once more. This will also allow you to active your wp-admin panel, although your content and other details may be contained only in your SQLite database.

If you do wish to switch back to your MySQL database temporarily, what you can try, it so manually deactivating the SQLite Database Integration plugin by renaming the plugin via renaming the plugin directory (wp-content/plugins/sqlite-database-integration).

After renaming your plugin directory, it will revert back to your MySQL database. You can then update your MySQL database if you wish, and then switch back to your SQLite database be renaming the plugin directory once more, to the correct directory name previously used.

If you have any questions on this, please open an individual support topic and we can discuss your case individually from there.

In order to install the SQLite database integration plugin you would have had to have a live WordPress site using a MySQL database. This was always a requirement when the plugin was introduced in December 2022 (as part of the Performance Lab plugin).

@jamesosborne Hello, this is absolutely not true. I have never installed MySQL, which is precisely why I used the SQLite plugin. I do not want to install MySQL on my server. This update was installed automatically on my server, and now I cannot access WordPress. What a mess!

@marcobarrios Can you share what database you were using before you used the SQLite Database Integration plugin? You would have had to be using an existing WordPress site in order to install the plugin. Once I know more on your set up I can check this further.

I finally solved my problem and now i can access to wp-admin

I have to say that I don’t have MySQL installed and the original installation was done through this repo: https://github.com/aaemnnosttv/wp-sqlite-db which is base on Kojima Toshiyasu SQLlite intragration original.

How did I solve the problem?

I think the problem comes from the /wp-content/db.php file, where the version the returns is ‘5.5’ and should be ‘8.0’

What I did to solve it is to replace the db.php file with this one: https://raw.githubusercontent.com/pollopolea/wp-sqlite-db/master/src/db.php

Which in its functions ‘version’ and ‘db_version’ returns 8.0. And that solves the problem.

Hope this will solve your problem too.

• This reply was modified 10 months, 1 week ago by Rafael Cosquiere.

Appreciate your input @rafaelcosquiere. I’ll check this with the team and report back to you here. Hopefully this is also of use to others.

@rafaelcosquiere That’s amazing man it’s solved my problem immediately , I got support from WP community as usual more what I got for it developers

I cant’update my wordpress site, I’m getting identical error as this topic.

It keeps saying that I have MySQL 5.5.5, but my MySQL version is actually 7.4 (I downgraded to try to update).

I uploaded the db.php file linked here, buth then my site asks me for a new installation.

How can I solve? Thanks in advance.