Plugin not working to hide anything

Resolved 01mhoover
(@01mhoover)

1 year ago

I am selecting to hide a post on the blog homepage, RSS feed, and “recent posts” widget. When I click “Publish” or “Update” those options are unchecked and the post is not hidden anywhere.

I have the warning “Important: We implemented new table for managing the hide flags in our plugin which optimizes the query and improve overall performance. Please create database backup before proceeding, just in case.” at the top of the page, yet when I click the “Migrate” button it refreshes the screen and the message does not go away. I cannot see that button is doing anything.

I’ve tried removing and reinstalling the plugin but no difference to anything above. This used to work but appears to not be storing my selected options on a post or applying them anywhere. Can you help?

WordPress 6.7.1, PHP 8.0.30, Theme = WordPress 2010

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Author MartinCV
(@martin7ba)

1 year ago

@01mhoover Hi, thank you for reporting this. The issue is because a database table was not created after updating / reinstalling the plugin. I haven’t tested the plugin on the WordPress 2010 theme. I will test this tomorrow and see if I can replicate the issue with the same setup.

Are you able to find and send the error log file of the date when you first updated the plugin?

Best,
Martin

Thread Starter 01mhoover
(@01mhoover)

1 year ago

I’m sorry, I looked through and don’t see any logs pertaining to the plugin update. I just see these messages in logs now:

[php:notice] [pid 1524688:tid 1524688] [client 192.168.0.115:49539] WordPress database error Table ‘kronicle.wp_whp_posts_visibility’ doesn’t exist for query SELECT COUNT(*) FROM wp_whp_posts_visibility WHERE post_id = 4617 AND condition = ‘hide_on_single_post_page’ made by require(‘wp-admin/edit-form-advanced.php’), do_meta_boxes, MartinCV\WHP\Admin\Post_Hide_Metabox->metabox_callback, MartinCV\WHP\Core\Plugin->get_whp_meta, referer: https://kronicle.kurtzbros.com/wp-admin/post.php?post=4617&action=edit&classic-editor

Plugin Author MartinCV
(@martin7ba)

1 year ago

@01mhoover Yes, that means the table was not created for some reason.

Are you able to manually create the table? Do you have access to the database?

Thread Starter 01mhoover
(@01mhoover)

1 year ago

Yes I have access to the database. How can I create the table(s)?
Plugin Author MartinCV
(@martin7ba)

1 year ago
@01mhoover This is the MySQL Query that creates the table

CREATE TABLE wp_whp_posts_visibility (
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
post_id BIGINT(20) UNSIGNED NOT NULL,
condition VARCHAR(100) NOT NULL,
PRIMARY KEY (id),
INDEX pid_con (post_id,condition)
);

Please note that the condition is in (ticks) as well as the table name
- This reply was modified 1 year ago by MartinCV.
Thread Starter 01mhoover
(@01mhoover)

1 year ago

Got it, thank you. I created the table and now all works. Thank you for your help. You made a good plugin and support it well.

Plugin Author MartinCV
(@martin7ba)

1 year ago

@01mhoover Glad it all worked out. Thank you.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Plugin not working to hide anything’ is closed to new replies.