mysql issue

  • Resolved ideasunlimited

    (@ideasunlimited)


    3 years, 2 months ago

    Hi,

    There is some issue with the plugin : YITH WooCommerce Ajax Product Filter
    We are using this to display products based on category on our WooCommerce shop site

    Since monday (27th December) we’ve been getting a lot of data in our logs on the live server.

    -rw-rw—- 1 mysql adm 101M Dec 30 06:01 mysql-bin.039120
    -rw-rw—- 1 mysql adm 101M Dec 30 05:51 mysql-bin.039119
    -rw-rw—- 1 mysql adm 101M Dec 30 05:41 mysql-bin.039118

    4ac634d345fca5b85d0d1bb3d2bf\”;a:1:{i:0;i:25626;}s:32:\”1fa1a812168f6607a5cf7322bc2f92b0\”;a:1:{i:0;i:25626;}}’ WHERE option_name = ‘_transient_yith_wcan_queried_products_1640657220’x>?au?\C1x>?a?&?c?x>?a??o?%x>?a*??~A

    We have updated the latest version of the plugin: Version 4.5.0
    We just noticed that the above code is getting appended in the database when we activate the plugin on the live site

    Is there any security issue related to this ?

    This data appears every 10 minutes or so. It immediately stops when we deactivate the plugin.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter ideasunlimited

    (@ideasunlimited)

    Size of this entry in wp-options keep on increasing
    https://paste.pics/FI8VC

    Option_value gets added in the database each time we run a filter query

    Plugin Support crodriguez1991

    (@crodriguez1991)

    Hello there,

    Thanks for contacting us and we hope you’re doing well ??

    About your question:

    This is a transient option used by our plugin in order to decrease the time when a new filter is made on your site.

    Our plugin use the WordPress transients method in order to handle it. You can see more information about transients in the following link

    The transients allow the plugin temporarily store cached information and return filtered products in a fast way.

    You can clear YITH Ajax Product Filter transients from the following option

    WooCommerce > Status > Tools > Clear Product Filter transients

    I hope it helps you.

    Have a good day.

    Thread Starter ideasunlimited

    (@ideasunlimited)

    Hi,

    Thanks for your reply,

    We have cleared the YITH Ajax Product Filter transients by doing this
    WooCommerce > Status > Tools > Clear Product Filter transients
    But the db size keeps increasing

    At present the only issue we have is the increasing size in logs
    Is there a way to turn off this
    Maybe as an option in future plugin update ?

    Plugin Support crodriguez1991

    (@crodriguez1991)

    Hello there,

    I hope you’re doing well ??

    Our plugin doesn’t write in the log. The log appears due to warnings or problems.

    If you want to turn off the logs, you need to disable the debug variables set in the wp-config.php file.

    If you want, you can remove it. You have more information about debugging here

    Have a good day.

    Thread Starter ideasunlimited

    (@ideasunlimited)

    Thanks for your help.

    its sorted now.

    Plugin Support Alessio Torrisi

    (@alessio91)

    Hi there,
    we’re happy have helped you.
    If you’re satisfied with our product and our support, don’t hesitate leave a review, we’ll appreciate it too much ??

    Thank you.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘mysql issue’ is closed to new replies.