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 errors

I upgraded today to 1.9.2 - no error on screen, but I got two emails:

1. email:  DB Error #1146
[ SELECT id FROM ost_content WHERE `type`='banner-staff']

Table 'supportelmit.ost_content' doesn't exist<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(169): osTicket->logDBError('DB Error #1146', '[ SELECT id FRO...')<br />
#1 (root)/include/class.page.php(218): db_query(' SELECT id FROM...')<br />
#2 (root)/scp/login.php(22): Page::getIdByType('banner-staff')<br />
#3 (root)/scp/staff.inc.php(55): require('/var/www/suppor...')<br />
#4 (root)/scp/staff.inc.php(71): staffLoginPage('Authentication ...')<br />
#5 (root)/scp/tickets.php(17): require('/var/www/suppor...')<br />
#6 (root)/scp/index.php(17): require('/var/www/suppor...')<br />
#7 {main}

2. email:  DB Error #1146
[ SELECT id FROM ost_content WHERE `type`='banner-staff'] Table 'supportelmit.ost_content' doesn't exist<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(169): osTicket->logDBError('DB Error #1146', '[ SELECT id FRO...')<br /> #1 (root)/include/class.page.php(218): db_query(' SELECT id FROM...')<br /> #2 (root)/scp/login.php(22): Page::getIdByType('banner-staff')<br /> #3 {main}

Further I created a ticket and it came with that message:

Ronald Wiplinger,
SYSTEM (Auto Assignment) has assigned ticket #969048 to you!
%{message}
To view complete details, simply login to the support system.
- Your friendly Support Ticket System - powered by osTicket.


Comments

  • The System Logs shows some more:

    Upgrader - 4323a6a8 applied
    Patch f5692e24-4323a6a8 applied successfully (v1.9.0)

    Upgrader - 4323a6a8 (task pending).
    The TemplateContentLoader task reports there is work to do

    Upgrader - 9ef33a06 applied
    Patch 4323a6a8-9ef33a06 applied successfully (v1.9.0)

    Upgrader - 8f99b8bf applied
    Patch 9ef33a06-8f99b8bf applied successfully (v1.9.0)


    And why it says "v1.9.0" when I uploaded 1.9.2 ????

    How to fix it?
  • looking at my database, there IS a table ost_content and it has this structure:

    CREATE TABLE IF NOT EXISTS `ost_content` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `content_id` int(10) unsigned NOT NULL DEFAULT '0',
      `isactive` tinyint(1) unsigned NOT NULL DEFAULT '0',
      `type` varchar(32) NOT NULL DEFAULT 'other',
      `name` varchar(255) NOT NULL,
      `body` text NOT NULL,
      `lang` varchar(16) NOT NULL DEFAULT 'en_US',
      `notes` text,
      `created` datetime NOT NULL,
      `updated` datetime NOT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `name` (`name`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;


    What is going on???
  • BTW is it normal, that some tables are MyISAM and some InnoDB?
  • Never mind, ... I deleted all and installed it fresh. Now it works!
Sign In or Register to comment.