I am getting constant DB Error 1054 issues. I have searched the forums, tried the various fixes including dropping the ticket CDATA table. Nothing seems to work and its stopping us from being able to search users. This is a new install but I just spent all day configuring everything and doing tests to get templates and settings just right. I do not want to have to start completely over.
[INSERT INTO ostwl_user__cdata
SET phone
='', user_id
= 7 ON DUPLICATE KEY UPDATE phone
='']
Unknown column 'phone' in 'field list'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(207): osTicket->logDBError('DB Error #1054', '[INSERT INTO o...')<br />
#1 (root)/include/class.dynamic_forms.php(389): db_query('INSERT INTO
os...')<br />
#2 (root)/include/class.dynamic_forms.php(404): DynamicForm::updateDynamicDataView(Object(DynamicFormEntryAnswer), NULL)<br />
#3 (root)/include/class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer(Object(DynamicFormEntryAnswer), NULL)<br />
#4 (root)/include/class.orm.php(680): Signal::send('model.created', Object(DynamicFormEntryAnswer))<br />
#5 (root)/include/class.dynamic_forms.php(1535): VerySimpleModel->save(false)<br />
#6 (root)/include/class.dynamic_forms.php(1377): DynamicFormEntryAnswer->save(false)<br />
#7 (root)/include/class.dynamic_forms.php(1316): DynamicFormEntry->saveAnswers(NULL, false)<br />
#8 (root)/include/class.user.php(351): DynamicFormEntry->save()<br />
#9 (root)/include/class.user.php(424): User->addForm(Object(UserForm), 1, Array)<br />
#10 (root)/include/class.user.php(253): User->addDynamicData(Array)<br />
#11 (root)/include/class.user.php(290): User::fromVars(Array, true)<br />
#12 (root)/include/ajax.users.php(307): User::fromForm(Object(SimpleForm))<br />
#13 (root)/include/class.dispatcher.php(153): UsersAjaxAPI::addUser()<br />
#14 (root)/include/class.dispatcher.php(40): UrlMatcher->dispatch('/lookup/form', Array)<br />
#15 (root)/include/class.dispatcher.php(122): Dispatcher->resolve('/lookup/form', Array)<br />
#16 (root)/include/class.dispatcher.php(40): UrlMatcher->dispatch('/users/lookup/f...', NULL)<br />
#17 (root)/scp/ajax.php(326): Dispatcher->resolve('/users/lookup/f...')<br />
#18 {main}
[INSERT INTO ostwl_user__cdata
SET phone
='9999999999X5501', user_id
= 6 ON DUPLICATE KEY UPDATE phone
='9999999999X5501']
Unknown column 'phone' in 'field list'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(207): osTicket->logDBError('DB Error #1054', '[INSERT INTO o...')<br />
#1 (root)/include/class.dynamic_forms.php(389): db_query('INSERT INTO
os...')<br />
#2 (root)/include/class.dynamic_forms.php(404): DynamicForm::updateDynamicDataView(Object(DynamicFormEntryAnswer), NULL)<br />
#3 (root)/include/class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer(Object(DynamicFormEntryAnswer), NULL)<br />
#4 (root)/include/class.orm.php(680): Signal::send('model.created', Object(DynamicFormEntryAnswer))<br />
#5 (root)/include/class.dynamic_forms.php(1535): VerySimpleModel->save(false)<br />
#6 (root)/include/class.dynamic_forms.php(1377): DynamicFormEntryAnswer->save(false)<br />
#7 (root)/include/class.dynamic_forms.php(1316): DynamicFormEntry->saveAnswers(NULL, false)<br />
#8 (root)/include/class.user.php(351): DynamicFormEntry->save()<br />
#9 (root)/include/class.user.php(424): User->addForm(Object(UserForm), 1, Array)<br />
#10 (root)/include/class.user.php(253): User->addDynamicData(Array)<br />
#11 (root)/include/class.user.php(290): User::fromVars(Array, true)<br />
#12 (root)/include/ajax.users.php(307): User::fromForm(Object(SimpleForm))<br />
#13 (root)/include/class.dispatcher.php(153): UsersAjaxAPI::addUser()<br />
#14 (root)/include/class.dispatcher.php(40): UrlMatcher->dispatch('/lookup/form', Array)<br />
#15 (root)/include/class.dispatcher.php(122): Dispatcher->resolve('/lookup/form', Array)<br />
#16 (root)/include/class.dispatcher.php(40): UrlMatcher->dispatch('/users/lookup/f...', NULL)<br />
#17 (root)/scp/ajax.php(326): Dispatcher->resolve('/users/lookup/f...')<br />
#18 {main}