[Easy2Begin]

I got all the below errors

 

[INSERT INTO os_user__cdata SET phone=’0107600136′, user_id= 27 ON DUPLICATE KEY UPDATE phone=’0107600136′]

 

Unknown column ‘phone’ in ‘field list’

—- Backtrace —-

 

And this one?

================================================================================================

[SELECT A1.id, A1.name, A6.address FROM os_user A1 LEFT JOIN os_user_email A2 ON (A1.id = A2.user_id) LEFT JOIN os_organization A3 ON (A1.org_id = A3.id) LEFT JOIN os_user_account A4 ON (A1.id = A4.user_id) LEFT JOIN os_user__cdata A5 ON (A1.id = A5.user_id) LEFT JOIN os_user_email A6 ON (A1.default_email_id = A6.id) WHERE (A2.address LIKE ‘%rbosman@eas%’ OR A1.name LIKE ‘%rbosman@eas%’ OR A3.name LIKE ‘%rbosman@eas%’ OR A4.username LIKE ‘%rbosman@eas%’ OR A5.phone LIKE ‘%rbosman@eas%’) LIMIT 25]

 

Unknown column ‘A5.phone’ in ‘where clause’

—- Backtrace —-

#0 (root)/include/mysqli.php(201): osTicket->logDBError(‘DB Error #1054’, ‘[SELECT A1.id…’)

#1 (root)/include/class.orm.php(3466): db_query(‘SELECT A1.id,…’, true, true)

#2 (root)/include/class.orm.php(3522): MySqlExecutor->execute()

#3 (root)/include/class.orm.php(2070): MySqlExecutor->getRow()

#4 (root)/include/class.orm.php(2043): FlatArrayIterator->{closure}()

#5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next()

#6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind()

#7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid()

#8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)

#9 (root)/include/class.orm.php(1729): CachedResultSet->asArray()

#10 (root)/include/ajax.users.php(98): CachedResultSet->getIterator()

#11 (root)/include/class.dispatcher.php(145): UsersAjaxAPI->search(‘local’)

#12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch(‘/local’, Array)

#13 (root)/include/class.dispatcher.php(120): Dispatcher->resolve(‘/local’, Array)

#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch(‘/users/local’, NULL)

#15 (root)/scp/ajax.php(316): Dispatcher->resolve(‘/users/local’)

#16 {main}

 

 

#0 (root)/include/mysqli.php(201): osTicket->logDBError(‘DB Error #1054’, ‘[INSERT INTO `o…’)<br />

#1 (root)/include/class.dynamic_forms.php(381): db_query(‘INSERT INTO `os…’)

#2 (root)/include/class.dynamic_forms.php(396): DynamicForm::updateDynamicDataView(Object(DynamicFormEntryAnswer), NULL)

#3 (root)/include/class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer(Object(DynamicFormEntryAnswer), NULL)

#4 (root)/include/class.orm.php(680): Signal::send(‘model.created’, Object(DynamicFormEntryAnswer))

#5 (root)/include/class.dynamic_forms.php(1536): VerySimpleModel->save(false)

#6 (root)/include/class.dynamic_forms.php(1378): DynamicFormEntryAnswer->save(false)

#7 (root)/include/class.dynamic_forms.php(1317): DynamicFormEntry->saveAnswers(NULL, false)

#8 (root)/include/class.user.php(348): DynamicFormEntry->save()

#9 (root)/include/class.user.php(421): User->addForm(Object(UserForm), 1, Array)

#10 (root)/include/class.user.php(249): User->addDynamicData(Array)

#11 (root)/include/class.user.php(287): User::fromVars(Array, true)

#12 (root)/include/ajax.users.php(305): User::fromForm(Object(SimpleForm))

#13 (root)/include/class.dispatcher.php(145): UsersAjaxAPI->addUser()

#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch(‘/lookup/form’, Array)

#15 (root)/include/class.dispatcher.php(120): Dispatcher->resolve(‘/lookup/form’, Array)

#16 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch(‘/users/lookup/f…’, NULL)

#17 (root)/scp/ajax.php(316): Dispatcher->resolve(‘/users/lookup/f…’)

#18 {main}

[NIcholasjansen]

Are you also having issues with slow query processing times? 

 

Our MYSQL database all of a sudden after upgrading is going mental taking 1 – 2 min just to load each query. 

 

We are also having duplicate entry issues. Hopefully someone from Osticket Awesome will reply soon. 

[Easy2Begin]

No issues with duplicate records yet 🙂

But indeed hopefully they will respond 

regards

 

Rob