Good afternoon, I’m new to osTicket I followed the install guide and appear to have an issue with adding or searching users. Each time a user is added I get two “DB Error #1054” one is

[INSERT INTO ost_user__cdata SET notes='', user_id= 33 ON DUPLICATE KEY UPDATE notes='']

Unknown column 'notes' in 'field list'<br /> <br />
---- Backtrace ----<br />
#0 C:\inetpub\wwwroot\support\include\mysqli.php(201): osTicket->logDBError()<br />
#1 C:\inetpub\wwwroot\support\include\class.dynamic_forms.php(381): db_query()<br />
#2 C:\inetpub\wwwroot\support\include\class.dynamic_forms.php(396): DynamicForm::updateDynamicDataView()<br />
#3 C:\inetpub\wwwroot\support\include\class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer()<br />
#4 C:\inetpub\wwwroot\support\include\class.orm.php(680): Signal::send()<br />
#5 C:\inetpub\wwwroot\support\include\class.dynamic_forms.php(1536): VerySimpleModel->save()<br />
#6 C:\inetpub\wwwroot\support\include\class.dynamic_forms.php(1378): DynamicFormEntryAnswer->save()<br />
#7 C:\inetpub\wwwroot\support\include\class.dynamic_forms.php(1317): DynamicFormEntry->saveAnswers()<br />
#8 C:\inetpub\wwwroot\support\include\class.user.php(348): DynamicFormEntry->save()<br />
#9 C:\inetpub\wwwroot\support\include\class.user.php(421): User->addForm()<br />
#10 C:\inetpub\wwwroot\support\include\class.user.php(249): User->addDynamicData()<br />
#11 C:\inetpub\wwwroot\support\include\class.ticket.php(3155): User::fromVars()<br />
#12 C:\inetpub\wwwroot\support\include\class.ticket.php(4417): Ticket->postMessage()<br />
#13 C:\inetpub\wwwroot\support\include\class.mailfetch.php(905): Ticket::create()<br />
#14 C:\inetpub\wwwroot\support\include\class.mailfetch.php(954): MailFetcher->createTicket()<br />
#15 C:\inetpub\wwwroot\support\include\class.mailfetch.php(1034): MailFetcher->fetchEmails()<br />
#16 C:\inetpub\wwwroot\support\include\class.cron.php(25): MailFetcher::run()<br />
#17 C:\inetpub\wwwroot\support\include\class.cron.php(110): Cron::MailFetcher()<br />
#18 C:\inetpub\wwwroot\support\include\api.cron.php(19): Cron::run()<br />
#19 C:\inetpub\wwwroot\support\include\api.cron.php(40): CronApiController->run()<br />
#20 C:\inetpub\wwwroot\support\api\cron.php(23): LocalCronApiController::call()<br />
#21 {main}

the other

[INSERT INTO ost_user__cdata SET phone='', user_id= 33 ON DUPLICATE KEY UPDATE phone='']

Unknown column 'phone' in 'field list'<br /> <br />
---- Backtrace ----<br />
#0 C:\inetpub\wwwroot\support\include\mysqli.php(201): osTicket->logDBError()<br />
#1 C:\inetpub\wwwroot\support\include\class.dynamic_forms.php(381): db_query()<br />
#2 C:\inetpub\wwwroot\support\include\class.dynamic_forms.php(396): DynamicForm::updateDynamicDataView()<br />
#3 C:\inetpub\wwwroot\support\include\class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer()<br />
#4 C:\inetpub\wwwroot\support\include\class.orm.php(680): Signal::send()<br />
#5 C:\inetpub\wwwroot\support\include\class.dynamic_forms.php(1536): VerySimpleModel->save()<br />
#6 C:\inetpub\wwwroot\support\include\class.dynamic_forms.php(1378): DynamicFormEntryAnswer->save()<br />
#7 C:\inetpub\wwwroot\support\include\class.dynamic_forms.php(1317): DynamicFormEntry->saveAnswers()<br />
#8 C:\inetpub\wwwroot\support\include\class.user.php(348): DynamicFormEntry->save()<br />
#9 C:\inetpub\wwwroot\support\include\class.user.php(421): User->addForm()<br />
#10 C:\inetpub\wwwroot\support\include\class.user.php(249): User->addDynamicData()<br />
#11 C:\inetpub\wwwroot\support\include\class.ticket.php(3155): User::fromVars()<br />
#12 C:\inetpub\wwwroot\support\include\class.ticket.php(4417): Ticket->postMessage()<br />
#13 C:\inetpub\wwwroot\support\include\class.mailfetch.php(905): Ticket::create()<br />
#14 C:\inetpub\wwwroot\support\include\class.mailfetch.php(954): MailFetcher->createTicket()<br />
#15 C:\inetpub\wwwroot\support\include\class.mailfetch.php(1034): MailFetcher->fetchEmails()<br />
#16 C:\inetpub\wwwroot\support\include\class.cron.php(25): MailFetcher::run()<br />
#17 C:\inetpub\wwwroot\support\include\class.cron.php(110): Cron::MailFetcher()<br />
#18 C:\inetpub\wwwroot\support\include\api.cron.php(19): Cron::run()<br />
#19 C:\inetpub\wwwroot\support\include\api.cron.php(40): CronApiController->run()<br />
#20 C:\inetpub\wwwroot\support\api\cron.php(23): LocalCronApiController::call()<br />
#21 {main}

http://hslosticket/support

Version Information
osTicket Version - v1.15.3.1
Web Server Software - Microsoft-IIS/10.0
MySQL Version - 5.5.65
PHP Version - 7.4.13

Any help would be appreciated

5 days later

Thanks for pointing me in the right direction ntozier. Drop table the running cron.php has sloved my issue as well.

8 months later

I checked all threads above, I know drop table "ost_user__data" maybe can resolve the issue, but a few days later the issue still exists.
I'd like to know that the reason or root cause? If we know the root cause maybe we can avoid the issue.

Thanks.

    smallfish

    Add a Phone Number field to your Contact Information Form, set the Variable for that field to phone, save changes, delete the User CDATA table, and let it regenerate/repopulate automatically.

    Cheers.

      Write a Reply...