{"id":32,"date":"2020-05-26T13:50:00","date_gmt":"2020-05-26T13:50:00","guid":{"rendered":"https:\/\/www.mainmind.com\/blog\/?p=32"},"modified":"2020-07-26T17:59:05","modified_gmt":"2020-07-26T17:59:05","slug":"actualizacion-de-osticket-con-errores","status":"publish","type":"post","link":"https:\/\/www.mainmind.com\/blog\/actualizacion-de-osticket-con-errores\/","title":{"rendered":"Actualizaci\u00f3n de osTicket con errores"},"content":{"rendered":"<p>Desde versiones previas 1.10.X a <a href=\"https:\/\/github.com\/osTicket\/osTicket\/releases\/\" target=\"_blank\" rel=\"noopener noreferrer\">1.12.X o posteriores<\/a> aparecen errores con tablas ya creadas (seguramente de actualizaciones fallidas previas) en las que se muestra el error en el registro de la aplicaci&oacute;n:<\/p>\n<pre class=\"brush:plain;auto-links:false;toolbar:false\" contenteditable=\"false\">* @signature 86707325fc571e56242fccc46fd24466 \n* @version v1.11.0 \n* @title Add ticket referral * \n* This patch adds a table for thread referral as well as thread event states of referred and deleted \n*\/ CREATE TABLE `cli_thread_referral` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT,  `thread_id` int(11) unsigned NOT NULL,  `object_id` int(11) unsigned NOT NULL,  `object_type` char(1) NOT NULL,  `created` datetime NOT NULL,  PRIMARY KEY (`id`),  UNIQUE KEY `ref` (`object_id`, `object_type`, `thread_id`),  KEY `thread_id` (`thread_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 \n\nTable 'XXX_thread_referral' already exists\n<\/pre>\n<p>Deberemos volver a recuperar los archivos y la base de datos de nuestra copia de seguridad, adem&aacute;s de eliminar la tabla indicada, deberemos suprimir dos m&aacute;s, donde \u00abXXX\u00bb es el prefijo de las tablas de nuestra instalaci&oacute;n:<\/p>\n<pre class=\"brush:sql;auto-links:false;toolbar:false\" contenteditable=\"false\">DROP TABLE XXX_thread_referral;\nDROP TABLE XXX_queue_export;\nDROP TABLE XXX_event;<\/pre>\n<p>Es recomendable eliminar posibles idiomas adicionales y dejar como predeterminado el ingl&eacute;s nativo. En el caso de instalaciones antiguas, la versi&oacute;n de PHP m&iacute;nima es la 5.6.40 tras la actualizaci&oacute;n podemos cambiar a 7.1.33 o posterior.<\/p>\n<p>Si nos encontramos con errores durante la actualizaci&oacute;n pero sin dejar rastro en el log de PHP y de la BBDD de la aplicaci&oacute;n, las reglas del firewall de aplicaciones Modsecurity bloquean el proceso de actualizaci&oacute;n, deberemos permitir temporalmente, utilizar Atomic Standard en lugar de OWASP o <a href=\"https:\/\/docs.plesk.com\/es-ES\/obsidian\/administrator-guide\/73383\/\" target=\"_blank\" rel=\"noopener noreferrer\">a&ntilde;adir excepciones para la ruta del panel de gesti&oacute;n<\/a> (SCP).<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"\/blog\/wp-content\/uploads\/\/2020\/os_ticket_upgraded.JPG\" alt=\"\" \/><\/p>\n<p><strong>NOTA<\/strong>: Es posible revisar los detalles de las reglas aplicadas en el registro de Plesk\/cPanel via web o en los directorios de registro, por ejemplo: %Plesk_dir%\\ModSecurity\\vhosts\\GUIDXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX\\logs ser&iacute;a necesario deshabilitar la regla&nbsp;920480<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"brush:plain;auto-links:false;toolbar:false\" contenteditable=\"false\">Message: Access denied with code 403 (phase 1). Match of \"rx ^%{tx.allowed_request_content_type_charset}$\" against \"TX:1\" required. [file \"\/Plesk\/ModSecurity\/rules\/modsecurity_crs-plesk\/rules\/REQUEST-920-PROTOCOL-ENFORCEMENT.conf\"] [line \"944\"] [id \"920480\"] [msg \"Request content type charset is not allowed by policy\"] [data \"utf-8\"] [severity \"CRITICAL\"] [ver \"OWASP_CRS\/3.2.0\"] [tag \"application-multi\"] [tag \"language-multi\"] [tag \"platform-multi\"] [tag \"attack-protocol\"] [tag \"OWASP_CRS\"] [tag \"OWASP_CRS\/PROTOCOL_VIOLATION\/CONTENT_TYPE_CHARSET\"] [tag \"WASCTC\/WASC-20\"] [tag \"OWASP_TOP_10\/A1\"] [tag \"OWASP_AppSensor\/EE2\"] [tag \"PCI\/12.1\"]\nAction: Intercepted (phase 1)\nApache-Handler: IIS\nStopwatch: 1590421305747749 0 (- - -)\nStopwatch2: 1590421305747749 0; combined=0, p1=0, p2=0, p3=0, p4=0, p5=0, sr=0, sw=0, l=0, gc=0\nProducer: ModSecurity for IIS (STABLE)\/2.9.2 (http:\/\/www.modsecurity.org\/); OWASP_CRS\/3.2.0.\nServer: ModSecurity Standalone\nEngine-Mode: \"ENABLED\"<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Desde versiones previas 1.10.X a 1.12.X o posteriores aparecen errores con tablas ya creadas (seguramente de actualizaciones fallidas previas) en las que se muestra el error en el registro de la aplicaci&oacute;n: * @signature 86707325fc571e56242fccc46fd24466 * @version v1.11.0 * @title Add ticket referral * * This patch adds a table for thread referral as well [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[74,72,71,75,73],"class_list":["post-32","post","type-post","status-publish","format-standard","hentry","category-software","tag-actualizacion","tag-error","tag-osticket","tag-php","tag-update"],"_links":{"self":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/32","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/comments?post=32"}],"version-history":[{"count":0,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/32\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/media?parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/categories?post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/tags?post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}