bolus150

Look log in database:

| 4075156 | db_name | server_name | db_name | Query | 22316 | statistics | SELECT SQL_CALC_FOUND_ROWS bodb_posts.*, wpftsi_t.relev FROM bodb_posts LEFT JOIN bodb_term_relat | 0 | 0 |
| 4075478 | m1418_usrsbacego | server_name | m1418_sbacegodbnew | Sleep | 327 | | NULL
i blokowane przez to tabele, np:
| 4267803 | db_name | server_name | db_name | Query | 7919 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs
| 0 | 0 |
| 4267999 | db_name | server_name | db_name | Query | 7903 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs
| 0 | 0 |
| 4268449 | db_name | server_name | db_name | Query | 7866 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs
| 0 | 0 |
| 4268497 | db_name | server_name | db_name | Query | 7859 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs
| 0 | 0 |
| 4268935 | db_name | server_name | db_name | Query | 7823 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs
| 0 | 0 |
| 4269855 | db_name | server_name | db_name | Query | 7758 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs

5.7.21-20

Do you help me?

1.16.29

Use InnoDB

Hey! Your plugin causes an infinite database query loop. I had to turn it off.

Thank you very much for your help. Everything works as it should. I love it! Have a nice day!

Well. Thank you very much for your help. The main search engine works without any problems, the treatment in “Sandbox Area” still has this record when you enter “1080”. My configuration:

https://ibb.co/Fzyypv8
https://ibb.co/R90tL1d
https://ibb.co/7jzcQn8
https://ibb.co/jVJMJ5R

Look this https://ibb.co/2Z2DR3Y. You see? I typed “1080” and found this product for me, but it should not

Yes, it worked before the problem is that if I type “1080” – which is a class from Gutenberg, it also also finds me “heater”, and he is not in the title or content “1080”. I do not know if you understand what I mean? I would like to block the search after the table “posts”, and look only after “postsmeta.” Is there an easy way to do this?

https://ibb.co/MB7dy41. ID is looking good. Additionally, it shows _product_content correctly. But I do not want to enter post_id just a phrase or title.

_product_content is a combination of fields: title and content from the posts table only without HTML, which Guttenberg gives me. 1080 is not post_id only part of the css class that Guttenberg has given me.

I enter it in: https://ibb.co/HN3nXHx . And I would like it to work in the main search engine as well.

As he tests in a sandbox, he returns a wrong result. When entering in Search Tester “1080” returns the wrong product. 1080 is part of the class name from Guttenberg. Therefore, it copies and saves the title + content in the postmeta under the key _product_content. This is my configuration https://ibb.co/m9FsS8w.

I made a code for tests:

add_filter('wpfts_index_post', function($index, $post)
{
  global $wpdb;
  $index['product_content'] = get_post_meta($post->ID, '_product_content', true);
  return $index;
}, 3, 2);

But it also shows the wrong result ??

Thanks for the quick reactions, but something is not working or we have not understood. Becouse _product_content I keep the postmeta table as meta_key value and I would like to filter only after this field. My code is:

add_filter('wpfts_index_post', function($index, $post)
{
  global $wpdb;

  if ($post->post_type == 'product') {
    $index['product_content'] = get_post_meta($post->ID, '_product_content', true);
  }

  return $index;
}, 3, 2);