Hi,
Looking at the line in the error info you posted
mysqli error: [1305: PROCEDURE u57370db5nd.search_elasticsearch_queue_artefact_trigger does not exist] in EXECUTE("UPDATE "artefact"
It seems like you had a trigger on the 'artefact' table that pointed to a procedure that no longer existed.
In v19.10 we got rid of the elasticsearch triggers / procedures (instead handle things at PHP level).
So it sounds like procedure was removed before trigger during upgrade - and placing the drop_elasticsearch_triggers(); line in the code dropped them correctly
The create_elasticsearch_triggers(); doesn't actually do anything anymore as the ElasticsearchIndexing::create_triggers($type); also just calls drop_triggers()
Those function will be removed in a future release
Hi,
Looking at the line in the error info you posted
mysqli error: [1305: PROCEDURE u57370db5nd. search_ elasticsearch_ queue_artefact_ trigger does not exist] in EXECUTE("UPDATE "artefact"
It seems like you had a trigger on the 'artefact' table that pointed to a procedure that no longer existed.
In v19.10 we got rid of the elasticsearch triggers / procedures (instead handle things at PHP level).
So it sounds like procedure was removed before trigger during upgrade - and placing the drop_elasticsea rch_triggers( ); line in the code dropped them correctly
The create_ elasticsearch_ triggers( ); doesn't actually do anything anymore as the ElasticsearchIn dexing: :create_ triggers( $type); also just calls drop_triggers()
Those function will be removed in a future release