Help with reports, showing dept field in blank.

zydmeister

that error presents the log.

[INSERT INTO ost_ticket__cdata SET departamento='0', ticket_id= 680 ON DUPLICATE KEY UPDATE departamento='0']

Unknown column 'departamento' in 'field list' 
---- Backtrace ---- 
#0 (root)/include/mysqli.php(207): osTicket->logDBError() 
#1 (root)/include/class.dynamic_forms.php(389): db_query() 
#2 (root)/include/class.dynamic_forms.php(400): DynamicForm::updateDynamicDataView() 
#3 (root)/include/class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer() 
#4 (root)/include/class.orm.php(684): Signal::send() 
#5 (root)/include/class.dynamic_forms.php(1535): VerySimpleModel->save() 
#6 (root)/include/class.forms.php(1451): DynamicFormEntryAnswer->save() 
#7 (root)/include/class.ticket.php(3824): FormField->save() 
#8 (root)/include/ajax.tickets.php(706): Ticket->updateField() 
#9 (root)/include/class.dispatcher.php(153): TicketsAjaxAPI->editField() 
#10 (root)/include/class.dispatcher.php(40): UrlMatcher->dispatch() 
#11 (root)/include/class.dispatcher.php(122): Dispatcher->resolve() 
#12 (root)/include/class.dispatcher.php(40): UrlMatcher->dispatch() 
#13 (root)/scp/ajax.php(326): Dispatcher->resolve() 
#14 {main}

sorry for my bad english

KevinTheJedi

zydmeister

Drop the ticket__cdata table in the database and run cron manually a bunch of times until all the data is fully repopulated.

The Cron file is located at /path/to/osTicket/api/cron.php and can be ran via command line with the appropriate PHP instance. Below is an example:

php /path/to/osTicket/api/cron.php

Cheers.

zydmeister

KevinTheJedi thanks bro, i will see if it fix the problem.