empty category pages

  • wpsolr
    Keymaster
    9 months ago #29671

    Can you check for errors in debug.log?
    You can also monitor the Elasticsearch/Solr/Algolia query, to find the problem by executing it manually.

    • This reply was modified 9 months ago by wpsolr.
    giannissak
    Participant
    9 months ago #29674

    in query monitor i’m getting this:

    (removed)
    • This reply was modified 9 months ago by wpsolr.
    • This reply was modified 2 weeks ago by wpsolr.
    giannissak
    Participant
    9 months ago #29675

    In Debug im getting :
    [09-May-2022 07:37:18 UTC] Error Multiple primary key defined in Data base WordPress για αίτηση ALTER TABLE wp_wpsolr_index_history CHANGE COLUMN id id bigint unsigned auto_increment primary key από 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

    wpsolr
    Keymaster
    9 months ago #29679

    Do you have some custom code that could have modified this query?

    wpsolr
    Keymaster
    9 months ago #29680

    Drop your table wp_wpsolr_index_history first, to get rid of this error. The table should be recreated on full reindexing.

    Which version of WPSOLR do you currently use?

    giannissak
    Participant
    9 months ago #29681

    i have drop the wp_wpsolr_index_history many times and keep getting the same error

    i’m using the WPSOLR PRO 22.2

    wpsolr
    Keymaster
    9 months ago #29682

    Can you copy here your current table definition?

    In your database manager:
    DESCRIBE wp_wpsolr_index_history;

    giannissak
    Participant
    9 months ago #29683

    DESCRIBE wp_wpsolr_index_history;
    id bigint(20) unsigned NO PRI NULL auto_increment
    model_id varchar(100) NO NULL
    model_meta_type varchar(100) NO MUL NULL
    modified datetime NO MUL 0000-00-00 00:00:00
    action varchar(1) NO NULL

    wpsolr
    Keymaster
    9 months ago #29684

    Check the option ‘wdm_db’ in your database with:
    SELECT * FROM wp_options where option_name = 'wdm_db'

    If not already, change it to:
    a:1:{s:15:"current_version";s:4:"21.5";}

    This should prevent the debug.log error.

    • This reply was modified 9 months ago by wpsolr.
    giannissak
    Participant
    9 months ago #29686

    no i am getting this:
    Duplicate column name ‘action’ …. 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

    wpsolr
    Keymaster
    9 months ago #29687

    What is the results of SELECT * FROM wp_options where option_name = 'wdm_db' ?

    giannissak
    Participant
    9 months ago #29688

    now it’s a:1:{s:15:”current_version”;s:4:”21.5″;}

    wpsolr
    Keymaster
    9 months ago #29689

    1. In wpsolr-pro/wpsolr/core/classes/database/class-wpsolr-database.php, line 18, comment all content of function function check_db_version(). Replace it with one line WPSOLR_Service_Container::getOption()->set_db_current_version( $db_version );

    2. Reload your screen 2.2 to set the correct version in database

    3. Undo step 1.

    wpsolr
    Keymaster
    9 months ago #29690

    I forgot:

    step 1b. in wpsolr-pro/wpsolr/core/classes/models/class-wpsolr-model-meta-type-abstract.php, line 312, comment line if ( ! static::$is_checked_db_version && ( is_null( $this->column_last_updated ) ) ) { and replace it with if (true) {

    giannissak
    Participant
    9 months ago #29691

    Done, still no products inside categories

Viewing 15 posts - 16 through 30 (of 39 total)

You must be logged in to reply to this topic.