Running versionOsTicket 1.10.2 CentOS 6.latest PHP 7.0.27mySQL 5.1.73Since upgrading to the latest 1.10.2, if I try to search for a user - for example to Change Ticket Owner I get the following error. Table 'support.ost_user__cdata' doesn't exist<br /><br />---- Backtrace ----<br />#0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.`id`...')<br />#1 (root)/include/class.orm.php(3133): db_query('SELECT A1.`id`,...', true, true)<br />#2 (root)/include/class.orm.php(3189): MySqlExecutor->execute()<br />#3 (root)/include/class.orm.php(1842): MySqlExecutor->getRow()<br />#4 (root)/include/class.orm.php(1815): FlatArrayIterator->{closure}()<br />#5 (root)/include/class.orm.php(1794): CallbackSimpleIterator->next()<br />#6 (root)/include/class.orm.php(1803): CallbackSimpleIterator->rewind()<br />#7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()<br />#8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)<br />#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()<br />#10 (root)/include/ajax.users.php(94): CachedResultSet->getIterator()<br />#11 (root)/include/class.dispatcher.php(145): UsersAjaxAPI->search()<br />#12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('', Array)<br />#13 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('', Array)<br />#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/users', NULL)<br />#15 (root)/scp/ajax.php(262): Dispatcher->resolve('/users')<br />#16 {main}

Server InformationosTicket Version v1.10.2 (8c848b5) —  Up to dateWeb Server Software Apache/2.4.27 (Red Hat) OpenSSL/1.0.1e-fips PHP/7.0.27MySQL Version 5.1.73PHP Version 7.0.27PHP Extensionsgdlib Used for image manipulation and PDF printingimap Used for email fetchingxml XML APIxml-dom Used for HTML email processingjson Improves performance creating and processing JSONmbstring Highly recommended for non western european language contentphar Highly recommended for plugins and language packsintl Highly recommended for non western european language contentfileinfo Used to detect file types for uploadsPHP Settingsdate.timezone Europe/DublinDatabase Information and UsageSchema support (localhost)Schema Signature 98ad7d550c26ac44340350912296e673Space Used 99.70 MiBSpace for Attachments 69.93 MiBTimezone BST (Interpreted as Europe/London)Installed Language PacksEnglish (United States) —en_US — include/i18n/en_USAlso tried with PHP 5.6.?  and get the same error 

the table you are saying doesn't exist is a temporary table that is generate by the system.  OsTicket 1.10.2^this version has not been released yet.  So you are running a version before it was released and probably should be using 1.10.1.CentOS 6.latest ^ If you are running CentoOS then most of the problems that I have heard of are related to the use of SELinux.  HAve you tried disabling it and seeing if it helps?  It could be preventing some ajax cxalls to the back endsuch as clean up routines etc that spawn the generation of the temp table.

Thanks for your reply. 1.10.2 is in the GitHub as a release since March 22 ???? https://github.com/osTicket/osTicket/releasesIs that not valid? I do have Selinux disabled. Where should that table get built?  Perhaps I can add some debug code around it

Official releases are done at: http://osticket.com/downloadCorresponding announcements are also done on the forums.there has been no official release and no announcement yet, so it has not been released.  You are using what is essentially a pre-release candidate, which has some known issues.I'll ping a dev to see if he knows off the top of his head when/where/why that temp table is made.

@[deleted]

You should be able to recreate the User CDATA table by searching for any User in the User directory.

Cheers.

Thank you. That seems to have worked. Searches now complete, and show a list of users to select from. Looking at the database table, most of the records contain NULL - is that OK? mysql> select * from ost_user__cdata;+---------+-------+------+---------+----------------+------------------------+| user_id | email | name | company | phone          | notes                  |+---------+-------+------+---------+----------------+------------------------+|       1 | NULL  | NULL | NULL    | NULL           | NULL                   ||       2 | NULL  | NULL | NULL    | NULL           | NULL                   ||       3 | NULL  | NULL | NULL    | NULL           | NULL                   ||       4 | NULL  | NULL | NULL    | NULL           | NULL                   ||       5 | NULL  | NULL | NULL    | NULL           | NULL                   ||       6 | NULL  | NULL | NULL    | NULL           | NULL                   ||       7 | NULL  | NULL | NULL    | NULL           | NULL                   ||       8 | NULL  | NULL | NULL    | NULL           | NULL                   |Some real phone numbers in other records so I am not showing them here. On a separate note, I have compared all the upgrader scripts and there appear to be no differences between those for releases 1.10.1 and 1.10.2  - If I am correct in that, is it OK for me to simply swap out 1.10.2 and replace it with 1.10.1 as the database structure is the same for both releases. Thanks again for your help, and for a great application.  

@[deleted]> Looking at the database table, most of the records contain NULL - is that OK? `NULL` for `user_id`?> If I am correct in that, is it OK for me to simply swap out 1.10.2 and replace it with 1.10.1 as the database structure is the same for both releases.Yes, in fact, v1.10.2 is a security release that contains patches (code changes) for certain security vulnerabilities brought to our attention. Make sure you make a backup of the entire osTicket folder just in case something happens, you can easily revert back to the origianl and try again.I hope this helps! Cheers.

@[deleted],`NULL` for `user_id`?No. The user_id field is populated all the way down. But none of the records have  email/name and only a few records have other data populated. Now that the table has been created from searching the User Directory, it looks like everything is working well with 1.10.2.  Shouldn't the code to check for/and create the table if necessary also be added to the "Change Owner" logic also.Thanks for your help

Write a Reply...