We started getting these errors a while ago. I tried renaming the table which did not work. I just updated osticket to 1.17.5 from 1.17.3 and then renaming the table but no joy
[INSERT INTO ost_ticket__cdata SET field_189='', ticket_id= 411 ON DUPLICATE KEY UPDATE field_189='']
Unknown column 'field_189' in 'field list'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(224): osTicket->logDBError()<br />
#1 (root)/include/class.dynamic_forms.php(389): db_query()<br />
#2 (root)/include/class.dynamic_forms.php(400): DynamicForm::updateDynamicDataView()<br />
#3 (root)/include/class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer()<br />
#4 (root)/include/class.orm.php(680): Signal::send()<br />
#5 (root)/include/class.dynamic_forms.php(1535): VerySimpleModel->save()<br />
#6 (root)/include/class.dynamic_forms.php(1377): DynamicFormEntryAnswer->save()<br />
#7 (root)/include/class.dynamic_forms.php(1316): DynamicFormEntry->saveAnswers()<br />
#8 (root)/include/class.ticket.php(4392): DynamicFormEntry->save()<br />
#9 (root)/include/api.tickets.php(142): Ticket::create()<br />
#10 (root)/include/api.tickets.php(210): TicketApiController->createTicket()<br />
#11 (root)/include/class.mailfetch.php(84): TicketApiController->processEmail()<br />
#12 (root)/include/class.mailfetch.php(137): osTicket\Mail\Fetcher->processMessage()<br />
#13 (root)/include/class.email.php(1133): osTicket\Mail\Fetcher->processEmails()<br />
#14 (root)/include/class.mailfetch.php(254): MailBoxAccount->fetchEmails()<br />
#15 (root)/include/class.cron.php(25): osTicket\Mail\Fetcher::run()<br />
#16 (root)/include/class.cron.php(110): Cron::MailFetcher()<br />
#17 (root)/include/api.cron.php(15): Cron::run()<br />
#18 (root)/include/api.cron.php(45): CronApiController->run()<br />
#19 (root)/api/cron.php(23): LocalCronApiController::call()<br />
#20 {main}
show table status like 'ost_usercdata';
show table status like 'ost_usercdata';
+-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
| ost_user__cdata | InnoDB | 10 | Dynamic | 97 | 168 | 16384 | 0 | 0 | 0 | NULL | 2023-11-24 16:40:09 | NULL | NULL | utf8mb3_general_ci | NULL | | |
+-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
1 row in set (0.00 sec)
