Database error causing the site to go down

  • Resolved slax

    (@slax)


    2 years ago

    I was using Yoast SEO… disabled Yoast then installed AIOSEO. AIOSEO asked me to import data from Yoast SEO.. which I did… then I was working on AIOSEO by updating the page with the recommendations.

    The site became slow…. then hosting support team asked me to disable AIOSEO plugin… as it was found as last action before the issue started… so I disabled it…

    I told them AIOSEO is important and then I enabled the plugin… same issue happened… so I deactivated/deleted the plugin, then installed it again…

    Then the site went down… I repeated the whole process again… deleted/installed again… same result… next round… I did the same but this time.. I deleted two aioseo tables from database… then again deleted/installed again… same result…

    I really have to use AIOSEO…. help!!!

    Hosting Support shared the following information:
    The error is related to inserting information to the database and it repeated over and over

    WordPress database error Table ‘topperdb.wp_aioseo_cache’ doesn’t exist for query SELECT
    key, value
    FROM wp_aioseo_cache
    WHERE 1 = 1 AND
    ( expiration IS NULL OR expiration > ‘2023-02-11 09:18:42’ )
    AND key = ‘pro_just_deactivated_lite’
    /* 1 = 1 */ made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Main\Activate->init, AIOSEO\Plugin\Common\Utils\Cache->get, AIOSEO\Plugin\Common\Utils\Database->run

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Prabhat

    (@prabhatrai)

    Hi @slax,

    Thanks for reaching out, and I apologize for the inconvenience caused!

    The error logs state that the aioseo_cache table is missing on your website for some reason.

    You can use the below code snippet to re-create the missing aioseo_cache table –

    Please download the?wpcode-snippets-export-2023-02-13.zip?file from the link below and unzip/extract it –?
    ?
    ?https://a.supportally.com/f/qRQvtr
    ?
    ?Then inside the?wpcode-snippets-export-2023-02-13?folder, you’ll find the?wpcode-snippets-export-2023-02-13.json?file?that contains the code snippet you can use with our WPCode plugin. You’ll need to save this special file to your local computer in your Downloads folder.

    Please follow the steps below to add this code snippet to your site using our WPCode plugin:

    1. Log into your WordPress site and go to Plugins > Add New.
    2. In the Search plugins field (top right), enter WPCode.
    3. Click on the Install Now button next to the result for WPCode as shown in this screenshot – https://a.supportally.com/i/tpZaaJ
    4. Click on the Activate button.
    5. Next, go to Code Snippets > Tools in the WordPress menu and click on the Import tab as shown in this screenshot – https://a.supportally.com/i/PqbWyh
    6. Click on the Choose a file button under WPCode Snippet Import and browse to the special file I attached which you saved to your Downloads folder.
    7. Select the file and click the Import button.
    8. You can now click on Code Snippets in the WordPress menu and you should see the code snippet in the list. It’s the one called Recreate the aioseo_cache table.
    9. Click on the Status toggle for this snippet to activate it.

    Please make sure to deactivate and delete this code snippet once the aioseo_cache table is created.

    Let me know if you face any issues or have any questions and I’ll be more than happy to help you.

    Thanks!

    Plugin Support Prabhat

    (@prabhatrai)

    Hi @slax,

    We haven’t heard back from you in a couple of days. I’m going to go ahead and close this thread for now. But if you’d like us to assist, please feel welcome to continue the conversation.

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database error causing the site to go down’ is closed to new replies.