Sendpress and wp_postmeta : MySQL problems

  • Maisonentravaux

    (@maisonentravaux)


    9 years, 7 months ago

    Hello

    I have a huge problem with Sendpress and my MySQL DBB. Since I activated the plugin on my website, I see the size of my DBB increases strongly. The table which is concerned is wp_postmeta ! Sendpress add in this table these lines in wp_postmeta:

    196629 16347 _firstname_label First Name
    196630 16347 _lastname_label Last Name
    196631 16347 _email_label E-Mail
    196632 16347 _button_label Submit
    196633 16347 _list_label List Selection
    196634 16347 _lists_checked Select Lists by default
    196635 16347 _thankyou_message Check your inbox now to confirm your subscription.
    196636 16347 _thankyou_page
    196637 16348 _setting_type form
    196638 16348 _form_type signup_widget
    196639 16348 _sp_settings_id 16348
    196640 16348 _form_description
    196641 16348 _collect_firstname
    196642 16348 _collect_lastname
    196643 16348 _display_labels_inside_fields 0

    This plugin wrote a series of lines repeatedly. There are 1.000.000 of lines concerned. What can I do please?

    Thanks

    https://wordpress.org/plugins/sendpress/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter Maisonentravaux

    (@maisonentravaux)

    9 years, 7 months ago

    I applied these requests to clean all the lines SendPress generated in wp_postmeta :

    DELETE FROM wp_postmeta WHERE meta_key = ‘_firstname_label ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_lastname_label ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_email_label ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_button_label ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_list_label ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_lists_checked ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_thankyou_message ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_thankyou_page ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_setting_type ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_form_type ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_sp_settings_id ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_form_description ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_collect_firstname ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_collect_lastname ‘;
    DELETE FROM wp_postmeta WHERE meta_key = ‘_display_labels_inside_fields ‘;

    It seems to work but how to stop the injections ?

    Plugin Author Josh Lyford

    (@joshl)

    9 years, 7 months ago

    HI Maisonentravaux,

    Just released 1.0.1 with a fix for the post meta issue. You should not have this problem anymore but please let me know if it does not stop for you.

    Best,
    Josh

    Thread Starter Maisonentravaux

    (@maisonentravaux)

    9 years, 7 months ago

    Hi Josh,

    thanks for the reply. Can you tell me if it will clean my DBB please?

    Best,

    Cédric

    FLy

    (@bfly)

    9 years, 7 months ago

    Hi everyone!

    And table wp_post many of the same records with post_title “Default Signup Settings”. Need help for database cleanup.

    Plugin Author Josh Lyford

    (@joshl)

    9 years, 7 months ago

    Hi All,

    If you got to “Settings > Advanced” you will see an button for “Data Fix Options”. After that you will see an option to “Reset Settings” this will clean up the Database both post meta and posts.

    Best,
    Josh

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Sendpress and wp_postmeta : MySQL problems’ is closed to new replies.