As the admin for the site, jorb alerted me to this thread. I recently upgraded php from 5 to 7, and it was using the default setting. I added a my.cnf file with the length statement, restarted the server and rebuilt the indexes using mysqlcheck --repair --databases ourdb. That fixed the problem.
This is good news - Thanks for your speedy reply
