I recently added a custom field, "minutes_spent", to the Ticket Details form using the built in forms editor (Admin Panel > Manage > Forms > Ticket Details). I was using this field to track how many minutes were spent on each ticket. It has been working great and I haven't had any problems with that field. I decided that I'd rather track hours instead, so I created a new field called "hours". I then logged into the MySQL console and performed an update statement to copy the "minutes_spent" values into the "hours" field and to convert the minutes into hours. This also worked without a hitch. When I log into the osTicket web panel, my "minutes_spent" field is filled out, however, the hours field is blank. I've double checked that the SQL update went through, and it did. I then took this one step further, and ran another update statement to copy all of the data from the "minutes_spent" field to the "hours" field and osTicket is still showing the old numbers.I tried restarting Apache, MySQL, and then finally, the server. Any ideas why my ticket details form isn't pulling the new data from the database?

Found a related forum post: http://www.forum.osticket.com/d/discussion//sync-fields-in-the-web-interface-with-the-databaseIt appears that I'm using the wrong tables to update this information and that ost_ticket__cdata is a temporary table of some sort. The correct tables to use are ost_form_entry and ost_form_entry_values.

Yup.  You have answered your own question.

Thanks for hopping in anyway! It's nice to see you back around here.

Thanks for following up and letting us know what you found.  Other than vacations I'm usually here 6 days a week. :)Should I close this thread?

Yes, please close this thread. I was able to run a query to update my custom fields. Everything looks great.

Write a Reply...