Error after upgrade 1.8.0.2 > 1.8.1

[jeffchulg]

DB Error #1054

[INSERT INTO ost_ticket__cdata SET state='', state_id='', ticket_id=13 ON DUPLICATE KEY UPDATE state='', state_id=''] Unknown column 'state_id' in 'field list'

---- Backtrace ----
#0 (root)/include/mysqli.php(138): osTicket->logDBError('DB Error #1054', '[INSERT INTO o...') #1 (root)/include/class.dynamic_forms.php(269): db_query('INSERT INTO os...')
#2 [internal function]: TicketForm::updateDynamicDataView(Object(DynamicFormEntryAnswer), NULL)
#3 (root)/include/class.signal.php(98): call_user_func(Array, Object(DynamicFormEntryAnswer), NULL)
#4 (root)/include/class.orm.php(189): Signal::send('model.created', Object(DynamicFormEntryAnswer))
#5 (root)/include/class.dynamic_forms.php(636): VerySimpleModel->save()
#6 (root)/include/class.ticket.php(2302): DynamicFormEntry->save()
#7 (root)/include/class.upgrader.php(88): Ticket->create(Array, Array, 'api', false, false)
#8 (root)/include/class.upgrader.php(76): Upgrader->createUpgradedTicket()
#9 (root)/include/ajax.upgrader.php(52): Upgrader->setState('done')
#10 [internal function]: UpgraderAjaxAPI->upgrade()
#11 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array)
#12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/upgrader', NULL)
#13 (root)/scp/ajax.php(114): Dispatcher->resolve('/upgrader')
#14 {main}

[jeffchulg]

[SELECT id, f.type, size, name, key, signature, ft, bk, f.created, count(DISTINCT a.object_id) as canned, count(DISTINCT t.ticket_id) as tickets FROM ost_file f LEFT JOIN ost_attachment a ON(a.file_id=f.id) LEFT JOIN ost_ticket_attachment t ON(t.file_id=f.id) WHERE f.id=3 GROUP BY f.id]

Unknown column 'key' in 'field list'



---- Backtrace ----

#0 (root)/include/mysqli.php(138): osTicket->logDBError('DB Error #1054', '[SELECT id, f.t...')

#1 (root)/include/class.file.php(39): db_query('SELECT id, f.ty...')

#2 (root)/include/class.file.php(24): AttachmentFile->load('3')

#3 (root)/include/class.file.php(457): AttachmentFile->AttachmentFile('3')

#4 (root)/include/class.config.php(931): AttachmentFile->lookup('3')

#5 (root)/include/class.config.php(934): OsticketConfig->getLogo('client')

#6 (root)/logo.php(26): OsticketConfig->getClientLogo()

#7 {main}

[ntozier]

Which version of 1.8.1 are you running ( DPR or rc1)?

[jeffchulg]

the RC1 (the one you can get from osticket official website)

[greezybacon]

This should be fixed with 238c3a1, which will drop the __cdata table on upgrade. It will be automatically regenerated (with the new fields) when the tickets queue pages are next queried