moviegeek icon indicating copy to clipboard operation
moviegeek copied to clipboard

Cluster model user_id definition

Open obijuan-kenobi opened this issue 5 years ago • 1 comments

If you follow a cluster link on the analytics page, the web app produces an error:

django.db.utils.ProgrammingError: operator does not exist: character varying = integer
LINE 1: ...lytics_rating" WHERE "analytics_rating"."user_id" IN (SELECT...
                                                             ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

I tracked the issue to the analytics.cluster.user_id definition, which should be: user_id = models.CharField(max_length=16) << not 'integer'

obijuan-kenobi avatar Aug 03 '19 16:08 obijuan-kenobi

I've fixed this, same. Either can you turn it to integer or turn it to char field. Besides. This is one of many challenges here man. If you cannot find out more than 10 of them .... good luck, try your best to find them all. Which means you've fully understood the content of the book.

Heermosi avatar Sep 11 '19 08:09 Heermosi