fix a wordpress database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
Vegan
Forum Regular
Posts: 554
Joined: Fri Sep 05, 2008 3:34 pm
Location: Victoria, BC

fix a wordpress database

Post by 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
Hardcore Games™ Legendary is the Only Way to Play™
User avatar
Benjamin
Site Administrator
Posts: 6906
Joined: Sun May 19, 2002 10:24 pm

Re: fix a wordpress database

Post by Benjamin »

What is the error message?
User avatar
Vegan
Forum Regular
Posts: 554
Joined: Fri Sep 05, 2008 3:34 pm
Location: Victoria, BC

Re: fix a wordpress database

Post by 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
Hardcore Games™ Legendary is the Only Way to Play™
User avatar
Vegan
Forum Regular
Posts: 554
Joined: Fri Sep 05, 2008 3:34 pm
Location: Victoria, BC

Re: fix a wordpress database

Post by 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
Hardcore Games™ Legendary is the Only Way to Play™
User avatar
Benjamin
Site Administrator
Posts: 6906
Joined: Sun May 19, 2002 10:24 pm

Re: fix a wordpress database

Post by 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.
User avatar
Vegan
Forum Regular
Posts: 554
Joined: Fri Sep 05, 2008 3:34 pm
Location: Victoria, BC

Re: fix a wordpress database

Post by 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
Hardcore Games™ Legendary is the Only Way to Play™
User avatar
Vegan
Forum Regular
Posts: 554
Joined: Fri Sep 05, 2008 3:34 pm
Location: Victoria, BC

Re: fix a wordpress database

Post by 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?
Hardcore Games™ Legendary is the Only Way to Play™
User avatar
Benjamin
Site Administrator
Posts: 6906
Joined: Sun May 19, 2002 10:24 pm

Re: fix a wordpress database

Post by Benjamin »

Sounds like a plan.
User avatar
Vegan
Forum Regular
Posts: 554
Joined: Fri Sep 05, 2008 3:34 pm
Location: Victoria, BC

Re: fix a wordpress database

Post by 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.
Hardcore Games™ Legendary is the Only Way to Play™
Post Reply