Unable to delete Give > Donors

  • Resolved EMar

    (@sounds)


    2 years, 4 months ago

    Hi,

    When I try to delete donors from Dolors list, they don’t get removed.
    Is it save to delete them from phpmyadmin in MYSQL? wp_give_donors?

    EDIT

    That works, but I accidentally deleted the donor table for my own user.

    Thanks in advance.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support Rick Alday

    (@mrdaro)

    Hi @sounds,

    We recommend against deleting things in the database unless you know what you’re doing.

    Do you get any sort of error message when you try to delete donors in the WordPress backend?

    Is there any error in the browser console?
    This article explain how to check the browser console for errors: https://balsamiq.com/support/faqs/browserconsole/

    Thread Starter EMar

    (@sounds)

    Hi Rick

    No, there are no errors at all,
    Deleting those Donor tables got rid of them in the plugin settings.

    The only issue, if it is an issue, I removed the donor table for my own account.

    Plugin Support Rick Alday

    (@mrdaro)

    You will need to add the table again. If you know your way around SQL commands you can lookup the command here: https://github.com/impress-org/givewp/blob/master/includes/database/class-give-db-donors.php#L564

    If not, the only other way to recreate tables is to reinstall GiveWP.
    Your data is saved in the database, so that will be safe as long as you don’t select the option to erase all data upon deactivation.

    Thread Starter EMar

    (@sounds)

    Thanks,

    Just this command in the SQL tab?
    $sql = “CREATE TABLE {$this->table_name} (

    I also tried reinstalling it, it still has the old donors tables, just not me.

    Plugin Support Rick Alday

    (@mrdaro)

    If you already have the donors table in the database you don’t need to run the script.

    Can you clarify? Is the donor table in the database but just your donor record is missing?

    Thread Starter EMar

    (@sounds)

    Basically I deleted non-donors from the donor’s list,
    By removing them in db_give_donors table.

    I didn’t delete a few users because the donated, they’re still listed.

    The only table that’s missing from db_give_donors is the one for me.
    I deleted that by mistake.

    Plugin Support Rick Alday

    (@mrdaro)

    Ok, so the donor table is there. You’re just missing your donor record.
    What you can do here is to make a test donation and your donor record will be added again.
    You can enable the “Test Donation” payment option in Donations -> Settings -> Payment Gateways.

    Let me know if that helps!

    Thread Starter EMar

    (@sounds)

    Thanks Rick,

    I just read the Note under the payment gateways:
    https://givewp.com/documentation/core/test-mode/

    I have PayPal standard, so I just clicked make donation button,
    Then my donor table was added to db_give_donors

    Thanks!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Unable to delete Give > Donors’ is closed to new replies.