DB Error #1054

vidfe

Hello, I am presenting this problem currently, I was making modifications in the mail templates and at the moment of carrying out the tests I started to see this error message, I have deleted the ost_user_cdata table as it appears in other forum posts, but the problem still persists , can you help me?

My OsTicket version is: 1.17.3
Server: IIS

[INSERT INTO ost_ticket__cdata SET field_36='', ticket_id= 66 ON DUPLICATE KEY UPDATE field_36='']

Unknown column 'field_36' in 'field list' 
---- Backtrace ---- 
#0 C:\inetpub\wwwroot\osTicket\include\mysqli.php(211): osTicket->logDBError() 
#1 C:\inetpub\wwwroot\osTicket\include\class.dynamic_forms.php(389): db_query() 
#2 C:\inetpub\wwwroot\osTicket\include\class.dynamic_forms.php(400): DynamicForm::updateDynamicDataView() 
#3 C:\inetpub\wwwroot\osTicket\include\class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer() 
#4 C:\inetpub\wwwroot\osTicket\include\class.orm.php(680): Signal::send() 
#5 C:\inetpub\wwwroot\osTicket\include\class.dynamic_forms.php(1535): VerySimpleModel->save() 
#6 C:\inetpub\wwwroot\osTicket\include\class.dynamic_forms.php(1377): DynamicFormEntryAnswer->save() 
#7 C:\inetpub\wwwroot\osTicket\include\class.dynamic_forms.php(1316): DynamicFormEntry->saveAnswers() 
#8 C:\inetpub\wwwroot\osTicket\include\class.ticket.php(4391): DynamicFormEntry->save() 
#9 C:\inetpub\wwwroot\osTicket\include\api.tickets.php(142): Ticket::create() 
#10 C:\inetpub\wwwroot\osTicket\include\api.tickets.php(210): TicketApiController->createTicket() 
#11 C:\inetpub\wwwroot\osTicket\include\class.mailfetch.php(83): TicketApiController->processEmail() 
#12 C:\inetpub\wwwroot\osTicket\include\class.mailfetch.php(137): osTicket\Mail\Fetcher->processMessage() 
#13 C:\inetpub\wwwroot\osTicket\include\class.email.php(1129): osTicket\Mail\Fetcher->processEmails() 
#14 C:\inetpub\wwwroot\osTicket\include\class.mailfetch.php(254): MailBoxAccount->fetchEmails() 
#15 C:\inetpub\wwwroot\osTicket\include\class.cron.php(25): osTicket\Mail\Fetcher::run() 
#16 C:\inetpub\wwwroot\osTicket\include\class.cron.php(110): Cron::MailFetcher() 
#17 C:\inetpub\wwwroot\osTicket\include\api.cron.php(15): Cron::run() 
#18 C:\inetpub\wwwroot\osTicket\include\api.cron.php(45): CronApiController->run() 
#19 C:\inetpub\wwwroot\osTicket\api\cron.php(23): LocalCronApiController::call() 
#20 {main}

KevinTheJedi

vidfe

This has been reported many times; please do a search before creating a discussion to avoid duplicates.

You simply need to make sure all fields on the Ticket Details Form have unique Variable Names. Then you can drop the Ticket CDATA table and run cron manually a bunch of times until the table is recreated and fully repopulated.

Cheers.