DB Error #1054 After updating from version 1.17.3 to version 1.17.4

masrcel

After updating from version 1.17.3 to version 1.17.4, I encountered the problem that every time after receiving e-mail tickets, I get the database error #1054
with the detailed message:
[INSERT INTO ost_ticket__cdata SET field_37='', ticket_id= 18 ON DUPLICATE KEY UPDATE field_37=''] Unknown column 'field_37' in 'field list' ---- Ablaufverfolgung ---- #0 (root)/include/mysqli.php(211): osTicket->logDBError('DB Error #1054', '[INSERT INTO o...') #1 (root)/include/class.dynamic_forms.php(389): db_query('INSERT INTOos...') #2 (root)/include/class.dynamic_forms.php(400): DynamicForm::updateDynamicDataView(Object(DynamicFormEntryAnswer), NULL) #3 (root)/include/class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer(Object(DynamicFormEntryAnswer), NULL) #4 (root)/include/class.orm.php(680): Signal::send('model.created', Object(DynamicFormEntryAnswer)) #5 (root)/include/class.dynamic_forms.php(1535): VerySimpleModel->save(false) #6 (root)/include/class.dynamic_forms.php(1377): DynamicFormEntryAnswer->save(false) #7 (root)/include/class.dynamic_forms.php(1316): DynamicFormEntry->saveAnswers(NULL, false) #8 (root)/include/class.ticket.php(4391): DynamicFormEntry->save() #9 (root)/include/api.tickets.php(142): Ticket::create(Array, Array, 'Email', true, true) #10 (root)/include/api.tickets.php(210): TicketApiController->createTicket(Array, 'Email') #11 (root)/include/class.mailfetch.php(84): TicketApiController->processEmail(Array, Array) #12 (root)/include/class.mailfetch.php(137): osTicket\Mail\Fetcher->processMessage(2, Array) #13 (root)/include/class.email.php(1129): osTicket\Mail\Fetcher->processEmails() #14 (root)/include/class.mailfetch.php(254): MailBoxAccount->fetchEmails() #15 (root)/include/class.cron.php(25): osTicket\Mail\Fetcher::run() #16 (root)/scp/autocron.php(61): Cron::MailFetcher() #17 {main}

Does anyone have a solution for me?
The update was performed as in the instructions

KevinTheJedi

masrcel

Make sure all fields on the Ticket Details Form have Variable Names, once confirmed fully drop the _ticket__cdata table, and run cron manually a bunch of times until the table is rebuilt and fully repopulated with data. Depending on how much data you have you may need to run cron quite a few times.

Cheers.

masrcel

thanks for the support error found