Rebuild Search Indices Error

alexgoldmanccmm

We've been having some trouble searching new objects in the database, so I went to rebuild the search indices. It looks like set items and object representations process ok but then get the following error message:

Indexing objects 0.0% 0/4481 ETC: ???. Elapsed: < 1 sec [> ]

PHP Fatal error: Uncaught DatabaseException: Table 'ccmm_providence2.ca_representation_annotations_x_vocabulary_terms' doesn't exist in /home/xxxx/access.ccmmla.org/app/lib/Db/mysqli.php:316

Stack trace:

#0 /home/xxxx/access.ccmmla.org/app/lib/Db/DbStatement.php(151): Db_mysqli->execute(Object(DbStatement), Object(DbStatement), '\n\t\t\t\t\t\tSELECT t...', Array, NULL)

#1 /home/xxxx/access.ccmmla.org/app/lib/Db.php(259): DbStatement->executeWithParamsAsArray(Array, NULL)

#2 /home/xxxx/access.ccmmla.org/app/lib/Search/SearchIndexer.php(865): Db->query('\n\t\t\t\t\t\tSELECT t...', Array)

#3 /home/xxxx/access.ccmmla.org/app/lib/Search/SearchIndexer.php(261): SearchIndexer->indexRow('57', '1', Array, true)

#4 /home/xxxx/access.ccmmla.org/app/lib/Utils/CLIUtils.php(268): SearchIndexer->reindex(NULL, Array)

#5 /home/xxxx/access.ccmmla.org/support/bin/caUtils(167): CLIUtils::rebuild_search_index(Object(Zend_Console_Getopt))

#6 {main}

thrown in /home/xxxx/access.ccmmla.org/app/lib/Db/mysqli.php on line 316

I went into the database and representation_annotations_x_vocabulary_terms is empty but does exist in the database. Any notion as to what is going on here?

Thank you!

Alex

seth

I'd make sure you're looking in the right database using the same credentials as the application is configured with.

alexgoldmanccmm

Definitely the right database, I can log into phpmyadmin using the same credentials, and a configuration check shows that SqlSearch database tables exist. And it's able to run the first two parts of the index rebuild. And checked setup.php just to be absolutely sure!

seth

The error is directly from MySQL, so the implication is that the table

does not, in fact, exist. Or perhaps permissions are set such that the MySQL login the CollectiveAccess application cannot see that table for some reason. Is this a system that was upgraded from an old version?

alexgoldmanccmm

Oh do I feel foolish... somewhere along the line, maybe during a migration, the table got renamed ...vocabulary_term, i.e. missing the 's'. Problem solved!

BasilTas1

Using CA 2.0.9 under PHP 8.4x, I'm constantly having to manually run the re-index, usually from back end via CA Utils. Whenever I add a new object or entity and separately create a new representation, I have to at least Process_Indexing_Queue and on occasions, do the full Rebuild_Search_Indices for the representation to find the object. (I have to do it this way because the Media Loader within the object hasn't worked since migration to CA 2.0 - separate issue for which I received the work-around).
Anyway, when I try to Rebuild_Search_Indices using the browser version in Manage>Administration, it works for a long time, and ends up with "500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed."
I am worried that this is another "not quite compatible" arising from running CA in a Windows IIS environment.
My hope is that
a) those "not quite" Windows-based issues will be resolved in a not-too-distant future version.
b) that background processing of the indexing queue will work properly so I don't have to re-index every time I add related items that need to be linked. Suggestions for settings?

seth

Try adding disable_out_of_process_search_indexing=1 in your app.conf file