When adding new Organizations we are getting:
DB Error #1054
[INSERT INTO ost_organization__cdata SET notes='See Notes for correct contact numbers', org_id= 8 ON DUPLICATE KEY UPDATE notes='See Notes for correct contact numbers'] Unknown column 'notes' in 'field list'
---- Backtrace ----
#0 C:\inetpub\wwwroot\osTicket\include\mysqli.php(201): osTicket->logDBError()
#1 C:\inetpub\wwwroot\osTicket\include\class.dynamic_forms.php(381): db_query()
#2 C:\inetpub\wwwroot\osTicket\include\class.dynamic_forms.php(398): DynamicForm::updateDynamicDataView()
#3 C:\inetpub\wwwroot\osTicket\include\class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer()
#4 C:\inetpub\wwwroot\osTicket\include\class.orm.php(680): Signal::send()
#5 C:\inetpub\wwwroot\osTicket\include\class.dynamic_forms.php(1536): VerySimpleModel->save()
#6 C:\inetpub\wwwroot\osTicket\include\class.dynamic_forms.php(1378): DynamicFormEntryAnswer->save()
#7 C:\inetpub\wwwroot\osTicket\include\class.dynamic_forms.php(1317): DynamicFormEntry->saveAnswers()
#8 C:\inetpub\wwwroot\osTicket\include\class.organization.php(284): DynamicFormEntry->save()
#9 C:\inetpub\wwwroot\osTicket\include\class.organization.php(187): Organization->addForm()
#10 C:\inetpub\wwwroot\osTicket\include\class.organization.php(586): Organization->addDynamicData()
#11 C:\inetpub\wwwroot\osTicket\include\class.organization.php(613): Organization::fromVars()
#12 C:\inetpub\wwwroot\osTicket\include\ajax.orgs.php(236): Organization::fromForm()
#13 C:\inetpub\wwwroot\osTicket\include\class.dispatcher.php(145): OrgsAjaxAPI->addOrg()
#14 C:\inetpub\wwwroot\osTicket\include\class.dispatcher.php(38): UrlMatcher->dispatch()
#15 C:\inetpub\wwwroot\osTicket\include\class.dispatcher.php(120): Dispatcher->resolve()
#16 C:\inetpub\wwwroot\osTicket\include\class.dispatcher.php(38): UrlMatcher->dispatch()
#17 C:\inetpub\wwwroot\osTicket\scp\ajax.php(316): Dispatcher->resolve()
#18 {main}
Log Date: Tuesday, September 28, 2021 at 11:22 AM IP Address: 10.1.66.252
The Same errors come up for these three headers as well…
[INSERT INTO ost_organization__cdata SET website='business.comcast.com', org_id= 8 ON DUPLICATE KEY UPDATE website='business.comcast.com'] Unknown column 'website' in 'field list'
[INSERT INTO ost_organization__cdata SET phone=8003913000, org_id= 8 ON DUPLICATE KEY UPDATE phone=8003913000] Unknown column 'phone' in 'field list'
[INSERT INTO ost_organization__cdata SET address='', org_id= 8 ON DUPLICATE KEY UPDATE address=''] Unknown column 'address' in 'field list'
In case the screenshots don't upload, we are on 1.15.3.1 (65ca4e6); MySQL 5.5.45; PHP 7.4.23
The only PHP error we get is: [28-Sep-2021 16:18:51 UTC] PHP Warning: PHP Startup: Invalid library (appears to be a Zend Extension, try loading using zend_extension=php_opcache.dll from php.ini) in Unknown on line 0
The data is actually in the table, we are just getting the errors. It's the same four errors each time, for field_id 28, 29, 30, and 31. This is a new install. I have re-installed the database and compared it to the actual db trying to find what we did wrong. I don't see anything in the tables when comparing initial and current databases.
