Forum Replies Created
- sraggioParticipant1 week, 1 day ago in reply to: User access error? #42738
Related in that it’s part of the same setup. For this latest permissions issue, I created a new index with the exact same configuration, attached the same user, and everything worked. Not sure what happened to cause the permissions error on the first index. Thanks for the info on CloudWatch, I’ll take a look and see what I can find there.
sraggioParticipant1 month ago in reply to: Error Connecting Index: not a valid key=value pair (missing equal-sign)… #41058The Opensearch documentation linked above is the tutorial I followed. The screenshots are a bit out of date, particularly when creating the domain. I didn’t see an option (per sections 3.7 – 3.9) to insert the new user ARN in the Access Policy section. I selected “set IAM ARN as master user” and pasted the new user ARN there, which worked, and allowed me to create a new index in WPSolr.
The documentation specifies using a “Development and Testing” deployment type and t3.small.search. Are you recommending this for production use as well, or will a production deployment type be required?
sraggioParticipant1 month ago in reply to: Error Connecting Index: not a valid key=value pair (missing equal-sign)… #40963My Policy is set up to grant all permissions:
{
“Version”: “2012-10-17”,
“Statement”: [
{
“Sid”: “VisualEditor0”,
“Effect”: “Allow”,
“Action”: “es:*”,
“Resource”: “*”
}
]
}sraggioParticipant1 month ago in reply to: Error Connecting Index: not a valid key=value pair (missing equal-sign)… #40962I discovered an error copy/pasting the secret key. Now, with the correct ID/key info, I see the following error:
{“error”:{“root_cause”:[{“type”:”security_exception”,”reason”:”no permissions for [indices:admin/create] and User [name=arn:aws:iam::760237134273:user/broinc-wpsolr-user, backend_roles=[], requestedTenant=null]”}],”type”:”security_exception”,”reason”:”no permissions for [indices:admin/create] and User [name=arn:aws:iam::760237134273:user/broinc-wpsolr-user, backend_roles=[], requestedTenant=null]”},”status”:403}
sraggioParticipant1 month ago in reply to: Error Connecting Index: not a valid key=value pair (missing equal-sign)… #40961Yes, region is us-east-1
sraggioParticipant1 month, 2 weeks ago in reply to: Current version download link? #40265Thanks for confirming. I had to deactivate then reactivate license, now it is recognized by both sites.
sraggioParticipant1 month, 2 weeks ago in reply to: Current version download link? #40263The tabs in my gotosolr account don’t match what you’re showing in your link. I don’t have an “upgrade/convert” tab. When I open my subscription link I see only “Main Details / Add/Remove Extensions / Extensions Activated” tabs. I was able to purchase a second seat under “Add/Remove Extensions” but I don’t think this is what I need. Can you convert that to a second seat for my plugin license, or provide me with a link to upgrade? We have a subscription for our www (live) site, and want to purchase a seat for our test (development) site.
sraggioParticipant1 month, 2 weeks ago in reply to: Current version download link? #40137What are my options, then, to test updates prior to updating our live site? Can I move our license back and from from our test subdomain to our live site?
sraggioParticipant6 months, 2 weeks ago in reply to: Slow keyword search #36769Update on this: We discovered that it was a conflict with the Booster Tools SKU plugin. Disabling that plugin resolved the slow keyword search issue.
sraggioParticipant1 year ago in reply to: Slow keyword search #33134Yes, origin is:
Plugin: wpsolr-prosraggioParticipant1 year ago in reply to: Slow keyword search #33132The first one I posted came from the “Slow Queries” section of QM. The second one was from “WPSOLR queries” section.
sraggioParticipant1 year ago in reply to: Slow keyword search #33130However, looking at the WPSolr section of the Query Monitor, I see 977ms for time and the following query:
{ “options”: { “handler”: “select”, “resultclass”: “Solarium\\QueryType\\Select\\Result\\Result”, “documentclass”: “Solarium\\QueryType\\Select\\Result\\Document”, “query”: “text:(kobow)”, “start”: 0, “rows”: 20, “fields”: “*,score”, “omitheader”: true, “querydefaultoperator”: “AND” }, “query”: “text:(kobow)”, “highlighting”: [ { “name”: “title”, “simpleprefix”: “”, “simplepostfix”: “<\/b>”, “fragsize”: 400 } ], “sorts”: { “_sku_i”: “desc” }, “grouping”: { “fields”: [], “options”: { “resultquerygroupclass”: “Solarium\\Component\\Result\\Grouping\\QueryGroup”, “resultvaluegroupclass”: “Solarium\\Component\\Result\\Grouping\\ValueGroup” } }, “fields”: [ “id”, “PID”, “type”, “meta_type_s”, “title”, “numcomments”, “comments”, “displaydate”, “displaymodified”, “*categories_str”, “author”, “*post_thumbnail_href_str”, “*post_href_str”, “snippet_s” ], “facets”: { “_stock_status_str”: { “type”: “field”, “excludes”: [] }, “product_badges_str”: { “type”: “field”, “excludes”: [] }, “product_cat_str”: { “type”: “field”, “excludes”: [] }, “_regular_price_f”: { “type”: “range”, “excludes”: [] }, “pa_genre_str”: { “type”: “field”, “excludes”: [] }, “pa_record-label_str”: { “type”: “field”, “excludes”: [] } }, “filters”: { “authorized indexed types”: { “query”: “type:(\”product\”)”, “tags”: [ “fct_excl_type” ] }, “bad_statuses”: { “query”: “-post_status_s:(\”draft\” OR \”pending\” OR \”trash\” OR \”future\” OR \”private\” OR \”auto-draft\”)”, “tags”: [] }, “_stock_status_str:instock_stock_status_str”: { “query”: “_stock_status_str:(\”instock\”)”, “tags”: [ “” ] }, “type:producttype”: { “query”: “type:(\”product\”)”, “tags”: [ “” ] }, “woocommerce exclude-from-search visibility”: { “query”: “((-type:(product)) OR ((((*:* -product_visibility_str:*)) OR (-product_visibility_str:(exclude\\-from\\-search)))))”, “tags”: [] }, “front-end exclusion 1”: { “query”: “(*:* -is_excluded_s:[* TO *]) OR is_excluded_s:(n)”, “tags”: [] } } }sraggioParticipant1 year ago in reply to: Slow keyword search #33129That worked, thanks. Query monitor is logging now, this is what I see for a recent search:
Timing: 18.0193
Query: SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta AS wcj_sku
ON (wp_posts.ID = wcj_sku.post_id)
WHERE 1=1
AND ( wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (269027) ) )
AND (((wp_posts.post_title LIKE ‘%kobow%’)
OR (wcj_sku.meta_key = ‘_sku’
AND CAST(wcj_sku.meta_value AS CHAR) LIKE ‘%kobow%’)
OR (wp_posts.post_excerpt LIKE ‘%kobow%’)
OR (wp_posts.post_content LIKE ‘%kobow%’)))
AND ((wp_posts.post_type = ‘product’
AND (wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘acf-disabled’
OR wp_posts.post_status = ‘wc-printed’
OR wp_posts.post_status = ‘private’)))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_title LIKE ‘%kobow%’ DESC, wp_posts.post_date DESC
LIMIT 0, 20sraggioParticipant1 year ago in reply to: Slow keyword search #33126The deactivate button does not work, just bounces me back to the first screen indicating that the license is valid. Any other way to deactivate?
sraggioParticipant1 year ago in reply to: Slow keyword search #33105When I try to activate the Query Monitor extension on the live site, it asks me for my license. When I enter I get the following message: “Your subscription’s maximum number of 1 ‘WPSOLR PRO – All packs’ licenses is reached. Please remove some licenses first, or upgrade your subscription to add more licenses.”
We have an “all packs” license, and are only using the plugin on this one site. Can you let me know what I need to do to activate the Query Monitor extension?