Database table error

  • theblkresume

    (@theblkresume)


    5 years, 5 months ago

    Good morning. I have encountered an error and it has shut down my entire website and I need assistance. I tried to visit my site this morning and it gave me the 503 server unavailable error. It shut my site down at about 2 a.m. or so this morning and now all of my memory is gone. I called GoDaddy and they directed me that there is an error in one of my database tables and I have no idea how to or even where to begin to trouble shoot the error. Can anyone point me in the right direction?

    This is the error code:

    [14-Dec-2020 06:39:13 UTC] WordPress database error Table ‘i6855792_wp3.wp_ssa_async_actions’ doesn’t exist for query SELECT * FROM wp_ssa_async_actions WHERE 1=1 AND (date_processed = “0000-00-00 00:00:00” OR date_processed IS NULL ) ORDER BY id DESC LIMIT 0,1000; made by do_action_ref_array(‘ssa_cron_process_async_actions’), WP_Hook->do_action, WP_Hook->apply_filters, SSA_Async_Action_Model->execute_cron_process_async_actions, TD_Async_Action_Model->process, TD_Model->query, TD_DB_Model->db_query

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

Viewing 12 replies - 1 through 12 (of 12 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 5 months ago

    Try repairing your database: https://www.godaddy.com/help/optimize-table-in-mysql-7364

    Select “repair” in the option instead of “optimize”

    Thread Starter theblkresume

    (@theblkresume)

    5 years, 5 months ago

    I followed the steps for the Linux and it did not offer me the option to repair the database…it said restore and back up?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 5 months ago

    Try this tutorial https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin

    Thread Starter theblkresume

    (@theblkresume)

    5 years, 5 months ago

    When i went into myphpadmin and looked for the database table that is throwing the error, its not listed there.

    Thats the same thing its saying when i look at the error log is that it doesnt exist for query

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 5 months ago

    In that case, you need to find out what plugin needs this table and contact their support (assuming you don’t have an old backup you can restore).

    Please attempt to disable all plugins, and use one of the default (Twenty*) themes. If the problem goes away, enable them one by one to identify the source of your troubles.

    Thread Starter theblkresume

    (@theblkresume)

    5 years, 5 months ago

    I have two backups but the man from godaddy said that restoring them wouldn’t enable my site because this error has eaten up all of my memory.

    Are you saying, that if I back up to a previous version it will give me some of my memory back so that I can go in and deactivate and reactivate?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 5 months ago

    This has nothing to do with memory.

    Thread Starter theblkresume

    (@theblkresume)

    5 years, 5 months ago

    Thank you so much for providing that clarity! When I go in and attempt to do a backup restore through my installatron, it doesnt show my site..just the cursor at the top loading?… Do I need to do a full back up by following the steps in the first link you sent to me?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 5 months ago

    Why do you think this is a memory issue? I don’t know what Installatron does in this case, so it’s best to ask your host.

    Thread Starter theblkresume

    (@theblkresume)

    5 years, 5 months ago

    Tech support at godaddy told me its a memory issue and when i log into my cpanel my memory is all used up and red.

    He said i could upgrade to a higher resource but if i dont fix the error, inevitably, I’d be in this situation again…but as of right now, i cant access anything beyond my cpanel

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 5 months ago

    If you get the database issue resolved, start a new topic regarding memory.

    Thread Starter theblkresume

    (@theblkresume)

    5 years, 5 months ago

    Thank you so much! I called the host and we got my website back! I’ve deactivated all plugins and will monitor the resource usage to see which one is causing the problems!

    I appreciate you soooooooooo much!

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

The topic ‘Database table error’ is closed to new replies.