fix a wordpress database

[Vegan]

my wordpress database has a horror story for an error, a comma for a period

wordpress based solutions did not work, I even dumped the database and manually made changes and the error persisted

only thing that comes to mind is a lock on the database but no error was noted on the command line with mysql < dump.sql restore

[Benjamin]

What is the error message?

[Vegan]

seems that the database is locked and when i attempt a lock it is not activating and the error persists

so I wiped the machine and installed linux for 99th time after manually cleaning up the SQL file

now a new class of problem with Apache2,

This site can’t provide a secure connection

www.hardcoregames.ca sent an invalid response.

Try running Windows Network Diagnostics.
ERR_SSL_PROTOCOL_ERROR

[Vegan]

After hours of reading useless manuals and a boatload of reconfigurations I was able to get my vhost working albeit with a hard coded URL in the wp-config.php file to the site would render, without it the site comes up with no CSS properly etc and I cannot even get the admin area opened at all

with the URL hardcoded the site renders

so now the puzzle is how to fix the rendering mess

[Benjamin]

Check the error_log file. Are you accessing the site from the host machine? If so the VM hosts file needs to have the external IP address not 127.0.0.1.

[Vegan]

I ended up installing linux fresh and manually cleaning up the database with notepad in windows, then I stuffed the database back into a clean install of MySql and figures it chokes, then I realized the default version is 5.7 and I was using 8

so fixing that problem got me back up after battling my certificate and eventually I was back up

now the url permalinks work properly etc and workpress more or less operational

was using JetPack but it was borked beyond repair suggesting it needs an overhaul

page load times are better now too

[Vegan]

next up, installing dovecot and leverage email for my server

https://www.hardcoregames.ca/2021/02/16 ... il-server/

with 250GB SSD there is room for a while but unlike hotmail ect I think I can make mail boxes bigger?

[Benjamin]

Sounds like a plan.

[Vegan]

All I know is that with a SSD my web server seems to be snappy which is what everyone wants out there. Some sites are sluggish.

This site like WP runs on Linux and MySQL which seems to be very responsive using SSD.

SSD are low cost now so I figure why not.