Need some help in resolving this error, every time someone creates a ticket, this error gets triggered.

[INSERT INTO ost_ticket__cdata SET field_41='', ticket_id= 81 ON DUPLICATE KEY UPDATE field_41='']

Unknown column 'field_41' in 'field list'<br />
<br />
---- Backtrace ----<br />
#0 C:\inetpub\wwwroot\helpdesk\include\mysqli.php(211): osTicket->logDBError()<br />
#1 C:\inetpub\wwwroot\helpdesk\include\class.dynamic_forms.php(389): db_query()<br />
#2 C:\inetpub\wwwroot\helpdesk\include\class.dynamic_forms.php(400): DynamicForm::updateDynamicDataView()<br />
#3 C:\inetpub\wwwroot\helpdesk\include\class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer()<br />
#4 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(680): Signal::send()<br />
#5 C:\inetpub\wwwroot\helpdesk\include\class.dynamic_forms.php(1535): VerySimpleModel->save()<br />
#6 C:\inetpub\wwwroot\helpdesk\include\class.dynamic_forms.php(1377): DynamicFormEntryAnswer->save()<br />
#7 C:\inetpub\wwwroot\helpdesk\include\class.dynamic_forms.php(1316): DynamicFormEntry->saveAnswers()<br />
#8 C:\inetpub\wwwroot\helpdesk\include\class.ticket.php(4391): DynamicFormEntry->save()<br />
#9 C:\inetpub\wwwroot\helpdesk\include\api.tickets.php(142): Ticket::create()<br />
#10 C:\inetpub\wwwroot\helpdesk\include\api.tickets.php(210): TicketApiController->createTicket()<br />
#11 C:\inetpub\wwwroot\helpdesk\include\class.mailfetch.php(84): TicketApiController->processEmail()<br />
#12 C:\inetpub\wwwroot\helpdesk\include\class.mailfetch.php(137): osTicket\Mail\Fetcher->processMessage()<br />
#13 C:\inetpub\wwwroot\helpdesk\include\class.email.php(1129): osTicket\Mail\Fetcher->processEmails()<br />
#14 C:\inetpub\wwwroot\helpdesk\include\class.mailfetch.php(254): MailBoxAccount->fetchEmails()<br />
#15 C:\inetpub\wwwroot\helpdesk\include\class.cron.php(25): osTicket\Mail\Fetcher::run()<br />
#16 C:\inetpub\wwwroot\helpdesk\scp\autocron.php(61): Cron::MailFetcher()<br />

  • KevinTheJedi replied to this.

  • nibritto

    Go to Admin Panel > Manage > Forms, click Ticket Details Form, make sure all of your Fields have a Variable name, and Save Changes. Now, you can run cron manually over and over until the table is fully recreated and repopulated with data. We populate data in batches so the cron will need multiple runs depending on how many Tickets you have.

    If you don't already have one, it's highly recommended that you setup a working Cron Job even if you don't fetch emails. Reason being is the Cron Job will routinely run system tasks like cleaning expired sessions, deleting orphaned files, rebuilding/repopulating CDATA tables, etc. Without it the system will simply rely on Auto-Cron which only runs during Agent activity; meaning an Agent has to be logged in (have an active session) and doing actions. It wouldn't run nearly as often as a Cron Job would.

    Cheers.

      nibritto

      Go to Admin Panel > Manage > Forms, click Ticket Details Form, make sure all of your Fields have a Variable name, and Save Changes. Now, you can run cron manually over and over until the table is fully recreated and repopulated with data. We populate data in batches so the cron will need multiple runs depending on how many Tickets you have.

      If you don't already have one, it's highly recommended that you setup a working Cron Job even if you don't fetch emails. Reason being is the Cron Job will routinely run system tasks like cleaning expired sessions, deleting orphaned files, rebuilding/repopulating CDATA tables, etc. Without it the system will simply rely on Auto-Cron which only runs during Agent activity; meaning an Agent has to be logged in (have an active session) and doing actions. It wouldn't run nearly as often as a Cron Job would.

      Cheers.

        Thanks for the feedback, what I did was drop table CDATA and then re-run the cron job a few times. that seems to do the trick

        Write a Reply...