@mollybrucepatterson Is the search in quotes? Or plain?
@TBthegr81 That's hitting a size limitation for your mysql installation.
@sshipley64 So I now have a working Windows Server 2012 installation... next to actually install on IIS. Stay tuned. I know this is taking way too long.
@collectiveaccess yes, but could I empty out that table and just let it re-index what it needs? It feels like 19.4 million rows is a bit excessive either way and letting it grow even further by extending the table size limit would not help anything.
Yeah you might just want to try reindexing. That will kill the table and reload it.
@collectiveaccess the search isn't in quotes.
@mollybrucepatterson Indexing on your system is pulling in identifiers from related objects. I've adjusted it and am reindexing it now.
@collectiveaccess Thanks. I have a new issue with the 1.7.6 pawtucket2-- it works fine with php 5.6 which is what I have on my internal machine. I'm required to have php7 on my public facing server, and the same pawtucket is giving me "PHP Notice: Constant CA_APP_TYPE already defined in D:\digital-collections_new\setup.php on line 320" along with a bunch of undefined index notices. 1.7.5 pawtucket2 works fine on this same server. Checking the boards with similar issues, I made sure that error reporting line is there and turned off clean urls and made a new setup file from the dist and none of them seem to resolve it.
@collectiveaccess that fixed it, thank you!
@sshipley64 Try putting this at the top of your setup.php:
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT);
@collectiveaccess That did it thanks! And thanks for working on the windows issue!