Support » Plugin: Nextend Facebook Connect » Nextend Facebook Connect Flooding Database

  • Hi Folks,

    I love Nextend Facebook Connect – it is a truly amazing plugin. However, I noticed it has been flooding my site’s mySQL database, in particular the wp_options table with thousands of “_site_transient_” entries. This slows down the site significantly, and ultimately led to the site consistently timing out.

    This can be fixed with a database query:

    DELETE FROM wp_options WHERE option_name like ‘_site_transient_%’

    But, I would hate to have to do this periodically to keep using this plugin. Would love it if you guys could look into this.

    Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi there, I was wondering what those lines of “set_site_transient” do… now I know. Those things are supposed to expire, but there are some cases that they don’t get removed even when expired according to this article: Does WordPress delete expired transients from the database?

    The article suggests:

    Grab the plugin Purge Transients from Github, put it in your plugins folder and activate it in your WordPress admin. Now any expired transients will be deleted from your database after 7 days.

    Or you might try “Delete Expired Transients” plugin, but I found some transients are still left behind. It could be because the “Facebook” object destructor doesn’t exists. In any case, I have given up on this plugin… too many issues. I would suggest trying WordPress Social Plugin, which I got to work correctly.

    @alberto that appears to have fixed the login problem. I had to repair the options table then run DELETE FROM wp_options WHERE option_name like '_site_transient_%'

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Nextend Facebook Connect Flooding Database’ is closed to new replies.