PostgreSQL: integer in statement vs. text column
Created by: snai
I am using stable Gitlab 3.0.3 (commit e469084c)
I succesfully created a Issue, and after clicking on it I get a Error 500.
Nov 8 21:49:07 XX postgres[58368]: [6-1] ERROR: operator does not exist: character varying = integer at character 59
Nov 8 21:49:07 XX postgres[58368]: [6-2] HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Nov 8 21:49:07 XX postgres[58368]: [6-3] STATEMENT: SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 1 AND "notes"."noteable_type" = 'Issue'
Nov 8 21:49:07 XX nginx: xxxxxxxxxxxxxxxxxx - - [08/Nov/2012:21:49:07 +0100] "GET /series/issues HTTP/1.1" 500 416 "https://gitlab.XX/series" "Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20100101 Firefox/16.0"
I am on Freebsd 9 x64 pgsql version 9.1.6
I read a lot about this error with postgres, but all of the Issues stated, that this error is resolved.