Used Zammad installation type: (source, package, docker-compose, …) package
Operating system: Ubuntu 20.04
Browser + version: Firefox 100
Expected behavior:
MultiSelect Field allows for choosing one or more values
Actual behavior:
MultiSelect Field produces an error - invalid value '[“ABC”, “ZZZ”]; for field “test”!
Steps to reproduce the behavior:
Create a new field as MultiSelect and try to create a ticket
I created a field “TEST” as MultiSelect and when I try to create a ticket choosing 2 of the multislect options I get an error invalid value '[“ABC”, “ZZZ”]; for field “test”!
I tried choosing just one value but I still get an error invalid value '[“ABC”]; for field “test”!
Well I tried this on another Ubuntu 2 box and same thing. Zammad upgrade seems to go OK.
MultiSelect fields cause the same error.
Either I did something wrong or this is a bug. I’m thinking the latter.
I hope that this post get some traction I would love to use this feature. Until there’s a fixed I rolled the VM back so I’m running Zammad 5.0. I would love to be able to use this feature
Here’s the upgrade steps I used.
Step 1: Ensure dependencies
Before proceeding, double-check that your system environment matches Zammad’s requirements.
The package comes with maintenance scripts that will run regular tasks during updates for you.
However
Do not run Zammad updates unattended and always have a look on the outputs these helper scripts generate. Ignoring said output may lead to incomplete updates that may corrupt data or lead to issues you find way too late.
Step 6: Run required extra steps
Extra steps needed for updates are mentioned in our release news.
Huh I wonder why mine won’t. I tried it on 2 different boxes. This is such a wonderful option its sad I won;t be able to use it.
Ubuntu
lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 20.04.4 LTS
Release: 20.04
Codename: focal
MariaDB
mysql -v
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 61
Server version: 10.3.34-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Zammad
Version
This is Zammad version 5.1.x
I just tried it again and it won’t go. I noticed the following error in the production log
> E, [2022-05-13T12:48:14.120920 #665-181260] ERROR – : Invalid value ‘[“OK”, “WTF”]’ for field ‘try5’! (Exceptions::ApplicationModel)
What is “ApplicationModel” and is that why the field won’t work?
I, [2022-05-13T12:48:14.051721 #665-181260] INFO – : Started POST “/api/v1/tickets” for 192.168.7.116 at 2022-05-13 12:48:14 -0400
I, [2022-05-13T12:48:14.056586 #665-181260] INFO – : Processing by TicketsController#create as JSON
I, [2022-05-13T12:48:14.056731 #665-181260] INFO – : Parameters: {“title”=>“abc”, “group_id”=>“1”, “owner_id”=>“3”, “customer_id”=>“3”, “state_id”=>“2”, “priority_id”=>“2”, “article”=>{“to”=>“Users”, “from”=>“Domenic domenic@domain.com”, “body”=>“[FILTERED]”, “type_id”=>5, “sender_id”=>2, “form_id”=>“460474833”, “content_type”=>“text/html”}, “tags”=>“”, “rma”=>“”, “serial_no”=>“”, “product_family”=>“”, “try5”=>[“OK”, “WTF”], “id”=>“c-13”}
E, [2022-05-13T12:48:14.120920 #665-181260] ERROR – : Invalid value ‘[“OK”, “WTF”]’ for field ‘try5’! (Exceptions::ApplicationModel)
app/models/concerns/checks_core_workflow.rb:37:in block in check_restrict_values' app/models/concerns/checks_core_workflow.rb:32:in each_key’
app/models/concerns/checks_core_workflow.rb:32:in check_restrict_values' app/models/concerns/checks_core_workflow.rb:27:in validate_workflows’
app/controllers/tickets_controller.rb:157:in block in create' app/models/transaction.rb:17:in block in execute’
app/models/transaction.rb:14:in execute' app/models/transaction.rb:26:in execute’
app/controllers/tickets_controller.rb:77:in create' app/controllers/application_controller/has_download.rb:21:in block (4 levels) in module:HasDownload’
app/controllers/application_controller/has_download.rb:20:in block (3 levels) in <module:HasDownload>' app/controllers/application_controller/has_download.rb:19:in block (2 levels) in module:HasDownload’
app/controllers/application_controller/handles_transitions.rb:16:in `handle_transaction’
I, [2022-05-13T12:48:14.123809 #665-181260] INFO – : Completed 422 Unprocessable Entity in 66ms (Views: 0.1ms | ActiveRecord: 11.4ms | Allocations: 39227)
Well this is a bust. I have two boxes that allow me to create multiselect fields but they both error out when I try to create a ticket.
So since I was wondering if this issue was somehow related to upgrading Zammad from 5.0 to 5.1 so I just rebuilt a new VM from scratch using Ubuntu 20.04.4 installed Zammad and then I created a multiselect field and same problem
I think the log looks a little bit different
I, [2022-05-13T18:05:45.803998 #679-181420] INFO – : Started POST “/api/v1/tickets” for 192.168.7.116 at 2022-05-13 18:05:45 -0400
I, [2022-05-13T18:05:45.807803 #679-181420] INFO – : Processing by TicketsController#create as JSON
I, [2022-05-13T18:05:45.808089 #679-181420] INFO – : Parameters: {“title”=>“abc”, “group_id”=>“1”, “owner_id”=>“3”, “customer_id”=>“4”, “state_id”=>“2”, “priority_id”=>“2”, “article”=>{“to”=>“Users”, “from”=>“Dd domdis@gdc.com”, “body”=>“[FILTERED]”, “type_id”=>5, “sender_id”=>2, “form_id”=>“479542103”, “content_type”=>“text/html”}, “tags”=>“”, “look”=>[“left”, “up”], “notes”=>“sss”, “id”=>“c-5”}
E, [2022-05-13T18:05:45.847999 #679-181420] ERROR – : Invalid value ‘[“left”, “up”]’ for field ‘look’! (Exceptions::ApplicationModel)
app/models/concerns/checks_core_workflow.rb:37:in block in check_restrict_values' app/models/concerns/checks_core_workflow.rb:32:in each_key’
app/models/concerns/checks_core_workflow.rb:32:in check_restrict_values' app/models/concerns/checks_core_workflow.rb:27:in validate_workflows’
app/controllers/tickets_controller.rb:157:in block in create' app/models/transaction.rb:17:in block in execute’
app/models/transaction.rb:14:in execute' app/models/transaction.rb:26:in execute’
app/controllers/tickets_controller.rb:77:in create' app/controllers/application_controller/has_download.rb:21:in block (4 levels) in module:HasDownload’
app/controllers/application_controller/has_download.rb:20:in block (3 levels) in <module:HasDownload>' app/controllers/application_controller/has_download.rb:19:in block (2 levels) in module:HasDownload’
app/controllers/application_controller/handles_transitions.rb:16:in `handle_transaction’
I, [2022-05-13T18:05:45.850037 #679-181420] INFO – : Completed 422 Unprocessable Entity in 42ms (Views: 0.1ms | ActiveRecord: 7.7ms | Allocations: 35510)
I wonder what all this block (# levels) in module:HasDownload is all about
This is such a bummer. I know you were unable to reproduce it but I reproduced it on 3 different VMs. Two I upgraded to 5.1 and the other a fresh install of 5.1
euhm wel mine instance is a little wierd.
it is on my test env where i’m currently testing our comming upgrade.
the default install was 2.5, upgraded to 3.0, upgraded to 4.1.1, upgraded tot 5.1.1.
the initial setup had 5.0 in between, but this was an other trail test run a little differnt way, skipping 5.0.
Thanks for the reply. I appreciate the details on your upgrade path, it puts some of my questions to bed.
I’m not sure what it means when you say installed from source … I followed the instructions on Install from package — Zammad documentation which I believe is “from package”
Is it possible that from package behaves differently than from source?
I tried to install from source but a few of the instructions fail I get to connect to elasticsearch Connect Zammad with Elasticsearch and the command zammad run rails r “Setting.set(‘es_url’, ‘http://localhost:9200’)” returns zammad: command not found
I guess this is beyond my skill set
So why would the install from package encounter an error when using a multiselect field but it works fine if you install from source ?
There’s gotta be an issues some where (I did an upgrade to an existing instance, loaded from scratch as a package, and I loaded from scratch from source), The only thing that remained constant was Apache and MariaDb is there a syntax error for the Apache code or is there a syntax error in the Mariadb code? Here’s a screenshot of the error
I think there’s a bug with Multiselect Fields and MariaDb.
I started from scratch Ubunto 20.04 Apache2, Esatickserach BUT no DB.
I installed Zammad from package and I do believe that it will use PostgreSQL for a default db.
I tried a multiselectfield and it work! So now do I just wait for someone from Zammad to see this post or do I report it as a bug? @MrGeneration could you advise ?
It is definitely a bug in/with/? MariaDB - I’ve tried to create a MultiSelect object with MariaDB and PosgreSQL. It is always an Error by MariaDB and no Error bei PosgreSQL.
It looks to me like the key and value fields are reversed when created in MariaDB. Or the selection queries are not correct.
There’s gotta be an issues some where (I did an upgrade to an existing instance, loaded from scratch as a package, and I loaded from scratch from source), The only thing that remained constant was Apache and MariaDb is there a syntax error for the Apache code or is there a syntax error in the Mariadb code? Here’s a screenshot of the error