osTicket 1.18.0
selfhosted Debian12 on vmWare7
php8.2
mariadb10.11.3

I am having an issue with osTicket 1.18, and I suspect localisation to be the root of the issue.
Specifically, when doing anything with the tasks, it throws the DB Error #1054 (Unknown column 'A7.title' in 'field list').
So far, this checks out, as it is looking for A7.titleAScdata__title, ... FROMosticket_task.
A quick gander over to the DB reveals: jup, not there, as expected.

Here comes the troubling part:
Neither does the setup-script (according to the github's setup/inc/streams/core/install-mysql.sql) line 856ff create a title nor does manually adding a title(mediumtext) resolve anything. What we do have is a localised version of title, which is "Titel" which of course doesn't match the query.
Now both seem to be hardcoded to be added somewhere, but I am stumped as to how to resolve this issue.
Switching either variable is fine, (request or creation), we only need tasks to work.

See attached screenshots for clarification.

This is the error message received via email.

These are the fields in mariadb osticket_task, with the addition of "Titel" and "title", sadly unsuccessful.

In addition to the task being uneditable, it does not even show up in the overview, once the table is changed.

I have tried deleting the __cdata table, no luck there.
https://forum.osticket.com/d/103448-db-error-1054-unknown-column-a7title-in-field-list

  • KevinTheJedi replied to this.

  • ScreaminSteve

    Oh okay, I'm assuming you installed osTicket using the specified language. If that's the case then it's definitely an issue with the language pack.

    Regardless, you can go to the db, go to the _form_field table, find the title field, and update the variable name there. Once changed make sure you follow the above instructions.

    Cheers.

      ScreaminSteve

      Make sure the variable name of the built-in title field is set to title. Also make sure your custom Titel field has a unique variable name that is not title added that will conflict with the built-in field. Then you can drop the task__cdata table and run cron manually a few times until the table is recreated and fully repopulated with data.

      Cheers.

          KevinTheJedi

          Hey Kevin, thanks for the quick answer.
          Sadly, the "Title" variable (here title) is set to "Titel", with me being unable to change it. (as it's greyed out).
          I was meaning to ask where in the osTicket files this is defined (or where in the GUI it is actually changeable) in order for me to rectify this.

              ScreaminSteve

              Oh okay, I'm assuming you installed osTicket using the specified language. If that's the case then it's definitely an issue with the language pack.

              Regardless, you can go to the db, go to the _form_field table, find the title field, and update the variable name there. Once changed make sure you follow the above instructions.

              Cheers.

                  KevinTheJedi

                  I did not realise there is a _form_field table.
                  And I did not even stop to check. 🤦‍♂️
                  Thank you so much, that's it.

                  For future reference, this was
                  osTicket 1.18, semi-fresh install (as in no changes to variables yet) with default german language pack.
                  If your default language pack does unexpected things with your variables, this is the way to go.

                  Topic able to be closed.

                      ScreaminSteve

                      Awesome! Glad it's working now!

                      I will double check the German language pack to see where this was incorrectly translated and make needed changes. Next time we rebuild the language packs (which should be next release) this issue should be resolved.

                      Update:
                      It looks like this has already been updated so next time languages are rebuilt this should be resolved.

                      Cheers.

                        Write a Reply...