osTicket (v1.18.1)
Apache/2.4.58
Ubuntu 24.04.1
MySQL 8.0.40
Version PHP 8.3.6
Hello folks,
I am trying to create a procedure for migrating custom lists and forms from QA to production.
To migrate from QA to production (actually its copied to pre-production), I copied the changes from the following tables:
- ost_form
- ost_form_field
- ost_list
- ost_list_items
I didn't encounter any issues and the testers and myself did not see problems. After a few days, I noticed that ost_ticket__cdata was not updating. I performed the usual fix of:
- adding a dummy field to ticket details (also attempted to add and delete the dummy field to the custom forms), saving the form and then deleting it
- running the cron script
However, ost_ticket__cdata is updated only with ticket detail fields and does not contain data from my custom fields.
I have performed the following checks:
- ost_ticket.id is present in ost_form_entry.object_id
- ost_form.id is present in ost_form_entry.form_id
- ost_form_entry.id is present in ost_form_entry_values.entry_id
- ost_form_entry_values.field_id is present in ost_form_field.id
Are there other table/data dependencies that I need to check for to make sure that ost_ticket__cdata gets fully updated with all my custom fields?
Or, do you advise not to copy tables to migrate custom list and form changes from QA to pre-production?
Thank you.
