dbeaty2
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce Square] Square Checkout Page Payment Form ErrorThanks, yes I had to disable it while I tried other things. My next step is to disable Elementor Hello theme.
Forum: Plugins
In reply to: [Wordbooker] innodb problemsHey Steve,
Thanks, BTW your plugin Wordbooker is excellent. I’ve only used it a short time, but I can see how much effort went into it and it shows. Works great.
After ramping my understanding up from 0 to 1000 on MySQL, I simply never needed to know the mechanics of it. It worked. I see in my backups of the database that most plugins, like yours was using MyIsam and WordPress tables like users and posts was using Innodb.
So far I have not found anyone to really assist me. How-To seems to be getting 50-100 posts an hour and rarely gets any replies.
I think I have all the tables switched over the MyIsam using myPHPadmin tool, but I don’t have a shell account so it’s impossible to go further. I lost all content from March 17 onward.
Dbeaty
Forum: Fixing WordPress
In reply to: WordPress site crashing server MySQL innodbIf Anyone knows how to migrate a WP site that was set up to use innodb and move it to Myisam tables that would be very helpful.
Forum: Plugins
In reply to: [Wordbooker] innodb problemsThanks Steve. Normally I’m just concerned with running a website and not dealing with it suddenly crashing permanently. Then having to quickly learn the problem is a corrupt table and not having any idea why that happened in the first place or anyway to fix it.
It’s just frustrating.
Forum: Plugins
In reply to: [Wordbooker] innodb problemsThank you for the reply. Perhaps it was just a cooincedence I was using WP when it happened. If you could point me to the forum that may help with troubleshooting, I’d appreciate it. I am a newbie when it comes to MySQL , MiISAM and Innodb. Not sure how I ended up crashing the whole server. This is a standard WP install with several plugins including WB. Nothing really complex. domain http://www.jodagimbal.com
This is what the hosting site said after they had to restore the March 17 backup:
For normal websites it is always advised to use myisam. The reason is because myisam is stable. Innodb tables are bound to corruption.
Your website is using innodb tables and it crashed. I tried to repair it but the attempt failed, since tables were corrupted. With Innodb even if one table is corrupt the whole mysql service will be down in the server. This is what happened here, and other customers were also getting affected. I was forced to only run mysql in the server without innodb engine.
Now, to prevent this in future, we suggest you to use myisam tables. You have to contact your website developer for this. He can help you in the conversion.
I appreciate your plug in and help Keith. I somewhat understand how it works, but I do not have 100% understanding.
I’m going through and trying to contact all the users that were banned back in Feb, and email them to tell them I am fixing it.
I am checking the Check IP on login.
I wish I could share my settings somehow, something is amiss, I have the latest version with Captcha, now I am getting 10-20 registrations a day. Not posting spam, but I suspect these registrations are spammers. As before I was getting one a week or so.
In general – Add Admins to white list checked
Check credentials on all login attempts: unchecked
Check IP address checkedEnable StopForumSpam Lookups: checked
Wordpress API key entered
Spam Limits: All DefaultsOther Checks: Everything here on except
Check for quick responses (disabled if caching is active): unchecked
Blacklist searches for WordPress PHP files:unchecked
Blacklist login attempts using ‘admin’ userid:unchecked
Check for TOR:unchecked
Check IP against the Akismet db on logins unchecked
Check IP against the Akismet db on comments: uncheckedEvents To Check Everything on except
Check IP on wp-login.php: (As it was blocking registered users) unchecked
Don’t check plugin forms: unchecked