Posts Stopped Showing

Installed Network Posts Extended a few years ago and it has been working flawlessly since. (Awesome plugin BTW) I moved the website to another server and now no posts are showing for any of the short codes. There doesn’t seem to be any errors, just empty div tags. Tried deleting and reinstalling the plugin. Tried just basic short code and still get nothing. The entire site was cloned to the new server and then the IP updated at the registry, everything else on the WordPress site/network works fine. The server was very similar to the original but a few things changed (Ubuntu 20.04 -> Ubuntu 22.04, MariaDB -> MySQL.)

Getting this in the debug log

[16-Jun-2024 22:34:44 UTC] WordPress database error Access denied for user r’@’localhost’ to database ” for query CREATE TEMPORARY TABLE u21_network_posts_results AS SELECT ID,1 as blog_id,post_title,post_excerpt,post_content,post_author,post_date,post_type FROM u21_posts WHERE (post_type=’post’) AND (u21_posts.post_password=”) AND (post_status=”publish”) made by require(‘wp-admin/edit-form-blocks.php’), block_editor_rest_api_preload, array_reduce, rest_preload_api_request, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Posts_Controller->get_item, WP_REST_Posts_Controller->prepare_item_for_response, apply_filters(‘the_content’), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, netsposts_shortcode, NetworkPosts\Components\db\NetsPostsQuery->get_posts, NetworkPosts\Components\db\NetsPostsQuery->get_rows, NetworkPosts\Components\db\NetsPostsQuery->create_temporary_table

[16-Jun-2024 22:34:44 UTC] WordPress database error Table ‘.u21_network_posts_results’ doesn’t exist for query INSERT INTO u21_network_posts_results SELECT ID,9 as blog_id,post_title,post_excerpt,post_content,post_author,post_date,post_type FROM u21_9_posts WHERE (post_type=’post’) AND (u21_9_posts.post_password=”) AND (post_status=”publish”) made by require(‘wp-admin/edit-form-blocks.php’), block_editor_rest_api_preload, array_reduce, rest_preload_api_request, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Posts_Controller->get_item, WP_REST_Posts_Controller->prepare_item_for_response, apply_filters(‘the_content’), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, netsposts_shortcode, NetworkPosts\Components\db\NetsPostsQuery->get_posts, NetworkPosts\Components\db\NetsPostsQuery->get_rows, NetworkPosts\Components\db\NetsPostsQuery->insert_temp_data

Seems to be a db permission issue. Any suggestions or direction would be greatly appreciated.
Thanks, Danny

• This topic was modified 9 months, 1 week ago by relicpelican.
• This topic was modified 9 months, 1 week ago by relicpelican.