Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
 
Answered
GetREaltimePaymentVendors not installed in the database

I'm getting the following error when trying to run update_installed. Anyone know of a solution?

q2_sdk.hq.exceptions.MissingStoredProcError: Stored Procedure sdk_GetRealtimePaymentVendors not installed in the database

Thanks

Posted 2 years ago
0

Running q2 setup_db has fix these types of errors for me in the past.

— Bradley Bell   2 years ago
0

Unfortunately that's not wanting to work either haha

— Tanner Yea   2 years ago
Votes Newest

Answers


Hey Tanner,

Make sure you are on the latest version of the SDK when you run q2 setup_db. This should work, but if you are still having issues, submit a ticket and we can dive into the database to see what is going on.

Thanks,
Paden Rose

Posted 2 years ago
Paden Rose
160 × 1 Administrator
0

I get an error that says 'failed to build installable wheels for some pyproject.toml based projects (pymssql)' when I update to the latest version of the core

— Tanner Yea   2 years ago
90 Views
1 Answer
2 years ago
2 years ago