DB Error #1054

swedron

Hi. We are getting database errors sometimes when customers try to create a ticket on frontend. Not all of them but some. Too many to ignore the problem. Use PHP 7.0 and getting this errors:
[SELECT A1.* FROM ost_thread_event A1 WHERE A1.thread_id = 1090 AND A1.state IN ('created', 'closed', 'reopened', 'edited', 'collab') ORDER BY A1.id ASC] Unknown column 'A1.state' in 'where clause'

---- Backtrace ----
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1054', '[SELECT A1.* FR...')
#1 (root)/include/class.orm.php(3455): db_query('SELECT A1.* FRO...', true, true)
#2 (root)/include/class.orm.php(3502): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(1991): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(2035): ModelInstanceManager->{closure}()
#5 (root)/include/class.orm.php(2014): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(2023): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1695): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1705): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1721): CachedResultSet->asArray()
#10 [internal function]: CachedResultSet->getIterator()
#11 (root)/include/client/templates/thread-entries.tmpl.php(5): IteratorIterator->__construct(Object(ModelResultSet))
#12 (root)/include/class.thread.php(397): include('/home/swedrons/...')
#13 (root)/include/client/view.inc.php(147): Thread->render(Array, Array)
#14 (root)/tickets.php(142): include('/home/swedrons/...')
#15 {main}

Any suggestion what this can be? Very greatful for any input. Thank you!

ntozier

The error says: Unknown column 'A1.state' in 'where clause'
This would be correct as there is no 'state' column in ost_thread_entry.
I'm not sure why you would see something like this, but those states are not real states either.
Do you perhaps have a ticket filter that runs on new tickets from user that is trying to do something that it ought not do?

KevinTheJedi

@swedron

What version of osTicket are you running? It shouldn't be trying to use the states column as that was discontinued in the 1.11.x series. Maybe you have some ORM/Database caching issues? You should try restarting the webserver, PHP-FPM (if you're running it), and the database to see if that resolves the issue. Sometimes ORM caches old table structures and if you upgraded it would throw a similar error to yours as it's referencing old columns that no longer exists.

Cheers.