wp_ddp_log

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.

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.

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.

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

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 3 years, 1 month 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 3 years, 1 month ago by Mihai345.
• This reply was modified 3 years, 1 month 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?

Hello @mihai345 and @black20091

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