Sounds like the auto increment handling is not setup correctly. Go into phpMyAdmin and make sure that the PRIMARY KEY is set to AUTO_INCREMENT You can also run this SQL command: ALTER TABLE wp_users AUTO_INCREMENT = 1 The 1 above you need to make sure the auto increment value is set to the highest number … Read more
Solved! I follow this tutorial: https://wordpress.org/gutenberg/handbook/designers-developers/developers/tutorials/block-tutorial/writing-your-first-block-type/ https://wordpress.org/gutenberg/handbook/designers-developers/developers/tutorials/block-tutorial/creating-dynamic-blocks/ And complimented with this: https://gist.github.com/mattheu/7cf235b4f932de891bc21cb5f3ff3de6
Featured image from custom to WordPress database
If you don’t mind exporting pages and posts separately, you can use the default WordPress export tool to achieve that. On the Export screen you can set the tool to export only posts. Then add a suitable date filter. After that do another export, but this time set the tool to export only pages. You … Read more
Actually there is no primary category key. Usually, the first category is primary category by default. So technically, the below are the only fields I will need. Post ID | Post Title | Post Content | Post Excerpt | Post categories | Category Term IDs
A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
wpdb->query() is just running the query. It doesn’t do anything special. And strip_invalid_text_from_query() based on the inline documentation is just stripping invalid characters in the query. And, for your information, something like line-breaks doesn’t break the database. The database can accept any string data. You just have to make sure it correctly escaped when the … Read more
I had this issue some days ago with a multisite, loading a live dump to local development. After some debugging I noticed, that the error message wasn’t right. The database was connected, but the path in the database to the sites was wrong. You can check table <your-prefix>_site and <your-prefix>_blogs if columns domain and path … Read more
Is it possible to separate databases in WordPress site – one for orders and the other for all non-orders related
You can loop through all your posts and use regex to replace that string. The quick and dirty version would be to just put this in a page template, assign it to a page and then visit said page. If you want something a little cleaner then modify this code to work with something like … Read more