Deletes other plugin’s transients from the _options table

  • Resolved Josh Feck

    (@builtbynorthby)


    7 years, 1 month ago

    This is causing some serious issues for sites that have both Event Espresso and NextGen Gallery activated. When the ngg_delete_expired_transients wp_cron event fires every fifteen minutes, the _transient_ee_ssn_ options get deleted. These transients are used to track registrations in progress, so if the registration is in progress when the cron fires, registrants get an error when they try to submit their registration form.

    Maybe you can add a prefix into the NGG transients which would allow the DELETE query to be tightened up? e.g. '%NGG-{$this->get_group_id($group)}__%'

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor photocrati

    (@photocrati)

    7 years, 1 month ago

    @builtbynorthby – Thanks for the feedback on this issue, I’ll let our developers review it further … there may also be some additional ideas for Event Espresso to consider as well, have you brought this to their attention, too?

    – Cais.

    Thread Starter Josh Feck

    (@builtbynorthby)

    7 years, 1 month ago

    Hi Cais,

    I actually work for Event Espresso, so yeah this issue is on our radar. We’ve looked into this, but are you aware that _ is a wildcard in mysql LIKE queries? You might be surprised to find the results that get returned if you run this query on a test server:

    https://gist.github.com/anonymous/ce26006dc80f35367910b10023ba4374

    If you change the above to DELETE, and run similar queries every 15 minutes, you’ll have what NextGen Gallery does.

    EE depends on its transients to stay in the options table while a registration is in progress. Other e-commerce type plugins may be using the transients API for similar purposes. If this isn’t something that is going to get fixed, then what we’ll probably have to do is abandon the use of the WP transients API.

    Plugin Contributor photocrati

    (@photocrati)

    7 years, 1 month ago

    @builtbynorthby – Unfortunately this is not within a current release cycle to address at this time although you do have the option to define a longer flush interval for NextGEN Gallery to use (for example):

    define( 'NGG_CRON_SCHEDULE', 900 ); // 15 minutes.

    Thanks!

    – Cais.

    Thread Starter Josh Feck

    (@builtbynorthby)

    7 years, 1 month ago

    Delaying the flush doesn’t really help because even when it’s a longer flush interval, NGG will still delete transients in the options table that are used by other plugins/WP core.

    We’re advising folks to add the following to their wp-config.php file to disable NextGen Gallery’s cron:

    define('NGG_CRON_ENABLED', FALSE);

    Plugin Contributor photocrati

    (@photocrati)

    7 years, 1 month ago

    @builtbynorthby – We’re not seeing an all inclusive flush with our testing … although I will add that note as your observation.

    Thanks!

    – Cais.

    Thread Starter Josh Feck

    (@builtbynorthby)

    6 years, 11 months ago

    Do you think this issue can be taken into consideration for the next development cycle?

    Plugin Contributor photocrati

    (@photocrati)

    6 years, 11 months ago

    @builtbynorthby – This appears to have been addressed in the current release cycle, we will be publishing this release branch very soon.

    Thanks for the reminder!

    – Cais.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Deletes other plugin’s transients from the _options table’ is closed to new replies.