Nextend Facebook Connect
Nextend Facebook Connect Flooding Database (3 posts)

  1. Alberto
    Posted 2 years ago #

    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.


  2. hh3
    Posted 2 years ago #

    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.

  3. Jorge A. Gonzalez
    Posted 2 years ago #

    @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_%'

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Nextend Facebook Connect
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic