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

ost_sequence table deleted accidentally after migrating from one server to another

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 1:40pm182.156.80.3
 DB Error #1146Error Mon, May 18 2015 1:40pm182.156.80.3
 DB Error #1146Error Thu, May 14 2015 4:33pm182.156.80.3
Tagged:

Comments

  • 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

    [SELECT `ost_sequence`.* FROM `ost_sequence` ORDER BY `ost_sequence`.`name` ASC] 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 you
  • Did 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.4

    DROP 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;


Sign In or Register to comment.