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

Upgrade from 1.7.2 (or 3) -> 1.8.0

edited December 2013 in osTicket 1.7
History: I recent;y up[graded to 1.7.3 but it never signed on as 1.7.3 (just showed 1.7.2) so I'm not sure which version to report on.

Problem: Upgrading from this version to 1.8.0

OST Log Shows:
Upgrader - 6de40a4d (task pending).
Upgrader - 6de40a4d applied
Upgrader - dad45ca2-61c9d5d7 cleanup
Upgrader - 61c9d5d7 (task pending).
Upgrader - 61c9d5d7 applied
Upgrader - dad45ca2 (task pending).
Upgrader - dad45ca2 applied
Upgrader - d51f303a applied
DB Error #1146

The DB error contents:
#0 (root)/include/mysqli.php(248): osTicket->logDBError('DB Error #1146', '[SELECT `FORM_E...')
#1 (root)/include/class.orm.php(861): db_prepare('SELECT `FORM_EN...')
#2 (root)/include/class.orm.php(921): MysqlExecutor->_prepare()
#3 (root)/include/class.orm.php(363): MysqlExecutor->getArray()
#4 (root)/include/class.orm.php(393): ModelInstanceIterator->fillTo(0)
#5 (root)/include/class.ticket.php(110): ModelInstanceIterator->valid()
#6 (root)/include/class.ticket.php(89): Ticket->loadDynamicData()
#7 (root)/include/class.ticket.php(57): Ticket->load('3104')
#8 (root)/include/class.ticket.php(1796): Ticket->Ticket('3104')
#9 (root)/scp/tickets.php(28): Ticket::lookup('3104')
#10 {main}

The failed query
[SELECT `FORM_ENTRY_TABLE`.* FROM `FORM_ENTRY_TABLE` WHERE `FORM_ENTRY_TABLE`.`object_id` = ? AND `FORM_ENTRY_TABLE`.`object_type` = ? ORDER BY `FORM_ENTRY_TABLE`.`sort` ASC]

Table 'osticket_a.FORM_ENTRY_TABLE' doesn't exist

but table form_entry does exist. I guess that the following errors derive from that.

The NewHtmlTemplate task reports there is work to do
The DynamicFormLoader task reports there is work to do
The CompanyFormLoader task reports there is work to do

How best to fix of this?

Comments

Sign In or Register to comment.