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.
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 4 years, 4 months 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 4 years, 4 months ago by
Mihai345.
-
This reply was modified 4 years, 4 months ago by Mihai345.
Yes, Error msgs stops for some time, but then appear again
$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.
