There are, still, references to old domain in your database, which have to be fixed.
Step 1: go to Settings -> Permalinks and click on Save Changes button. This will fix your permalinks.
Step 2: install and activate Better Search Replace plugin. Go to Tools -> Better Search Replace. Replace the old domain ( example.com ) to the new one ( whatever.net ) in all tables.
You can skip Step 2, if the domain name didn’t change.
Make sure that admin cap is exactly a:1:{s:13:"administrator";b:1;}.
Related Posts:
- MySQL Query to Retrieve Category from wp_posts
- SQL Query for getting all posts in their latest revised state
- Search & Remove Specific Shortcode From All Posts
- Manually delete post from database
- How to force update all posts after import
- Query All users that has post
- Manually removing revision post types
- Reset/Reorder posts ID in the MySQL wp_posts table
- How do I find which articles are missing a featured image in The WordPress database?
- Tags to Post-ID mysql query. Tag Search
- wp_insert_post – duration
- Get user categories with most posts in it
- MySql query to get posts with all meta and terms
- Custom order for Mysql array
- List authors with the last post title and order by last post date
- How to Mysql select a list of posts with meta_values AND all relevant categories?
- Remove a shortcode from all WordPress posts
- Order posts alphabetically: how to set order=asc in mysql query?
- What do these phpMyAdmin errors mean on my WordPress databaes?
- What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
- Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
- Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
- update image path with words starting uppercase to lowercase chars
- Queries take 120+ seconds on my large WordPress site
- Database hacked – random posts are modified
- Need to change all links in page content but not in post content
- Can’t update WordPress Page if post_content is Empty
- Restore woocommerce orders
- How to select particular month post from table and update the post status using MySQL?
- How do post IDs work in WordPress?
- Get author posts count after excluding a category
- get last post’s link with SQL query
- query for filtering published posts?
- MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
- Deleting post tags removes categories
- Return records between two meta datetimes saved as strings
- WP query taxonomy optimization
- MYSQL: Create SQL query to search for string and replace
- Query to fetch custom taxonomy along with post title
- Mysql update menu_order problem
- Bulk find & replace on WordPress posts/pages (minus image paths)
- WordPress MySQL Search and replace with wildcard?
- Add postmeta to all blog posts
- ‘posts’ table should not store the absolute image path
- Dev and prod on the same database- dev version active for IOS
- load post data into mysql
- SQL trigger failes with post_content
- Converting Posts to Pages
- How to change the publishing date of each posts?
- SQL query to remove first image in all posts
- Delete junk text from all the post using my sql command
- FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
- How to create a post based on data in a table?
- If meta_key exists then don’t select this post?
- How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
- How to manually delete post from database without causing conflicts?
- How to disable content pagination?
- How to add/assign or change featured image in post programmatically?
- WP-CLI Bulk delete posts from specific category
- Update all posts automatically when using post_meta
- Exclude ALL posts from sub categories
- Post ids are incrementing by an unknown number?
- Can’t show comments count per post outside loop
- Redirect based on user post count
- Should our pages be posts?
- Allow role to delete posts but block him the wp-admin
- Creating a Post, can authors be ordered by last name?
- open selected wordpress post with javascript
- do_shortcode within post query
- How to change the setting so there is no post on home page
- problems with loading posts in a table-row
- How to have posts have a parent in permalink like site.com/blog/postname
- Unable to restore from backup – how to obtain old blog posts?
- display random posts on index.php instead of latest
- Only show a Post once in 10 visits
- Send a review notification email to admin when a post is 12 months old
- Edit custom fields in posts list
- Is it advisable to use $post->comment_count instead of get_comments_number( $post_id )
- All images on one line for each post
- Pull in posts using post meta for REST API
- Avoiding duplcate posts on the main page
- Please help a newbie with blog page issue?
- Alt text attributes not showing over portfolio images
- How to sort WP_Post Object array by object field in php?
- WordPress Recent Post with the badge “New” on the side of the title post
- Unable to delete attached file from folder programmatically
- How to create page with post content in it?
- Top tags with minimum number of posts
- Set a post expiration and delete a post when expirate
- On WordPress Search, how to search post from Author meta also
- Single Sidebar; multiple templates! How?
- is there a way to get the ‘read more’ tag in a manual excerpt
- Next / Previous post in a single category
- Secretly passing post ID/title etc into a shortcode form automatically to link submission to post
- How to sort posts in admin by name
- Extracting a TLD from the content and assign to custom field
- How to custom sort-out editing-panel fields?
- Related post by category throws internal server error
- How to var dump urls for all posts
- Automatically select category based on user role