Hello,I'm testing osTicket on a VMWare virtual machine running an up-to-date Ubuntu 12.04.4. I just did a fresh install downloading the latest files from github. I did the installation phase and it apparently went smooth.Here are the versions of the various components:osTicket Version     v1.9.2-2-gb746735 (b746735)Server Software     Apache/2.2.22 (Ubuntu)PHP Version     5.3.10-1ubuntu3.12MySQL Version     5.5.37I can reach the osTicket web app on my virtual machine, I can login with my administrator user, and peruse the configuration and all the dashboards. These all seem to work fine. Sadly, I'm encountering problems in creating and displaying tickets.Right after the installation, if I try to display the first sample ticket "osTicket installed!" in the Staff Panel, I can't: the ticket list appears empty, though the top line shows "Open (1)".I can find no PHP errors in /var/log/apache2/error.log and no MySQL errors in its logs.Every time I try to display tickets in the Staff Panel, a new osTicket log appears, and they all look like this:DB Error #1054 Unknown column 'cdata.priority_id' in 'field list'---- Backtrace ----#0 (root)/include/mysqli.php(169): osTicket->logDBError('DB Error #1054', '[SELECT ticket....')#1 (root)/include/staff/tickets.inc.php(254): db_query('SELECT ticket.t...')#2 (root)/scp/tickets.php(633): require_once('/opt/var/www/ht...')#3 (root)/scp/index.php(17): require('/opt/var/www/ht...')#4 {main}Log Date: Tue, Jul 8 2014 8 IP Address: 127.0.0.1The message "Unknown column 'cdata.priority_id' in 'field list'" is correct: there's no column named priority_id in table ost_ticket__cdata.I also cannot create a new ticket. If I try to submit a new ticket, I get this error message in the web page: "Missing or invalid data - check the errors and try again". But there are no other error messages and the three mandatory fields (Topic, email and problem summary) are all filled. When this happens, I can find no error log at all anywhere. There are a few posts about this error in the forum, but they all appear to be related to all versions so they don't help me.Do you have any suggestions to troubleshoot these issues?Thanks, kind regards.-- M

Please download the files from http://osticket.com/download and install using them.  Please let us know if you encounter the same problems.  Thank you.

Hello,the "DB Error #1054" seems to have been solved using the package downloaded from the website.The problem with posting a new ticket seems to go away if in the setup I select the English language instead of the Italian one. Then, the new ticket webpage shows a few more fields, two of them mandatory.Thanks for your help. Kind regards.-- M

Italian.png

English.png

Language support is in phase 2 of 3, and is not ready for nor should it be used in production.

Write a Reply...