Support » Plugin: SendPress Newsletters » Sendpress and wp_postmeta : MySQL problems

Viewing 5 replies - 1 through 5 (of 5 total)
  • 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)

    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

    Hi Josh,

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

    Best,

    C├ędric

    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)

    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.