These are chat archives for collectiveaccess/support
@juliaweist Indeed they where set to Not accessible to public...
Next problem: I wanna find if an entity ID is already existing via the ServiceAPI
I do a firstname.lastname@example.org and it doesn't find it, it seems the function only looks in display_label and not idno
Also, when creating new objects in one of the DBs they are not searchable afterwards. But if I run the caUtils rebuild-search-index it works for all the old things but not for stuff we create afterwards.
I think this might be because the ca_sql_search_word_index gets too big and MySQL don't wanna let me store more in that table, it gets to about 22 million rows and the whole search-reindex takes 5.5 hours to complete.
Do I need to swap from SQLSearch to something else, probably ElasticSearch for this to work like it should?
Or should I try to enable bigger tables in MySQL?
Hmm, though I look at the other DB and that haz 35 million rows in the same table, so that doesn't seem to be a factor.
I have looked around in the config-files for options around search indexing but could only find
disable_out_of_process_search_indexing = 0
That is set to 0 on all our DBs.