mphb_sync_logs takes a lot of space

  • This topic has 3 replies, 2 voices, and was last updated 1 month ago by Andre Flores.
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #975577
    Ryan Labelle
    Participant

    Hi 🙂

    I’m facing a big issue regarding my database. I’m hosted on OVH.

    My database is over the capacity I’m supposed to have.

    I’ve checked on php admin and I saw that the table mphb_sync_logs takes a lot of space.

    So my question is :

    Is this table only for logs in case you need to investigate something?
    Is it possible to flush this table without deleting all my datas especially the reservations and the rest of the content?

    It’s quite urgent because I can’t access anymore to my website through wp-admin. And from front office all my reservations seem to be deleted.. It’s also affecting booking.com sync.

    Thanks in advance for your precious help.

    #975649
    Andre Flores
    Moderator

    Hello, Ryan!

    The mphb_sync_logs table includes only sync logs. It is recommended to set the Automatically delete sync logs older than option to “Day/Week”, so your database is not overloaded with logs. Since you are currently unable to log in to your dashboard to change that setting, you may delete logs manually by running the following query in your database phpMyAdmin tool:


    UPDATE ‘wp_options ‘SET ‘option_value ‘= ‘a:0:{}’ WHERE ‘option_name ‘ = ‘mphb_ical_sync_rooms_queue_processed_data’

    Make sure to replace wp_ with your database table prefix in case it does not match. Also, it is recommended to back-up your database before performing any changes.
    Once it is done, you should be able to log in to your WordPress dashboard and change sync settings to the aforementioned ones.

    Regards,
    Andre

    #976196
    Ryan Labelle
    Participant

    Thank you!!

    #976248
    Andre Flores
    Moderator

    You are most welcome!

    Regards,
    Andre

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.