@KevinTheJedi I can now confirm that the code may have some bug worthy of investigation
Server Information
osTicket Version v1.16.6 (30ef1cc) — Up to date
Web Server Software Apache/2.4.53 (Rocky Linux) OpenSSL/3.0.1
MySQL Version 10.5.16
PHP Version 8.1.17
Setup
OST Code Installation:
http://10.10.10.10/OST-JOBS/
http://10.10.10.10/OST-FM/
OST Database Installation:
10.10.10.10 -- ostjobs
.ostfm_*
20.20.20.20 -- ostfm
.ost_*
ISSUES:
- After setting up "ostfm", whenever I login to /OST-FM/, the logged in users of /OST-JOBS/ get logged out. The same happens vice-versa also.
2.I'm getting database conflicting errors like the ones below:
[SELECT A1.* FROM `ost_form` A1 WHERE A1.`id` = 2 ORDER BY A1.`title` ASC]
Table 'ostjobs.ost_form' doesn't exist<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(207): osTicket->logDBError()<br />
#1 (root)/include/class.orm.php(3482): db_query()<br />
#2 (root)/include/class.orm.php(3529): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2010): MySqlExecutor->getArray()<br />
#4 (root)/include/class.orm.php(2054): ModelInstanceManager->{closure}()<br />
#5 (root)/include/class.orm.php(2033): CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(2042): CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1713): CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1723): CachedResultSet->fillTo()<br />
#9 (root)/include/class.orm.php(1337): CachedResultSet->asArray()<br />
#10 (root)/include/class.orm.php(1360): QuerySet->all()<br />
#11 (root)/include/class.orm.php(606): QuerySet->one()<br />
#12 (root)/include/class.orm.php(381): VerySimpleModel::lookup()<br />
#13 (root)/include/class.orm.php(417): VerySimpleModel->get()<br />
#14 (root)/include/class.dynamic_forms.php(1067): VerySimpleModel->__get()<br />
#15 (root)/include/class.dynamic_forms.php(1393): DynamicFormEntry->getDynamicFields()<br />
#16 (root)/include/class.dynamic_forms.php(166): DynamicFormEntry::create()<br />
#17 (root)/include/class.dynamic_forms.php(297): DynamicForm->instanciate()<br />
#18 (root)/include/class.dynamic_forms.php(532): DynamicForm::getNewInstance()<br />
#19 (root)/include/class.ticket.php(2394): TicketForm::getInstance()<br />
#20 (root)/include/class.queue.php(353): Ticket::getSearchableFields()<br />
#21 (root)/include/class.queue.php(319): CustomQueue::getSearchableFields()<br />
#22 (root)/include/class.queue.php(967): CustomQueue->getSupportedMatches()<br />
#23 (root)/include/class.queue.php(901): CustomQueue->mangleQuerySet()<br />
#24 (root)/include/class.queue.php(914): CustomQueue->getBasicQuery()<br />
#25 (root)/scp/tickets.php(557): CustomQueue->getQuery()<br />
#26 (root)/scp/index.php(17): require('...')<br />
#27 {main}
OR
[SELECT A1.* FROM `ostjobs_form` A1 WHERE A1.`id` = 2 ORDER BY A1.`title` ASC]
Table 'ostfm.ostjobs_form' doesn't exist<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(207): osTicket->logDBError()<br />
#1 (root)/include/class.orm.php(3482): db_query()<br />
#2 (root)/include/class.orm.php(3529): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2010): MySqlExecutor->getArray()<br />
#4 (root)/include/class.orm.php(2054): ModelInstanceManager->{closure}()<br />
#5 (root)/include/class.orm.php(2033): CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(2042): CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1713): CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1723): CachedResultSet->fillTo()<br />
#9 (root)/include/class.orm.php(1337): CachedResultSet->asArray()<br />
#10 (root)/include/class.orm.php(1360): QuerySet->all()<br />
#11 (root)/include/class.orm.php(606): QuerySet->one()<br />
#12 (root)/include/class.orm.php(381): VerySimpleModel::lookup()<br />
#13 (root)/include/class.orm.php(417): VerySimpleModel->get()<br />
#14 (root)/include/class.dynamic_forms.php(1067): VerySimpleModel->__get()<br />
#15 (root)/include/class.dynamic_forms.php(1393): DynamicFormEntry->getDynamicFields()<br />
#16 (root)/include/class.dynamic_forms.php(166): DynamicFormEntry::create()<br />
#17 (root)/include/class.dynamic_forms.php(297): DynamicForm->instanciate()<br />
#18 (root)/include/class.dynamic_forms.php(532): DynamicForm::getNewInstance()<br />
#19 (root)/include/class.ticket.php(2394): TicketForm::getInstance()<br />
#20 (root)/include/class.queue.php(353): Ticket::getSearchableFields()<br />
#21 (root)/include/class.queue.php(319): CustomQueue::getSearchableFields()<br />
#22 (root)/include/class.queue.php(967): CustomQueue->getSupportedMatches()<br />
#23 (root)/include/class.queue.php(901): CustomQueue->mangleQuerySet()<br />
#24 (root)/include/class.queue.php(914): CustomQueue->getBasicQuery()<br />
#25 (root)/scp/tickets.php(557): CustomQueue->getQuery()<br />
#26 (root)/scp/index.php(17): require('...')<br />
#27 {main}
Let me know if there is any additional information I can share to help debug the issue.
I'll be happy to share server access if there is something you'd like to investigate yourself.
Please help.