Fatal Error on Searching for "New "

tns_jd · February 24

We've started to see an error with certain search phrases in both providence and pawtucket. If we search for things like "new york" or "new school" it returns an error (The table 'ca_sql_search_phrase_8b272455447bb70830c165de38062b58' is full). It only happens with these terms in quotations. This is a recent change in behavior and doesn't occur in our dev instance, which has an older version of the DB.

You can see the full error here: https://digital.archives.newschool.edu/index.php/MultiSearch/Index?search=%22new+school%22

Thanks.

seth · February 24

What versions are you using? The older search engine create a temporary table for phrase searches, and if your mysql install caps temporary table size you can get this error.

tns_jd · February 28

We're on v1.7.13 for production, but testing out 1.7.16 on dev. Maybe that's why the dev site isn't having the same problem.

seth · February 28

That is likely.

Fatal Error on Searching for "New "

Comments