After accidentally getting deleted the ost_sequence table,there is continuous error log report as how below.Please help what to do. Showing 1 - 25 of 232 All logs Log TitleLog TypeLog DateIP Address DB Error #1146Error Mon, May 18 2015 1182.156.80.3 DB Error #1146Error Mon, May 18 2015 1182.156.80.3 DB Error #1146Error Thu, May 14 2015 4182.156.80.3
Restore from back up.You also haven't actually provided the body of the error that you are getting.Or the version of osTicket.Please help us to help you by reading and following the posting
guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.
DB Error #1146 Table 'new_ticket.ost_sequence' doesn't exist---- Backtrace ----#0 (root)/include/mysqli.php(312): osTicket->logDBError('DB Error #1146', '[SELECT `ost_se...')#1 (root)/include/class.orm.php(1027): db_prepare('SELECT `ost_seq...')#2 (root)/include/class.orm.php(1022): MysqlExecutor->execute()#3 (root)/include/class.orm.php(1090): MysqlExecutor->_prepare()#4 (root)/include/class.orm.php(458): MysqlExecutor->getArray()#5 (root)/include/class.orm.php(488): ModelInstanceIterator->fillTo(0)#6 (root)/include/staff/settings-tickets.inc.php(43): ModelInstanceIterator->valid()#7 (root)/scp/settings.php(57): include_once('/var/www/html/s...')#8 {main}
This is the detail error that we are getting.As we dont know the structure of the ost_sequence table we are not being able to insert it into the existing database.Can we just insert a blank ost_sequence table with the same structure as it is in the database as we have lost the table column values and we dont know which column value of the table ost_sequence is for what use in osticket.I hope you can guide us now . Will be waiting for your reply.Thank youDid you restore the table from your back up?
Yes i have an old backup of osticket in which there is a single row of value in ost_sequence table.But that is table from an old backup after that many tickets have been already generated after accidentally getting deleted the ost_sequence table.
The table was last modified in 1.9.4DROP TABLE IF EXISTS `%TABLE_PREFIX%sequence`;CREATE TABLE `%TABLE_PREFIX%sequence` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) DEFAULT NULL, `flags` int(10) unsigned DEFAULT NULL, `next` bigint(20) unsigned NOT NULL DEFAULT '1', `increment` int(11) DEFAULT '1', `padding` char(1) DEFAULT '0', `updated` datetime NOT NULL, PRIMARY KEY (`id`)-- InnoDB is intended here because transaction support is required for row-- locking) ENGINE=InnoDB DEFAULT CHARSET=utf8;
