Postgresql error on issues
Created by: jean-francois-labbe
I migrated my gitlab to postgresql everything seemed fine. But when i create an issue, the page freezes, and then when i try to open the issues tab i got an error: We're sorry, but something went wrong.
ActionView::Template::Error (PG::Error: ERROR: operator does not exist: character varying = integer
LINE 1: ...OUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 1 AND "n...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
: SELECT COUNT(*) FROM "notes" WHERE "notes"."noteable_id" = 1 AND "notes"."noteable_type" = 'Issue'):
8: %i.icon-tag
9: = label.name
10: - if issue.notes.any?
11: %span.btn.small.disabled.grouped
12: %i.icon-comment
13: = issue.notes.count
14: - if can? current_user, :modify_issue, issue
app/views/issues/_show.html.haml:11:in `_app_views_issues__show_html_haml__1658610414068248998_31080640'
app/views/issues/_issues.html.haml:2:in `block in _app_views_issues__issues_html_haml___1876159060624397005_70049979491860'
app/views/issues/_issues.html.haml:1:in `_app_views_issues__issues_html_haml___1876159060624397005_70049979491860'
app/views/issues/index.html.haml:59:in `_app_views_issues_index_html_haml___2407097325944611842_64265640'
app/controllers/issues_controller.rb:23:in `index'