500 server error / Options table filled with data from plugin

  • Post date

Home › Forums › Calendar Products › Events Calendar PRO › 500 server error / Options table filled with data from plugin

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • August 12, 2015 at 7:36 am #995407
    Kenny
    Participant

    Our site is down, and I have discovered that our wp_options table is filled with many rows of data.

    The option_name field has “_transient_478ab8a4f54fadf3896cd8c9db12aefe” followed by “_transient_timeout_6942724215ac64c077d911fa5eeb7a8a” and similar, over and over and over.

    The auto_increment for the table is at 5,151,885! What’s going on here?

    The table will not even load in my database manager tool! It’s running so slow that everything is dead in the water.

    I need immediate help with this. Can anyone suggest what I should do?

    August 12, 2015 at 11:50 am #995513
    Brian
    Keymaster

    Hi,

    Sorry for the issues. I am not sure I can help out here.

    Transients can be setup by any plugin, theme, or custom coding to store information.

    I have not seen an issue with our plugins causing this issue, but I can try to help on this, but I am limited.

    Can you use a plugin like Transients Manager

    Transients Manager

    That will show you all the Transients and you can delete them.

    Another option is Delete Expired Transients

    Delete Expired Transients

    That might help clear a lot of those out.

    Another option might to use some sql to delete all the transients:

    http://stackoverflow.com/a/11995022

    It sounds like that should work, but I do not know the exact repercussions.

    It would be a good idea to backup before altering the database in anyway.

    Thanks

    August 13, 2015 at 8:22 am #995783
    Kenny
    Participant

    Thank you for those resources. I did remove them manually using SQL, but I will check out those plugins if it becomes an issue again.

    August 13, 2015 at 8:43 am #995801
    Brian
    Keymaster

    I am glad to see you were able to fix this issue.

    Since the issue is resolved I am going to go ahead and close this ticket. If you have a similar issue or another in the future, please do not hesitate to create a new ticket.

    Thanks!

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • The topic ‘500 server error / Options table filled with data from plugin’ is closed to new replies.