ERROR: table_name' doesn't exist

  • Resolved marikamitsos

    (@marikamitsos)


    8 years, 4 months ago

    Hello and thank you for your work,

    After upgrading to v1.8 on a single site we experience an error when trying to bulk delete ALL logs and logs do NOT get deleted:

    WordPress database error Table ‘database_name.$table_name’ doesn’t exist for query DELETE FROM $table_name made by require_once(‘wp-admin/admin.php’), do_action(‘tools_page_email-log’), call_user_func_array, EmailLog->display_logs, Email_Log_List_Table->prepare_items, Email_Log_List_Table->process_bulk_action

    On top of that although we have just 9 entries the plugin thinks and displays the number 79 (79 items). Then we delete 5 of them and the number drops by 5 but still displays the wrong number 74 and not 4.

    https://wordpress.org/plugins/email-log/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter marikamitsos

    (@marikamitsos)

    8 years, 4 months ago

    Deleted and reinstalled the plugin.
    No luck. 🙁 Delete ALL still doesn’t work and gives errors.
    But. Did some more testing and found the reason for the item display issue.

    The displayed items number is picked up by the ID number of the latest entry and NOT the total number of entries (items).
    I explain. Lets say the ids of your items are: 35, 28, 10, 7, 5, 4, 3, 2, 1. The items’ number shows 35 although there are only 9 items. You delete items 28, 5 and 2. The number shown is still 35. You delete 35, 10, 3. It shows number 7 when only 3 items (7, 4, 1) are present.

    I hope that helps.

    Plugin Author Sudar Muthu

    (@sudar)

    8 years, 4 months ago

    Thanks for reporting the issue. I guess it got introduced in the changes that I did for v1.8

    I am debugging the issue right now. Will make a release once I fix it.

    Plugin Author Sudar Muthu

    (@sudar)

    8 years, 4 months ago

    I have fixed the issue that was introduced in v1.8 that broke the “Delete all Logs” functionality and released v1.8.1 with the fix.

    Kindly update the plugin and let me know if you are still facing this issue.

    Thread Starter marikamitsos

    (@marikamitsos)

    8 years, 3 months ago

    We updated to v1.8.1.
    Can not at the moment test it for the “Delete all Logs” functionality. Sorry 🙁

    But we deleted some emails and the numbering issue still remains. Although we have only 6 emails we are told they are 21.

    You have to give it another try I am afraid. At least for this part.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘ERROR: table_name' doesn't exist’ is closed to new replies.