{"id":1371,"date":"2023-01-09T00:03:17","date_gmt":"2023-01-08T23:03:17","guid":{"rendered":"https:\/\/alessandromasciadri.com\/?p=1371"},"modified":"2023-01-17T22:47:51","modified_gmt":"2023-01-17T21:47:51","slug":"come-aggiornare-il-modulo-sound-languages-di-freepbx","status":"publish","type":"post","link":"https:\/\/alessandromasciadri.com\/come-aggiornare-il-modulo-sound-languages-di-freepbx\/","title":{"rendered":"Come aggiornare il modulo Sound Languages di FreePBX"},"content":{"rendered":"\t\t<div data-akihiro-type=\"ama-post\" data-akihiro-id=\"1371\" class=\"akihiro akihiro-1371\" data-akihiro-post-type=\"post\">\n\t\t\t\t<div class=\"akihiro-element akihiro-element-447b845 e-flex e-con-boxed e-con e-parent\" data-id=\"447b845\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"akihiro-element akihiro-element-d11160d akihiro-widget akihiro-widget-text-editor\" data-id=\"d11160d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In <a href=\"https:\/\/alessandromasciadri.com\/come-risolvere-lerrore-sqlstate22001-in-freepbx\/\">questo articolo<\/a> illustravo come risolvere il problema che si verifica durante l&#8217;installazione dei messaggi in lingua italiana di FreePBX. Agendo sulla tabella soundlang_prompts modificando la lunghezza della colonna filename, come \u00a0da me illustrato nel suddetto articolo, in fase di aggiornamento del plugin ci si imbatte per\u00f2 nel seguente errore:<\/p><blockquote><p>In DBALException.php line 131:<br \/><br \/>An exception occurred while executing &#8216;ALTER TABLE soundlang_prompts CHANGE filename filename VARCHAR(80) DEFAULT NU <br \/>LL&#8217;: <br \/><br \/>SQLSTATE[01000]: Warning: 1265 Data truncated for column &#8216;filename&#8217; at row 3960<\/p><\/blockquote><p>Per poter quindi aggiornare correttamente il plugin possiamo seguire la seguente guida.\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-1819915 akihiro-widget akihiro-widget-heading\" data-id=\"1819915\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Truncate della tabella soundlang_prompts<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-9a7cb5a akihiro-widget akihiro-widget-text-editor\" data-id=\"9a7cb5a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Il primo passo \u00e8 quello di fare pulizia del contenuto della tabella soundlang_prompts. Il comando da lanciare \u00e8 il seguente:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-ac6afac akihiro-widget akihiro-widget-code-highlight\" data-id=\"ac6afac\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql \">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>TRUNCATE soundlang_prompts;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-c73b272 akihiro-widget akihiro-widget-text-editor\" data-id=\"c73b272\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>So che il comando pu\u00f2 sembrare brutale da eseguire, ma non c&#8217;\u00e8 da preoccuparsi, la tabella la ripopoleremo con il suo contenuto appena terminato l&#8217;aggiornamento del modulo.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-295952b akihiro-widget akihiro-widget-heading\" data-id=\"295952b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Ripristino della lunghezza della colonna filename<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-a8919ea akihiro-widget akihiro-widget-text-editor\" data-id=\"a8919ea\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\tCon questo semplice comando ripristiniamo ora la lunghezza originale della colonna <code>filename<\/code>.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-649ad61 akihiro-widget akihiro-widget-code-highlight\" data-id=\"649ad61\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql \">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>ALTER TABLE soundlang_prompts MODIFY filename VARCHAR(80) DEFAULT NULL;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-e16e1bc akihiro-widget akihiro-widget-text-editor\" data-id=\"e16e1bc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Possiamo ora procedere all&#8217;aggiornamento del modulo Sound Languages.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-e5683ec akihiro-widget akihiro-widget-heading\" data-id=\"e5683ec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Aggiornamento del modulo Sound Languages<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-f92f8d4 akihiro-widget akihiro-widget-text-editor\" data-id=\"f92f8d4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Siamo quindi pronti per aggiornare il modulo Sound Languages. Lanciamo da console il seguente comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-912f5e4 akihiro-widget akihiro-widget-code-highlight\" data-id=\"912f5e4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo fwconsole ma upgradeall<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-70c1387 akihiro-widget akihiro-widget-text-editor\" data-id=\"70c1387\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\tAttendiamo il completamento degli aggiornamenti e passiamo poi al prossimo passaggio per ripristinare il contenuto della tabella soundlang_prompts.\n\nAlternativamente all&#8217;aggiornamento da shell possiamo procedere utilizzando l&#8217;interfaccia web di FreePBX accedendo alla sezione <code>Admin ---&gt; Module Admin<\/code>, selezionare il modulo Sound Languages e procedere all&#8217;aggiornamento.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-b4170a2 akihiro-widget akihiro-widget-heading\" data-id=\"b4170a2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Modifica della lunghezza della colonna filename<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-e92fabf akihiro-widget akihiro-widget-text-editor\" data-id=\"e92fabf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Essendo il bug nel language pack italiano ancora presente, per poter procedere alla sua corretta installazione \u00e8 necessario aumentare la lunghezza della colonna <code>filename<\/code>, come del resto si faceva menzione in <a href=\"https:\/\/alessandromasciadri.com\/come-risolvere-lerrore-sqlstate22001-in-freepbx\/\">questo articolo<\/a>. Lanciamo quindi il seguente comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-8d08f31 akihiro-widget akihiro-widget-code-highlight\" data-id=\"8d08f31\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql \">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>ALTER TABLE soundlang_prompts MODIFY filename VARCHAR(255) DEFAULT NULL;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-ba5225a akihiro-widget akihiro-widget-heading\" data-id=\"ba5225a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Ripristino del contenuto della tabella soundlang_prompts<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-b957269 akihiro-widget akihiro-widget-text-editor\" data-id=\"b957269\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Tramite l&#8217;interfaccia web di FreePBX andiamo nella sezione di gestione dei Language Packs: <code>Admin ---&gt; Sound Languages<\/code>.<\/p><p>Utilizzando l&#8217;icona rossa del cestino disinstalliamo tutti i language pack installati e procediamo successivamente all&#8217;installazione degli stessi.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>In questo articolo illustravo come risolvere il problema che si verifica durante l&#8217;installazione dei messaggi in lingua italiana di FreePBX. Agendo sulla tabella soundlang_prompts modificando la lunghezza della colonna filename, come \u00a0da me illustrato nel suddetto articolo, in fase di aggiornamento del plugin ci si imbatte per\u00f2 nel seguente errore: In DBALException.php line 131: An [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[37,39,38],"class_list":["post-1371","post","type-post","status-publish","format-standard","hentry","category-sistemistica","tag-asterisk","tag-freepbx","tag-voip"],"_links":{"self":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/1371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/comments?post=1371"}],"version-history":[{"count":4,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/1371\/revisions"}],"predecessor-version":[{"id":1375,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/1371\/revisions\/1375"}],"wp:attachment":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/media?parent=1371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/categories?post=1371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/tags?post=1371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}