Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

From field not populating in new 1.8.1.2 install from 1.7.3

I just had a successful upgrade to 1.8.1.2 but running into a few issues. First off are the DB errors as seen below:
imageimage
Secondly, on previous tickets that are still open, the from field is not populating. New tickets do show who the ticket was submitted by.
image
And finally, on the tickets that were added in version 1.7.3 - the ones listed above where the from field is not being populated - when clicked on, it does not show any details about the ticket. New tickets, however, do display all details entered as a ticket.

Comments

  • Screen shots of DB errors are not useful, we need to know what the actual error is.
    Is it possible that your users were merged into the new format and didnt have names?
  • I'm new to osTicket so how would I be able to check if the users merged into the new format and didn't have name? I have access to phpMyAdmin but not sure where to look.
  • Here are the errors created at install, It looks like some tables were not created, any idea or suggestion o how to fix it?

    [SELECT `ost_form_entry`.* FROM `ost_form_entry` WHERE `ost_form_entry`.`object_type` = ? ORDER BY `ost_form_entry`.`sort` ASC LIMIT 1] Table 'osticket.ost_form_entry' doesn't exist<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(285): osTicket-&gt;logDBError('DB Error #1146', '[SELECT `ost_fo...')<br /> #1 (root)/include/class.orm.php(873): db_prepare('SELECT `ost_for...')<br /> #2 (root)/include/class.orm.php(933): MysqlExecutor-&gt;_prepare()<br /> #3 (root)/include/class.orm.php(373): MysqlExecutor-&gt;getArray()<br /> #4 (root)/include/class.orm.php(413): ModelInstanceIterator-&gt;fillTo(0)<br /> #5 (root)/include/class.orm.php(322): ModelInstanceIterator-&gt;offsetGet(0)<br /> #6 (root)/include/class.orm.php(136): QuerySet-&gt;offsetGet(0)<br /> #7 (root)/include/class.company.php(27): VerySimpleModel::lookup(Array)<br /> #8 (root)/include/class.company.php(64): Company-&gt;getForm()<br /> #9 (root)/include/client/footer.inc.php(4): Company-&gt;__toString()<br /> #10 (root)/offline.php(34): require('(root)/includ...')<br /> #11 (root)/client.inc.php(34): include('(root)/offlin...')<br /> #12 (root)/index.php(16): require('(root)/client...')<br /> #13 {main}


    [SELECT id, f.type, size, name, `key`, signature, ft, bk, f.created, count(DISTINCT a.object_id) as canned, count(DISTINCT t.ticket_id) as tickets FROM ost_file f LEFT JOIN ost_attachment a ON(a.file_id=f.id) LEFT JOIN ost_ticket_attachment t ON(t.file_id=f.id) WHERE f.id=2 GROUP BY f.id] Table 'osticket.ost_attachment' doesn't exist<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(163): osTicket-&gt;logDBError('DB Error #1146', '[SELECT id, f.t...')<br /> #1 (root)/include/class.file.php(39): db_query('SELECT id, f.ty...')<br /> #2 (root)/include/class.file.php(24): AttachmentFile-&gt;load('2')<br /> #3 (root)/include/class.file.php(488): AttachmentFile-&gt;AttachmentFile('2')<br /> #4 (root)/include/class.config.php(942): AttachmentFile-&gt;lookup('2')<br /> #5 (root)/include/class.config.php(945): OsticketConfig-&gt;getLogo('client')<br /> #6 (root)/logo.php(26): OsticketConfig-&gt;getClientLogo()<br /> #7 {main}




  • [SELECT `ost_form_entry`.* FROM `ost_form_entry` WHERE `ost_form_entry`.`object_type` = ? ORDER BY `ost_form_entry`.`sort` ASC LIMIT 1] Table 'osticket.ost_form_entry' doesn't exist<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(285): osTicket-&gt;logDBError('DB Error #1146', '[SELECT `ost_fo...')<br /> #1 (root)/include/class.orm.php(873): db_prepare('SELECT `ost_for...')<br /> #2 (root)/include/class.orm.php(933): MysqlExecutor-&gt;_prepare()<br /> #3 (root)/include/class.orm.php(373): MysqlExecutor-&gt;getArray()<br /> #4 (root)/include/class.orm.php(413): ModelInstanceIterator-&gt;fillTo(0)<br /> #5 (root)/include/class.orm.php(322): ModelInstanceIterator-&gt;offsetGet(0)<br /> #6 (root)/include/class.orm.php(136): QuerySet-&gt;offsetGet(0)<br /> #7 (root)/include/class.company.php(27): VerySimpleModel::lookup(Array)<br /> #8 (root)/include/class.company.php(64): Company-&gt;getForm()<br /> #9 (root)/include/staff/footer.inc.php(3): Company-&gt;__toString()<br /> #10 (root)/scp/upgrade.php(88): require('(root)/includ...')<br /> #11 (root)/scp/staff.inc.php(118): require('(root)/scp/up...')<br /> #12 (root)/scp/admin.inc.php(16): require('(root)/scp/st...')<br /> #13 (root)/scp/upgrade.php(16): require_once('(root)/scp/ad...')<br /> #14 (root)/scp/staff.inc.php(118): require('(root)/scp/up...')<br /> #15 (root)/scp/tickets.php(17): require('(root)/scp/st...')<br /> #16 (root)/scp/index.php(17): require('(root)/scp/ti...')<br /> #17 {main}


    [SELECT `ost_form_entry`.* FROM `ost_form_entry` WHERE `ost_form_entry`.`object_type` = ? ORDER BY `ost_form_entry`.`sort` ASC LIMIT 1] Table 'osticket.ost_form_entry' doesn't exist<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(285): osTicket-&gt;logDBError('DB Error #1146', '[SELECT `ost_fo...')<br /> #1 (root)/include/class.orm.php(873): db_prepare('SELECT `ost_for...')<br /> #2 (root)/include/class.orm.php(933): MysqlExecutor-&gt;_prepare()<br /> #3 (root)/include/class.orm.php(373): MysqlExecutor-&gt;getArray()<br /> #4 (root)/include/class.orm.php(413): ModelInstanceIterator-&gt;fillTo(0)<br /> #5 (root)/include/class.orm.php(322): ModelInstanceIterator-&gt;offsetGet(0)<br /> #6 (root)/include/class.orm.php(136): QuerySet-&gt;offsetGet(0)<br /> #7 (root)/include/class.company.php(27): VerySimpleModel::lookup(Array)<br /> #8 (root)/include/class.company.php(64): Company-&gt;getForm()<br /> #9 (root)/include/staff/footer.inc.php(3): Company-&gt;__toString()<br /> #10 (root)/scp/upgrade.php(88): require('(root)/includ...')<br /> #11 (root)/scp/staff.inc.php(118): require('(root)/scp/up...')<br /> #12 (root)/scp/admin.inc.php(16): require('(root)/scp/st...')<br /> #13 (root)/scp/upgrade.php(16): require_once('(root)/scp/ad...')<br /> #14 (root)/scp/staff.inc.php(118): require('(root)/scp/up...')<br /> #15 (root)/scp/autocron.php(18): require('(root)/scp/st...')<br /> #16 {main}


    [SELECT `ost_form_entry`.* FROM `ost_form_entry` WHERE `ost_form_entry`.`object_type` = ? ORDER BY `ost_form_entry`.`sort` ASC LIMIT 1] Table 'osticket.ost_form_entry' doesn't exist<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(285): osTicket-&gt;logDBError('DB Error #1146', '[SELECT `ost_fo...')<br /> #1 (root)/include/class.orm.php(873): db_prepare('SELECT `ost_for...')<br /> #2 (root)/include/class.orm.php(933): MysqlExecutor-&gt;_prepare()<br /> #3 (root)/include/class.orm.php(373): MysqlExecutor-&gt;getArray()<br /> #4 (root)/include/class.orm.php(413): ModelInstanceIterator-&gt;fillTo(0)<br /> #5 (root)/include/class.orm.php(322): ModelInstanceIterator-&gt;offsetGet(0)<br /> #6 (root)/include/class.orm.php(136): QuerySet-&gt;offsetGet(0)<br /> #7 (root)/include/class.company.php(27): VerySimpleModel::lookup(Array)<br /> #8 (root)/include/class.company.php(64): Company-&gt;getForm()<br /> #9 (root)/include/staff/footer.inc.php(3): Company-&gt;__toString()<br /> #10 (root)/scp/upgrade.php(88): require('(root)/includ...')<br /> #11 {main}


    [SELECT `ost_form_entry`.* FROM `ost_form_entry` WHERE `ost_form_entry`.`object_type` = ? ORDER BY `ost_form_entry`.`sort` ASC LIMIT 1] Table 'osticket.ost_form_entry' doesn't exist<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(285): osTicket-&gt;logDBError('DB Error #1146', '[SELECT `ost_fo...')<br /> #1 (root)/include/class.orm.php(873): db_prepare('SELECT `ost_for...')<br /> #2 (root)/include/class.orm.php(933): MysqlExecutor-&gt;_prepare()<br /> #3 (root)/include/class.orm.php(373): MysqlExecutor-&gt;getArray()<br /> #4 (root)/include/class.orm.php(413): ModelInstanceIterator-&gt;fillTo(0)<br /> #5 (root)/include/class.orm.php(322): ModelInstanceIterator-&gt;offsetGet(0)<br /> #6 (root)/include/class.orm.php(136): QuerySet-&gt;offsetGet(0)<br /> #7 (root)/include/class.company.php(27): VerySimpleModel::lookup(Array)<br /> #8 (root)/include/class.company.php(64): Company-&gt;getForm()<br /> #9 (root)/include/staff/footer.inc.php(3): Company-&gt;__toString()<br /> #10 (root)/scp/upgrade.php(88): require('(root)/includ...')<br /> #11 (root)/scp/staff.inc.php(118): require('(root)/scp/up...')<br /> #12 (root)/scp/admin.inc.php(16): require('(root)/scp/st...')<br /> #13 (root)/scp/upgrade.php(16): require_once('(root)/scp/ad...')<br /> #14 (root)/scp/staff.inc.php(118): require('(root)/scp/up...')<br /> #15 (root)/scp/autocron.php(18): require('(root)/scp/st...')<br /> #16 {main}
Sign In or Register to comment.