job fail in vendure popularity score plugin

[ashishkpaul]

Hi, in vendure version 2.2.3 and getting job fail in packages/vendure-plugin-popularity-scores version 1.6.1

[worker] debug 5/3/24, 1:37 PM - [Vendure Worker] Job 135 [calculate-popularity-scores] starting (attempt 2 of 6) 
[worker] info 5/3/24, 1:37 PM - [PopularityScoresPlugin] Started calculating popularity scores 
[worker] warn 5/3/24, 1:37 PM - [PopularityScoresPlugin] Failed to handle popularity calculation job: invalid input syntax for type integer: "NaN" 
[worker] warn 5/3/24, 1:37 PM - [BullMQJobQueuePlugin] Job 135 [calculate-popularity-scores] failed (attempt 1 of 6) 

while it works with version 1.6.0

[worker] debug 5/3/24, 1:39 PM - [Vendure Worker] Job 136 [calculate-popularity-scores] starting (attempt 2 of 6) 
[worker] info 5/3/24, 1:39 PM - [PopularityScoresPlugin] Started calculating popularity scores 
[worker] info 5/3/24, 1:39 PM - [PopularityScoresPlugin] Finished calculating popularity scores 
[worker] debug 5/3/24, 1:39 PM - [BullMQJobQueuePlugin] Job 136 [calculate-popularity-scores] completed

[martijnvdbrug]

Hi @ashishkpaul . The plugin hasn't been upgraded to support v2.2 yet, but we are almost there. I will try to reproduce your issue when we've finished the upgrade.

[thochoertler]

Hi @martijnvdbrug , I get the same error with vendure 3.1.1. Just as a heads up as I already saw #550 :)

[martijnvdbrug]

@thochoertler Thanks for the report. What database are you using?

I can not seem to reproduce this behavior, while our client envs are also on 3.1.1 already. Any other details? Do you have any placed orders? Does your store have 0 products, or maybe products without variants or anything out of the ordinary?