Homepage (EN) Support PlanSo Forms BUG: millions of sessions entries in wp_options

  • This topic has 1 reply, 1 voice, and was last updated 6 months ago by Thomas.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #350872 Reply
    Patrick
    Guest

    Hello,

    we use the plugin and get now massive performance problems, so we updated everything, without any effects, so we searched for the problem.
    The problem was in the database, the wp_options table contains over 2,6 million entries, 99% of this “_wp_sessions_*”.

    The bug are in “planso-forms/libs/wp-session-manager/wp-session.php” (Line: 153):
    before: $expiration->option_name = preg_replace('/[^\da-z]/i', '', $expiration->option_name);
    after: $expiration->option_name = preg_replace('/[^\da-z_]/i', '', $expiration->option_name);

    The regex removes also all underscores, so the DELETE statement, are wrong and nothing was deleted.

    Regards,
    Patrick

    #387087 Reply
    Thomas
    Guest

    Had the very same problem, wp_options was >1 GB and database was locked by hosting, no more inserts, no more wp-login possible.

    Have applied the above suggested fix now, let’s hope session cleanup will work now.

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: BUG: millions of sessions entries in wp_options
Your information: