Hello,Today I made the upgrade from 1.9.16 to 1.10.1, there were some errors in the system logs: DB Error #1146 Table 'osticketdb.ost_translation' doesn't exist

DB Error #1054

Unknown column 'extra' in 'field list'

 

Also I can't change the admin language.

The language packets are showing this way:

Installed Language Packs

Català (Catalan; Valencian) —   

ca — include/i18n/ca.phar 

Version: 148432, for version v1.10 

Built: Fri, 13 Jan 17 17 +0000

English - US (English) — ca_ES

en_US — include/i18n/en_US

español, castellano - ES (Spanish; Castilian) — ca_ES   

es_ES — include/i18n/es_ES.phar 

Version: 148432, for version v1.10 

Built: Fri, 13 Jan 17 17 +0000

PHP versión 5.5.9

MySQL versión 5.47

OS: Ubuntu 14

It looks like something went wrong.You should have an extra column in the ost_staff table, and you should have ost_translation table in your database.  You will want to look at the setup files to fix this.  extra is just a text field so it should be easy enough to construct a mysql query to add it. Here is the SQL code to add the ost_translation table, just replace %TABLE_PREFIX% with your table prefix.CREATE TABLE `%TABLE_PREFIX%translation` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`object_hash` char(16) CHARACTER SET ascii DEFAULT NULL,

`type` enum('phrase','article','override') DEFAULT NULL,

`flags` int(10) unsigned NOT NULL DEFAULT '0',

`revision` int(11) unsigned DEFAULT NULL,

`agent_id` int(10) unsigned NOT NULL DEFAULT '0',

`lang` varchar(16) NOT NULL DEFAULT '',

`text` mediumtext NOT NULL,

`source_text` text,

`updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),

KEY `type` (`type`,`lang`),

KEY `object_hash` (`object_hash`)

) DEFAULT CHARSET=utf8;

Hey,Thank you for your fast answer!The table was already created: | ost_translation | CREATE TABLE `ost_translation` (  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,  `object_hash` char(16) CHARACTER SET ascii DEFAULT NULL,  `type` enum('phrase','article','override') DEFAULT NULL,  `flags` int(10) unsigned NOT NULL DEFAULT '0',  `revision` int(11) unsigned DEFAULT NULL,  `agent_id` int(10) unsigned NOT NULL DEFAULT '0',  `lang` varchar(16) NOT NULL DEFAULT '',  `text` mediumtext NOT NULL,  `source_text` text,  `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,  PRIMARY KEY (`id`),  KEY `type` (`type`,`lang`),  KEY `object_hash` (`object_hash`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 |But it's empty, it's normal?

Sorry my answer was too long,Also the column in the ost_staff is created: +------------------------+-------------------------------------------+------+-----+---------+----------------+| Field                  | Type                                      | Null | Key | Default | Extra          |+------------------------+-------------------------------------------+------+-----+---------+----------------+| staff_id               | int(11) unsigned                          | NO   | PRI | NULL    | auto_increment || dept_id                | int(10) unsigned                          | NO   | MUL | 0       |                || role_id                | int(10) unsigned                          | NO   |     | 0       |                |................................................................................................| extra                  | text                                      | YES  |     | NULL    |                || permissions            | text                                      | YES  |     | NULL    |                || created                | datetime                                  | NO   |     | NULL    |                || lastlogin              | datetime                                  | YES  |     | NULL    |                || passwdreset            | datetime                                  | YES  |     | NULL    |                || updated                | datetime                                  | NO   |     | NULL    |                |+------------------------+-------------------------------------------+------+-----+---------+----------------+And for example in the admin column has this value: {"browser_lang":"ca"}   

Write a Reply...