Forum Replies Created

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter dbeaty2

    (@dbeaty2)

    Thanks, yes I had to disable it while I tried other things. My next step is to disable Elementor Hello theme.

    Thread Starter dbeaty2

    (@dbeaty2)

    Hey 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

    Thread Starter dbeaty2

    (@dbeaty2)

    If 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.

    Thread Starter dbeaty2

    (@dbeaty2)

    Thanks 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.

    Thread Starter dbeaty2

    (@dbeaty2)

    Thank 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.

    Thread Starter dbeaty2

    (@dbeaty2)

    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.

    Thread Starter dbeaty2

    (@dbeaty2)

    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 checked

    Enable StopForumSpam Lookups: checked
    Wordpress API key entered
    Spam Limits: All Defaults

    Other 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: unchecked

    Events To Check Everything on except
    Check IP on wp-login.php: (As it was blocking registered users) unchecked
    Don’t check plugin forms: unchecked

Viewing 7 replies - 1 through 7 (of 7 total)