When updating to 8.12, I had to manually drop the ci_services table to complete the upgrade.
However now I’m having issues with many tasks:
When viewing project services
Unable to save project. Error: PG::SyntaxError: ERROR: zero-length delimited identifier at or near """"
LINE 1: ..."services"."type" IN ('AsanaService') AND "services"."" = $1
^
: DELETE FROM "services" WHERE "services"."type" IN ('AsanaService') AND "services"."" = $1Project ID: 314
When viewing service templates
ActionView::Template::Error (No route matches {:action=>"edit", :controller=>"admin/services", :id=>nil} missing required keys: [:id]):
15: %td
16: = icon("copy", class: 'clgray')
17: %td
18: = link_to edit_admin_application_settings_service_path(service.id) do
19: %strong= service.title
20: %td
21: = service.description
app/views/admin/services/index.html.haml:18:in block in _app_views_admin_services_index_html_haml___4427246500526999510_49287540'
app/views/admin/services/index.html.haml:13:in each'
app/views/admin/services/index.html.haml:13:in _app_views_admin_services_index_html_haml___4427246500526999510_49287540'
lib/gitlab/request_profiler/middleware.rb:15:in call'
lib/gitlab/middleware/rails_queue_duration.rb:20:in call'
lib/gitlab/metrics/rack_middleware.rb:29:in block in call'
lib/gitlab/metrics/transaction.rb:49:in run'
lib/gitlab/metrics/rack_middleware.rb:29:in call'
lib/gitlab/middleware/go.rb:16:in call'
lib/gitlab/middleware/readonly_geo.rb:29:in call'
When editing a service
NoMethodError (undefined method to_sym' for nil:NilClass
Did you mean? to_s):
config/initializers/ar_monkey_patch.rb:16:in _update_record'
app/controllers/admin/services_controller.rb:18:in update'
lib/gitlab/request_profiler/middleware.rb:15:in call'
lib/gitlab/middleware/rails_queue_duration.rb:20:in call'
lib/gitlab/metrics/rack_middleware.rb:29:in block in call'
lib/gitlab/metrics/transaction.rb:49:in run'
lib/gitlab/metrics/rack_middleware.rb:29:in call'
lib/gitlab/middleware/go.rb:16:in call'
lib/gitlab/middleware/readonly_geo.rb:29:in call'
I’ve tried restoring the database however I can’t manage to fix the issue. Any suggestions?