[wpsolr]

1 year, 6 months ago #29692

This step was just to remove your error in debug.log

[giannissak]

1 year, 6 months ago #29693

i am sorry , just saw the 1b step
i have done everything again but every time i reload the 2.2 i am getting this
Error Duplicate column name ‘action’ Data base WordPress ALTER TABLE wp_wpsolr_index_history ADD COLUMN action varchar(1) not null από do_action(‘toplevel_page_solr_settings’), WP_Hook->do_action, WP_Hook->apply_filters, fun_set_solr_options, include(‘/plugins/wpsolr-pro/wpsolr/core/dashboard/dashboard_settings.inc.php’), wpsolr\core\classes\models\WPSOLR_Model_Meta_Type_Abstract->upgrade_database_if_model_has_no_modified_date, wpsolr\core\classes\database\WPSOLR_Database::check_db_version, wpsolr\core\classes\database\WPSOLR_Database::_create_tables, dbDelta, QM_DB->query
[09-May-2022 18:48:03 UTC] PHP Deprecated: Το get_woocommerce_term_meta είναι παρωχημένο από την έκδοση 3.6 και μετά! Χρησιμoποιήστε το get_term_meta αντ’ αυτού. in /home/mrgranazis/domains/mrgranazis.gr/public_html/wp-includes/functions.php on line 5323

[wpsolr]

1 year, 6 months ago #29694

The WPSOLR error is not a real issue. It just happens on 2.2 screen.

PHP Deprecated: Το get_woocommerce_term_meta
This is interesting. If you are running an old version of WooCommerce, this could be the reason indeed.

[giannissak]

1 year, 6 months ago #29695

i am running the woocommerce 6.4.1

[wpsolr]

1 year, 6 months ago #29696

Could be your theme then?

[giannissak]

1 year, 6 months ago #29697

i have activate and try the Twenty Twenty-Two
and still not getting any products in category page .

[wpsolr]

1 year, 6 months ago #29698

Please reindex all your data. And check your debug.log for the same error.

[giannissak]

1 year, 6 months ago #29706

no errors in debug.log and no products in category

[wpsolr]

1 year, 6 months ago #29707

Please check in Kibana that you have product_cat values.

Can you execute in Kibana the Elasticsearch query, and try to find the problem by eliminating bits of subqueries, one at a time.
I suggest starting with product_cat term queries:

{
  "bool": {
    "must": {
      "term": {
        "product_cat_str": "Ανταλλακτικά"
      }
    }
  }
}