Support » Plugin: Delete Duplicate Posts » wp_ddp_log

  • Resolved Scott Jones

    (@scooter99)


    The installation of Delete Duplicate Posts never created a database table called wp_ddp_log. Even after uninstalling and reinstalling. Can I get SQL syntax for creating the table with its fields, please.

    Without this table, I will continue to get errors like this:
    WordPress database error Table ‘wordpress-db.wp_ddp_log’ doesn’t exist for query SELECT datime, note FROM wp_ddp_log ORDER BY datime DESC LIMIT 100

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Lars Koudal

    (@lkoudal)

    Hello @scooter99

    That is strange, I will make a note and take a deeper look – for now here is the SQL you were loooking for:

    CREATE TABLEwp_ddp_log` (
    id bigint(20) NOT NULL,
    datime timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’ ON UPDATE CURRENT_TIMESTAMP,
    note tinytext NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;`

    p.s. remember to change “wp_” in “wp_ddp_log” to the actual prefix you use on your site.

    Thread Starter Scott Jones

    (@scooter99)

    Thank you, Lars.

    Hi,

    I experienced the same issue with the plugin. Using the SQL snippet I was able to create the table and eliminate the log entries.

    With the table now created in the db, the log metabox at the bottom of /wp-admin/tools.php?page=delete-duplicate-posts is now being populated. Previously, it was empty and the “Reset Log” had no effect.

    FYI.

    Plugin Author Lars Koudal

    (@lkoudal)

    Hello @rynonet

    Thank you for adding more details to this issue, it seems the log database table does not create automatically as it should on some websites. I will put in a way to either detect that automatically or add a button to do that manually.

    Thread Starter Scott Jones

    (@scooter99)

    Hi @lkoudal

    After fixing the missing table, I examined the error_log for Apache and this error shows up. Appears the $ddp_logtable variable is not being created.

    [php7:notice] WordPress database error Table ‘wordpress-db.$ddp_logtable’ doesn’t exist for query DELETE from $ddp_logtable where datime < ‘2021-09-10 19:36:08’ made by do_action_ref_array(‘ddp_cron’), WP_Hook->do_action, WP_Hook->apply_filters, Delete_Duplicate_Posts::cleandupes, Delete_Duplicate_Posts::return_duplicates, Delete_Duplicate_Posts::log

    thanks for your help,
    Scott

    Plugin Author Lars Koudal

    (@lkoudal)

    Hello @scooter99 and @rynonet

    I just pushed out a new release which fixes a bug in the installation routines, resulting in the database table not being created properly.

    Furthermore, there is now a little extra button in the sidebar “Recreate database tables” which runs the installation routines in case you need to rerun it.

    Thank you for the kind words and support 😀

    Hi @lkoudal , have the same issue.

    I use “recreate” tables button ib the sidebar, and looks like this solved the issue.

    • This reply was modified 1 month, 2 weeks ago by black20091.

    Hi, i have the same problem here, seems like the “recreate database” button does not work i still get the errors

    [15-Oct-2021 07:58:52 UTC] Database error on WordPress Table 'database.$ddp_logtable' doesn't exist for interogation DELETE from$ddp_logtablewheredatime< '2021-10-15 06:57:42' efectuată de do_action_ref_array('ddp_cron'), WP_Hook->do_action, WP_Hook->apply_filters, Delete_Duplicate_Posts::cleandupes, Delete_Duplicate_Posts::log

    • This reply was modified 1 month, 2 weeks ago by Mihai345.
    • This reply was modified 1 month, 2 weeks ago by Mihai345.

    Yes, Error msgs stops for some time, but then appear again

    [15-Oct-2021 08:27:14 UTC] WordPress database error Table ‘admin_gc69cm.$ddp_logtable’ doesn’t exist for query DELETE from $ddp_logtable where datime < ‘2021-10-08 18:53:55’ made by do_action_ref_array(‘ddp_cron’), WP_Hook->do_action, WP_Hook->apply_filters, Delete_Duplicate_Posts::cleandupes, Delete_Duplicate_Posts::log
    [15-Oct-2021 08:27:14 UTC] WordPress database error Table ‘admin_gc69cm.$ddp_logtable’ doesn’t exist for query DELETE from $ddp_logtable where datime < ‘2021-10-08 18:53:55’ made by do_action_ref_array(‘ddp_cron’), WP_Hook->do_action, WP_Hook->apply_filters, Delete_Duplicate_Posts::cleandupes, Delete_Duplicate_Posts::return_duplicates, Delete_Duplicate_Posts::log

    Some help here, or a solution?

    Plugin Author Lars Koudal

    (@lkoudal)

    Hello @mihai345 and @black20091

    Yes, update to 4.7.3 – there was an error in the code that cleans old log entries.

Viewing 11 replies - 1 through 11 (of 11 total)
  • You must be logged in to reply to this topic.