Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-604

Mysql Database is created as Latin1 on on-prem generating encoding errors in searchbox

    XMLWordPrintable

Details

    Description

      Searching application causes Internal Application Error on AMP 2.1 On-premises.

      My system-app pod logged this error when I click the search button, so it seems character code configurations in DDL is wrong.

      [1f89f59a-d203-4460-a2ed-37fcea3ef891] [3scale-admin.apps.example.com] [10.129.2.1] 
      ActionView::Template::Error (Mysql2::Error: COLLATION 'UTF8_GENERAL_CI' is not valid for CHARACTER SET 'latin1': SELECT  `cinstances`.* FROM `cinstances` INNER JOIN `services` ON `services`.`id` = `cinstances`.`service_id` WHERE `cinstances`.`type` IN ('Cinstance') AND `services`.`account_id` = 2 AND (cinstances.name COLLATE UTF8_GENERAL_CI LIKE '%a%')  ORDER BY cinstances.created_at DESC LIMIT 20 OFFSET 0):
          47:             = switch_link 'Create Application', new_admin_buyers_account_application_path(@account), :class => 'action add',
          48:           :upgrade_notice => true, :switch => :multiple_applications
          49: 
          50:     - if @cinstances.present? || @account.nil?
          51:       tr class="search"
          52:         th class="select"
          53:         = form_for @search, as: :search, url: search_path, html: { method: :get, class: :search } do |s|
        app/views/buyers/applications/_listing.html.slim:50:in `_app_views_buyers_applications__listing_html_slim__1763592581043441578_69548560'
        app/views/buyers/applications/index.html.slim:13:in `_app_views_buyers_applications_index_html_slim___59981190106127675_73997120'
        lib/three_scale/middleware/multitenant.rb:116:in `_call'
        lib/three_scale/middleware/multitenant.rb:111:in `call'
        lib/action_dispatch/rails5_ssl.rb:86:in `call'
      10.64.242.29 - - [25/Dec/2017:04:40:20 +0000] "GET /500?utf8=%E2%9C%93&search%5Bname%5D=a&search%5Bstate%5D=&search%5Baccount_query%5D=&search%5Bplan_id%5D= HTTP/1.1" 500 - 0.0556
      

      Attachments

        Activity

          People

            orimarti Oriol Marti (Inactive)
            rhn-support-tkonishi Takayuki Konishi
            Peter Stanko Peter Stanko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: