Comments/Ratings for a Single Item

When I restored the site, MariaDB 10 kept losing connections. To get the database to work, I replaced MariaDB 10 with MariaDB 5. In doing this, I manually edited the database backup to make it compatible with MariaDB 5, and one change I made was to remove all the FULLTEXT keys, which were what enabled it to search through the text of comments. I expect the code that exists for searching the text of comments uses special features of MariaDB 10 that are not a part of MariaDB 5, and that is why your search did not work.

Are there any plans to restore this functionality? Not sure whether the ongoing procedures with backups ⁊c make this a more or less opportune time to look into this, so if the latter it can ofc wait, but it'd be good to have it back eventually

It depends on a feature of MariaDB 10, but when I restored the server earlier this year, MariaDB 10 was frequently losing the connection to the database, and MariaDB 5 proved more reliable. So, I switched to MariaDB 5 and manually removed the details that required 10. On the new server, I have installed Rocky Linux 8, PHP 8, and MariaDB 10. Since it also has reverse DNS, which should make email more likely to be delivered, I have plans to make it the main server when everything is working correctly on it. For now, I have to update scripts to work with PHP 8. The new server has less storage space, but it has more than enough for the site. It has less RAM, but this server usually doesn't use even half the available RAM. Both sites have 4 cores, and the new VPS uses faster CPUs. Although the new server is on chessvariants.org, it will not support comment search until I add support for this back into the database. To start with, I will look into updating to MariaDB 10 on this server.

My attempt to update chessvariants.com to MariaDB 10 has not been successful, and I have been unable to revert to MariaDB 5.5 without errors. So, chessvariants.com is currently without a working database. At least I made a backup and copied it to chessvariants.org. If the problem on chessvariants.com continues, I might not continue with HostSlayer. As long as I have things backed up on RackNerd, I may try reinstalling the OS on HostSlayer. But for now, I have floaters in my eyes, and I need to have lunch.

Since I haven't gotten MariaDB to work on the original server, I switched the domains of the servers. However, there are still things to fix, and I still have to deal with the original server.

There appears to be some kind of corruption from the MariaDB 10 installation that is preventing a reinstallation of MariaDB 5.5 from working. When I check its status after reinstalling version 5.5, it says "Failed to start MariaDB 10.6.4 database server." I expect I will have to reinstall CentOS, but I don't want to get it started right now, because it is late. Unfortunately, the new VPS also seems to be having issues with MariaDB 10. It frequently loses connection with the MySQL server, and I have to refresh a page a few times before it connects.

Are there any plans to restore this functionality?

I tried to yesterday and failed. I have not been able to get MariaDB 10 to work reliably on either server, HostSlayer or RackNerd. It used to work before I tried updating the HostSlayer VPS to Rocky Linux via updating to CentOS 8 first. So, maybe there is some setting that has to be corrected. For now, chessvariants.com runs on HostSlayer with CentOS 7, PHP 7, and MariaDB 5.5, while chessvariants.org runs on RackNerd with Rocky Linux 8, PHP 8, and MariaDB 10. Until I can get things working correctly on the new RackNerd VPS, I will continue to use MariaDB 5.5, and comment searching will remain disabled.