404 event log

  • Resolved ninasaether

    (@ninasaether)


    1 year, 1 month ago

    I see that the 404 event logo is kept for 90 days. Is there a way to purge this log way sooner?

    Also, how can i optimize the wp_aiowps_message_store tabel in the database. It is comming up on 100Mb.

    I need to keep this plugin from bloating my database.

    Regards
    Nina

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

Viewing 8 replies - 16 through 23 (of 23 total)
1 2
  • Thread Starter ninasaether

    (@ninasaether)

    1 year ago

    Still no change as you can see from the attached image

    Regards
    Nina

    Plugin Support aporter

    (@aporter)

    1 year ago

    Hi Nina,

    Then I think that database prefix (jdkwd_) does not match the prefix the site is running on.

    Do you have more than one aiowps_message_store?

    Attached is an updated file that uses that exact prefix:

    https://we.tl/t-GvmcprosXv

    Best Wishes,

    Ashley

    Thread Starter ninasaether

    (@ninasaether)

    1 year ago

    The prefix was changed in your plugin. There is only one aiowps_message_store. I also tried adding the prefix in the function you provided, but no luck.

    Regards
    Nina

    Plugin Support aporter

    (@aporter)

    1 year ago

    Have you tried the new file I sent?

    That uses the exact prefix and table name from the screenshot above.

    If that doesn’t work I’m not sure whats going on.

    Could you confirm the mu-plugins folder is named correctly and in the correct place:

    wp-content/mu-plugins/

    The only thing left we can try is to use PHPMyAdmin or similar to empty the contents of the table.

    Best wishes,

    Ashley

    Thread Starter ninasaether

    (@ninasaether)

    1 year ago

    I tried the last file you sent. It was without the prefix. I tried both without the prefix and then with the prefix.

    Here you can see where I added the .php file.

    Regards
    Nina

    Plugin Support aporter

    (@aporter)

    1 year ago

    Hi,

    The last file did not include the “$wpdb->prefix” because the prefix is already part of the string ‘jdkwd_aiowps_message_store’

    But from your screenshot all them lines of code have been commented out and so won’t actually run the “//” need to be removed so that it looks like this:

    https://ibb.co/jzDgk2j

    I’m not sure why them comments have been added.

    Best Wishes,

    Ashley

    • This reply was modified 1 year ago by aporter.
    Thread Starter ninasaether

    (@ninasaether)

    1 year ago

    My heart jumped there for a while as tha database grew to over 500Mb:), but then it got down to 176Mb which means almost 200Mb is gone. 🙂

    Thank you very much for all your help.

    I can safely remove the php file and the database will not grow that large again?

    Regards
    Nina

    Plugin Support aporter

    (@aporter)

    1 year ago

    Hi,

    I’m glad thats resolved for you now.

    Yes you can remove that file now, the message_Store table should no longer get that large again either using the latest AIOS.

    Best Wishes,

    Ashley

Viewing 8 replies - 16 through 23 (of 23 total)
1 2
  • The topic ‘404 event log’ is closed to new replies.