database - Read For Learn

update_post_meta performance in a loop woocommerce

I think, an idea would be to save your values on a new small table with all you need, and have a script that once every “n” hours update all metas.

JPG Image extension not inserting into Custom table of wp

Exporting Post type from one theme and importing it to another theme

Assuming that all the meta (fields) in both of the Custom Post Types (CTPs) is relatable, this is the way I would go about figuring out how much work is in order: Make a new post in each CTP (both sites) and make sure all the meta fields are filled in. It will help if … Read more

Create 3 Levels of relations with WordPress

I not try this, but I hope this working function get_list_catalog_category_product(){ //get all catalog $catalogs = get_terms( array( ‘taxonomy’ => ‘catalogs_term’, ‘hide_empty’ => false )); if ( !empty($catalogs) ) : //make list catalog $output=”<ul>”; foreach( $catalogs as $catalog ) { //write all catalog $output.= ‘<li><a href=”‘.get_term_link( $catalog ).'”>’.$catalog->name.'</a>’; //find all product related the catalog $args … Read more

WordPress users table missing indexes

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

Featured image from custom to WordPress database

Export only a part of the database for migration

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