Ticket::StateType.pluck(:id, :name) => [] returns empty

[root1]

Infos:

• Used Zammad version: 6.0.0
• Used Zammad installation type: docker-compose
• Operating system: ubuntu 22.04

HI,
I’ve encountered an issue with Zammad where the command Ticket::StateType.pluck(:id, :name) returns an empty array [] in the Rails console,

even though the GUI displays the expected values for ticket states.

Additionally, when attempting to add a new ticket status, I receive the following error message:

/usr/local/bundle/gems/railties-6.1.7.4/lib/rails/railtie/configuration.rb:97:in 
`method_missing': undefined method `db_case_sensitive'
 for #<Rails::Application::Configuration:0x00007f79b4cd02c8
 @root=#<Pathname:/opt/zammad>, @generators=#<Rails::Configuration::Generators:0x00007f79b670aa80 @aliases={}, @options={:rails=>{:orm=>:active_record, :test_framework=>:rspec, :integration_tool=>:test_unit, :system_tests=>:test_unit}, :active_record=>{:migration=>true, :timestamps=>true}

I would appreciate any assistance in understanding and resolving this issue.
Thank you!

[dominikklein]

Did you execute the commands inside the correct container? I think here are some other threads related to this problem, e.g. Use zammad console commands with docker-compose

[root1]

@dominikklein

Did you execute the commands inside the correct container?

Yes, I executed the commands inside the “zammad-railsserver” container.

docker-compose exec zammad-railsserver /bin/bash
rails c 

[fliebe92]

Please make sure that this commit is reflected in your current setup. Otherwise, the connection between Rails Console + the database is not correctly set up and you will not get any results by executing the commands above.