Mysql2 Error Table Ticket Accounting types


Cardinal sin… allowed Debian updates which broke Zammad.
At Logon page I get the following error:
Mysql2::Error: Table;zammad.ticket time accounting_types doesn’t exist

  • Used Zammad version: 6.1
  • Used Zammad installation type: Debian Source
  • Operating system: Debian 10
  • Browser + version: Firefox 120.0

Expected behavior:

  • Be able to logon

Actual behavior:

  • Error on logon screen
    Mysql2::Error: Table;zammad.ticket time accounting_types doesn’t exist

Steps to reproduce the behavior:

  • Open logon screen

Seems to be that some migrations didn’t run. You should re-execute the migrations.

1 Like

Ok thanks, not being well trained in Linux would you be refering to this Zammad Package Tutorial when we talk about running migrations?

Or the Docs page on Updating Install/Update


Just run /opt/zammad/contrib/ if you’re using a package installation. Stop Zammad and run rake db:migrate as Zammad user, if you’re using a source code installation.

Please don’t get me wrong, however, the administration of Zammad can be complex. If you don’t feel too confident with Linux administration (which is fine!), please consider Zammad SaaS as a possible option. This will give you support for Zammad and also get the updating Zammad part off your shoulders. No pressure though of course.