ClickhouseAnalytics: Table *.vendure_search_event doesn't exist

[Draykee]

I received multiple errors related to the Clickhouse Analytics strategy:

{"timestamp":"2023/06/08 07:38:39 +00:00","level":"error","context":"AdvancedSearchPlugin","message":"Clickhouse error: Code: 60. DB::Exception: Table fainin_search_analytics.vendure_search_event doesn't exist. (UNKNOWN_TABLE) (version 23.3.1.2823 (official build))\n\nquery: \n              SELECT toDate('2023-05-09 07:38:38') + number as date,\n                data.totalQueryCount,\ndata.targetCount,\ndata.rate\n                 FROM numbers(dateDiff('day', toDate('2023-05-09 07:38:38'), toDate('2023-06-08 07:38:38')) + 1) dates\n                  LEFT JOIN (SELECT\n                         row.queryDate date,\n                         count(DISTINCT row.queryId) totalQueryCount,\n                         countIf(event.eventType = 'SEARCH_RESULT_CLICKED') targetCount,\n                         countIf(event.eventType = 'SEARCH_RESULT_CLICKED') / count(DISTINCT row.queryId) rate\n                     FROM vendure_search_query row\n                     LEFT JOIN vendure_search_event event ON row.queryId = event.queryId\n                     GROUP BY row.queryDate) data ON data.date = date\n               FORMAT JSON"}


{"timestamp":"2023/06/08 08:10:55 +00:00","level":"error","context":"AdvancedSearchPlugin","message":"Clickhouse error: Code: 60. DB::Exception: Table fainin_search_analytics.vendure_search_event doesn't exist. (UNKNOWN_TABLE) (version 23.3.1.2823 (official build))\n\nquery: \n            INSERT INTO vendure_search_event (collectionName, queryId, eventType) VALUES ('vendure_products', 'qwujOWidW-p8hdET', 'SEARCH_LIST_VIEWED');\n         FORMAT JSON"}

{"timestamp":"2023/06/08 08:14:20 +00:00","level":"error","context":"AdvancedSearchPlugin","message":"Clickhouse error: Code: 60. DB::Exception: Table fainin_search_analytics.vendure_search_event doesn't exist. (UNKNOWN_TABLE) (version 23.3.1.2823 (official build))\n\nquery: \n            INSERT INTO vendure_search_event (collectionName, queryId, eventType, position, resultId) VALUES ('vendure_products', '-w1GNmFQX9tBVuKg', 'SEARCH_RESULT_CLICKED', 6, '0b738314-960a-4298-ac0b-9db59bd49777');\n         FORMAT JSON"}

When I connect to the database, everything appears to be normal. Except, that position and resultID is always null.

Furthermore, this error is not appearing all the time! And even though a logSearchResultClicked was successfully executed, I can't see any change in the database.

[Draykee]

Btw @michaelbromley is resultId the id of the clicked product?

[michaelbromley]

Thanks for the report, I'm doing a lot of work on this plugin right now to fully update it to v2, so I will check in to this.