Error on ticket listng when fields added to ticket form

te-deum

Hello,

I just have a strange problem in my osTicket 1.18.1.

I added 2 fields/columns to the tickets form to use osTicket personalisation capabilities and just remove them after.
Then my ticket list where broken with an error on the Tickets Query :

<b>Fatal error</b>: Uncaught InconsistentModelException: Unable to prepare query: Unknown column 'B2.subject' in 'field list'
I check my database and just see that the column subject in ost_ticket__cdata was renamed to duree (name of the latest added tickets form field).
I then rename the column to subject and then everything was going back.

Step to reproduce : Simply add 2 columns to the Ticket Form. Then subject column in table will be renamed to the second added field in the ost_ticket__cdata datatable.

te-deum

Here are screenshots :
Datatable before adding columns to tickets form :

Fields added to tickets form :

Datatable after adding columns to tickets form :

KevinTheJedi

te-deum

Do you have a language pack installed/enabled? The system doesn't automatically change the variable of any field unless you or potentially your browser are changing it -or- unless you have a language pack installed and the language pack has this string wrongfully translated. Any of the built-in fields (the greyed out variable fields) must not change names as we use that specific name in the codebase.

Cheers.

KevinTheJedi

te-deum

After posting I do see that you have french. Remove the french language pack and retest. There seems to be an issue with the French language pack. They are translated by community members and sometimes they translate strings that shouldn't be translated.

Cheers.