Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.


If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping


Answers may be delayed for posts that do not include sufficient information.

Query in quotes breaks search

Hi,

We're having an issue with searching phrases within quotes. It isn't consistent, for example, if you search "bea feitler design" the results come up as expected. If you search "the new literacy," this page error is returned:

When searching the same phrase without quotes, it works fine.

Any help on this would be appreciated. Thank you!

Comments

  • The quotes are triggering creation of a temporary table, and your mysql server has limits on how large those tables can be. You should consider changing your mysql configuration increasing the cap for "tmp_table_size"

  • Thanks, that worked! We increased the cap to the size of our largest table.

Sign In or Register to comment.