[rvs]

5 years ago #14310

I have a Product (flowers) cat and a Product title (flower name).
Both appear in the suggestions

But sometimes visitors are searching for a combination of both like:

Rose Red Passion

Is there a way to make suggestions appear. Even when the cat and the title are separated in the system?

[wpsolr]

5 years ago #14313

It should suggest your products in category “Rose” with title or content “Red passion”, if you selected the option “Index custom fields and categories” in screen 2.2

[rvs]

5 years ago #14320

I enabled it, saved it and now are all other options deactivated.
Also the option custom fields is gone?

Is this normal?

[rvs]

5 years ago #14322

I cant save my option anymore? after a save all options are disabled?
Is this because my license is activated one day ago?

[rvs]

5 years ago #14323

Also can’t connect to my indexes anymore.

[rvs]

5 years ago #14324

Ok i did a new activation, now the options are back. But now i have errors.

WordPress databasefout: [Multiple primary key defined]
ALTER TABLE wp_wpsolr_index_history CHANGE COLUMN id id bigint unsigned auto_increment primary key

WordPress databasefout: [Duplicate column name ‘action’]
ALTER TABLE wp_wpsolr_index_history ADD COLUMN action varchar(1) not null

[wpsolr]

5 years ago #14325

Did you install a beta version in the past?

Anyway, drop your table wp_wpsolr_index_history, and it should be fine.

[rvs]

5 years ago #14326

No i did the one you send me by dropbox.

[rvs]

5 years ago #14327

For my info.

I can select some taxonomies in the product option.
product_cat
product_tag

But i also can select it as regular option?

Productcategorieën
Producttags

[wpsolr]

5 years ago #14328

The error you got came from the previous installed beta version, with a different wp_wpsolr_index_history table structure.

Drop table wp_wpsolr_index_history, and the plugin will recreate it automatically.

[rvs]

5 years ago #14329

I deleted it but its back

WordPress databasefout: [Multiple primary key defined]
ALTER TABLE wp_wpsolr_index_history CHANGE COLUMN id id bigint unsigned auto_increment primary key

WordPress databasefout: [Duplicate column name ‘action’]
ALTER TABLE wp_wpsolr_index_history ADD COLUMN action varchar(1) not null

[rvs]

5 years ago #14330

https://prnt.sc/pa5cpf

[wpsolr]

5 years ago #14331

You need to drop it completely:
“drop table wp_wpsolr_index_history”

[rvs]

5 years ago #14332

Works thnx

But is there a difference in the field to index “product_tag taxonmies in products” and productcategories?

[rvs]

5 years ago #14333

Sorry “Producttags”