Global Announcements 1.0.0.b (Truncado y Error)

patolin · #1

URL: http://games360.net23.net/foro/index.php" onclick="window.open(this.href);return false;
Versión phpBB: phpBB3 (3.0.4)
MODs Instalados: Google Analystics, AntiBotQuestion, Medal System MOD, Posting
Plantilla(s) usada(s): subsilver
Servidor: linux, gratuito
Actualización desde otra versión: No
Conversión desde otro sistema de foros: No

Hola antes que nada un saludo y espero puedan ayudarme esta es mi situacion:

He corrido lo correspóndien al SQL,
Terminada la modificacion del archivo (global_announcement.xml), me pide que actualice el estilo en plantilla, cuando acepto me manda error.. lo pongo en spoiler:

Spoiler

Código: Seleccionar todo

Error General
SQL ERROR [ mysqli ]

Incorrect string value: '\xF1o

SQL

UPDATE phpbb_styles_template_data SET template_id = 1, template_filename = 'posting_buttons.html', template_included = 'posting_editor.html:', template_mtime = 1231981276, template_data = '\n<script type=\"text/javascript\">\n// <![CDATA[\n var form_name = \'postform\';\n var text_name = <!-- IF $SIG_EDIT -->\'signature\'<!-- ELSE -->\'message\'<!-- ENDIF -->;\n var load_draft = false;\n var upload = false;\n\n // Define the bbCode tags\n var bbcode = new Array();\n var bbtags = new Array(\'[b]\',\'[/b]\',\'[i]\',\'[/i]\',\'[u]\',\'[/u]\',\'[quote]\',\'[/quote]\',\'[code]\',\'

\',\'

\',\'

\',\'

\',\'

\',\'[img]\',\'[/img]\',\'\',\'\',\'[flash=]\', \'[/flash]\',\'[size=]\',\'[/size]\', {custom_tags.BBCODE_NAME});\n var imageTag = false;\n\n // Helpline messages\n var help_line = {\n b: \'{LA_BBCODE_B_HELP}\',\n i: \'{LA_BBCODE_I_HELP}\',\n u: \'{LA_BBCODE_U_HELP}\',\n q: \'{LA_BBCODE_Q_HELP}\',\n c: \'{LA_BBCODE_C_HELP}\',\n l: \'{LA_BBCODE_L_HELP}\',\n o: \'{LA_BBCODE_O_HELP}\',\n p: \'{LA_BBCODE_P_HELP}\',\n w: \'{LA_BBCODE_W_HELP}\',\n a: \'{LA_BBCODE_A_HELP}\',\n s: \'{LA_BBCODE_S_HELP}\',\n f: \'{LA_BBCODE_F_HELP}\',\n e: \'{LA_BBCODE_E_HELP}\',\n d: \'{LA_BBCODE_D_HELP}\'\n \n ,cb_{custom_tags.BBCODE_ID}: \'{custom_tags.A_BBCODE_HELPLINE}\'\n \n }\n\n var panels = new Array(\'options-panel\', \'attach-panel\', \'poll-panel\');\n var show_panel = \'options-panel\';\n\n\n// ]]>\n</script>\n<script type=\"text/javascript\" src=\"{T_TEMPLATE_PATH}/editor.js\"></script>\n\n\n<div id=\"colour_palette\" style=\"display: none;\">\n\n <script type=\"text/javascript\">\n // <![CDATA[\n function change_palette()\n {\n dE(\'colour_palette\');\n e = document.getElementById(\'colour_palette\');\n\n if (e.style.display == \'block\')\n {\n document.getElementById(\'bbpalette\').value = \'{LA_FONT_COLOR_HIDE}\';\n }\n else\n {\n document.getElementById(\'bbpalette\').value = \'{LA_FONT_COLOR}\';\n }\n }\n\n colorPalette(\'h\', 15, 10);\n // ]]>\n </script>\n</div>\n\n<div id=\"format-buttons\">\n <select name=\"fuentes\" style=\"height: 22px;\" onchange=\"bbfontstyle(\'[font=\' + this.form.fuentes.options[this.form.fuentes.selectedIndex].value + \']\', \'[/font]\');this.selectedIndex=0;\" title=\"Tipo de fuente: Texto\">\n <option value=\"\" style=\"font-family: Verdana;\" selected=\"selected\">Fuente</option>\n <option value=\"Arial\" style=\"font-family: Arial;\">Arial</option>\n <option value=\"Comic Sans MS\" style=\"font-family: \'Comic Sans MS\';\">Comic Sans MS</option>\n <option value=\"Courier New\" style=\"font-family: \'Courier New\';\">Courier New</option>\n\n <option value=\"Impact\" style=\"font-family: Impact;\">Impact</option>\n <option value=\"Lucida Console\" style=\"font-family: \'Lucida Console\';\">Lucida Console</option>\n <option value=\"Lucida Sans Unicode\" style=\"font-family: \'Lucida Sans Unicode\';\">Lucida Sans Unicode</option>\n <option value=\"Microsoft Sans Serif\" style=\"font-family: \'Microsoft Sans Serif\';\">Microsoft Sans Serif</option>\n <option value=\"Symbol\" style=\"font-family: Symbol;\">Symbol</option>\n <option value=\"Tahoma\" style=\"font-family: Tahoma;\">Tahoma</option>\n\n <option value=\"Times New Roman\" style=\"font-family: \'Times New Roman\';\">Times New Roman</option>\n <option value=\"Traditional Arabic\" style=\"font-family: \'Traditional Arabic\';\">Traditional Arabic</option>\n <option value=\"Trebuchet MS\" style=\"font-family: \'Trebuchet MS\';\">Trebuchet MS</option>\n <option value=\"Verdana\" style=\"font-family: Verdana;\">Verdana</option>\n <option value=\"Webdings\" style=\"font-family: Webdings;\">Webdings</option>\n <option value=\"Wingdings\" style=\"font-family: Wingdings;\">Wingdings</option>\n </select>\n\n <select name=\"addbbcode20\" onchange=\"bbfontstyle(\'[size=\' + this.form.addbbcode20.options[this.form.addbbcode20.selectedIndex].value + \']\', \'[/size]\');this.form.addbbcode20.selectedIndex = 0;\" title=\"{L_BBCODE_F_HELP}\">\n <option value=\"\" selected=\"selected\">Tama�o</option>\n <option value=\"50\">{L_FONT_TINY}</option>\n <option value=\"85\">{L_FONT_SMALL}</option>\n <option value=\"100\">{L_FONT_NORMAL}</option>\n <option value=\"150\">{L_FONT_LARGE}</option>\n <option value=\"200\">{L_FONT_HUGE}</option>\n </select>\n <input type=\"button\" style=\"height: 22px;\" class=\"button2\" name=\"bbpalette\" id=\"bbpalette\" value=\"{L_FONT_COLOR}\" onclick=\"change_palette();\" title=\"{L_BBCODE_S_HELP}\" />\n<br>\n\n<img src=\"./images/posting/left.png\" border=\"0\" alt=\"align=left\" onclick=\"bbfontstyle(\'

\',\'[/left]\')\" title=\"Alinear a la Izquierda:

Texto

\" class=\"bbimages\"/>\n<img src=\"./images/posting/center.png\" border=\"0\" alt=\"align=center\" onclick=\"bbfontstyle(\'

\',\'

\')\" title=\"Centrar:

Texto

\" class=\"bbimages\"/>\n<img src=\"./images/posting/right.png\" border=\"0\" alt=\"align=right\" onclick=\"bbfontstyle(\'

\',\'

\')\" title=\"Alinear a la Derecha:

Texto

\" class=\"bbimages\"/>\n<img src=\"./images/posting/justify.png\" border=\"0\" alt=\"align=justify\" onclick=\"bbfontstyle(\'

\',\'

\')\" title=\"Justificar:

Texto

\" class=\"bbimages\"/>\n\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\n\n<img src=\"./images/posting/bold.png\" border=\"0\" alt=\"b\" accesskey=\"b\" name=\"addbbcode0\" value=\" B \" onclick=\"bbstyle(0)\" title=\"{L_BBCODE_B_HELP}\" class=\"bbimages\"/>\n<img src=\"./images/posting/italic.png\" border=\"0\" alt=\"i\" accesskey=\"i\" name=\"addbbcode2\" value=\" i \" onclick=\"bbstyle(2)\" title=\"{L_BBCODE_I_HELP}\" class=\"bbimages\"/>\n<img src=\"./images/posting/under.png\" border=\"0\" alt=\"u\" accesskey=\"u\" name=\"addbbcode4\" value=\" u \" onclick=\"bbstyle(4)\" title=\"{L_BBCODE_U_HELP}\" class=\"bbimages\"/>\n<img src=\"./images/posting/strike.png\" border=\"0\" alt=\"strike\" onclick=\"bbfontstyle(\'~~\',\'~~\')\" title=\"Texto Tachado: ~~Texto~~\" class=\"bbimages\"/>\n<img src=\"./images/posting/sup.gif\" border=\"0\" alt=\"sup\" onclick=\"bbfontstyle(\'^\',\'\')\" title=\"Super�ndice: ^Texto\" class=\"bbimages\"/>\n<img src=\"./images/posting/sub.gif\" border=\"0\" alt=\"sub\" onclick=\"bbfontstyle(\'_\',\'\')\" title=\"Sub�ndice: _Texto\" class=\"bbimages\"/>\n\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\n\n<img src=\"./images/posting/listb.png\" border=\"0\" alt=\"list\" accesskey=\"l\" name=\"addbbcode10\" value=\"List\" onclick=\"bbstyle(10)\" title=\"{L_BBCODE_L_HELP}\" class=\"bbimages\"/>\n<img src=\"./images/posting/listo.png\" border=\"0\" alt=\"list=\" accesskey=\"o\" name=\"addbbcode12\" value=\"List=\" onclick=\"bbstyle(12)\" title=\"{L_BBCODE_O_HELP}\" class=\"bbimages\"/>\n<img src=\"./images/posting/listitem.gif\" border=\"0\" alt=\"[*]\" accesskey=\"t\" name=\"addlitsitem\" value=\"[*]\" onclick=\"bbstyle(-1)\" title=\"{L_BBCODE_LISTITEM_HELP}\" class=\"bbimages\"/>\n\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\n\n<img src=\"./images/posting/highlight=.gif\" border=\"0\" alt=\"highlight\" onclick=\"bbfontstyle(\'\',\'\')\" title=\"Toque de luz (highlight): [highlight=#COLOR]Texto[/highlight]\" class=\"bbimages\"/>\n<img src=\"./images/posting/hr.png\" border=\"0\" alt=\"hr\" onclick=\"bbfontstyle(\'

\')\" title=\"L�nea Horizontal:

\" class=\"bbimages\"/>\n<img src=\"./images/posting/ot.gif\" border=\"0\" alt=\"ot\" onclick=\"bbfontstyle(\'

Off Topic:

\',\'

\')\" onmouseover=\"helpline(\'ot\')\" title=\"Offtopic:

Off Topic:

Texto

\" class=\"bbimages\"/>\n\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\n\n<img src=\"./images/posting/marqd.gif\" border=\"0\" alt=\"marquee=down\" onclick=\"bbfontstyle(\'\',\'\')\" title=\"Desplazar texto hacia abajo: Texto\" class=\"bbimages\"/>\n<img src=\"./images/posting/marqu.gif\" border=\"0\" alt=\"marquee=up\" onclick=\"bbfontstyle(\'\',\'\')\" title=\"Desplazar texto hacia arriba: Texto\" class=\"bbimages\"/>\n<img src=\"./images/posting/marql.gif\" border=\"0\" alt=\"marquee=left\" onclick=\"bbfontstyle(\'\',\'\')\" title=\"Desplazar texto hacia la izquierda: Texto\" class=\"bbimages\"/>\n<img src=\"./images/posting/marqr.gif\" border=\"0\" alt=\"marquee=right\" onclick=\"bbfontstyle(\'\',\'\')\" title=\"Desplazar texto hacia la derecha: Texto\" class=\"bbimages\"/>\n<br>\n \n<img src=\"./images/posting/quote.png\" border=\"0\" alt=\"quote\" accesskey=\"q\" name=\"addbbcode6\" value=\"Quote\" onclick=\"bbstyle(6)\" title=\"{L_BBCODE_Q_HELP}\" class=\"bbimages\"/>\n \n<img src=\"./images/posting/code.png\" border=\"0\" alt=\"code\" accesskey=\"c\" name=\"addbbcode8\" value=\"Code\" onclick=\"bbstyle(8)\" title=\"{L_BBCODE_C_HELP}\" class=\"bbimages\"/>\n<img src=\"./images/posting/spoiler.gif\" border=\"0\" alt=\"spoiler\" onclick=\"bbfontstyle(\'

Spoiler

\',\'

\')\" title=\"Spoiler:

Spoiler

Texto

\" class=\"bbimages\"/>\n\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\n\n \n<img src=\"./images/posting/img.png\" border=\"0\" alt=\"img\" accesskey=\"p\" name=\"addbbcode14\" value=\"Img\" onclick=\"bbstyle(14)\" title=\"{L_BBCODE_P_HELP}\" class=\"bbimages\"/>\n \n \n<img src=\"./images/posting/url.gif\" border=\"0\" alt=\"url\" accesskey=\"w\" name=\"addbbcode16\" value=\"URL\" onclick=\"bbstyle(16)\" title=\"{L_BBCODE_W_HELP}\" class=\"bbimages\"/>\n \n<img src=\"./images/posting/email.gif\" alt=\"email\" border=\"0\" onclick=\"bbfontstyle(\'[email]\',\'[/email]\')\" title=\"Correo: [mail]Correo[/mail]\" class=\"bbimages\"/>\n\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\n\n \n<img src=\"./images/posting/flash.png\" border=\"0\" alt=\"flash\" accesskey=\"d\" name=\"addbbcode18\" value=\"Flash\" onclick=\"bbstyle(18)\" title=\"{L_BBCODE_D_HELP}\" class=\"bbimages\"/>\n \n<img src=\"./images/posting/video.png\" border=\"0\" alt=\"mp3\" onclick=\"bbfontstyle(\'[video width=320 height=285]\',\'[/video]\')\" title=\"Video (avi/wmv/mpg): [video width=ancho height=alto]URL del archivo[/video]\" class=\"bbimages\"/>\n<img src=\"./images/posting/mp3.gif\" border=\"0\" alt=\"mp3\" onclick=\"bbfontstyle(\'

\')\" title=\"Archivo de audio (mp3):

\" class=\"bbimages\"/>\n<img src=\"./images/posting/quick.gif\" border=\"0\" alt=\"quick\" onclick=\"bbfontstyle(\'[quick width=320 height=240]\',\'[/quick]\')\" title=\"Video Quicktime: [quick width=ancho height=alto]URL del archivo[/quick]\" class=\"bbimages\"/>\n<img src=\"./images/posting/ram.gif\" border=\"0\" alt=\"ram\" onclick=\"bbfontstyle(\'[ram width=275 height=40]\',\'[/ram]\')\" title=\"Archivo Real Media: [ram width=ancho height=alto]URL del archivo[/ram]\" class=\"bbimages\"/>\n<img src=\"./images/posting/googlevideo.png\" border=\"0\" alt=\"googlevideo\" onclick=\"bbfontstyle(\'[googlevideo]\',\'[/googlevideo]\')\" title=\"Video google: [googlevideo]ID del video[/googlevideo]\" class=\"bbimages\"/>\n<img src=\"./images/posting/youtube.png\" border=\"0\" alt=\"youtube\" onclick=\"bbfontstyle(\'\')\" title=\"Video youtube:\" class=\"bbimages\"/>\n \n<br>\n \n<img src=\"./images/posting/{custom_tags.BBCODE_TAG}.gif\" border=\"0\" name=\"addbbcode{custom_tags.BBCODE_ID}\" alt=\"{custom_tags.BBCODE_TAG}\" value=\"{custom_tags.BBCODE_TAG}\" onclick=\"bbstyle({custom_tags.BBCODE_ID})\" title=\"{custom_tags.BBCODE_HELPLINE}\" class=\"bbimages\"/>\n \n \n</div>\n \n' WHERE template_id = 1 AND template_filename = 'posting_buttons.html'

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_styles.php
LINE: 2572
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_styles.php
LINE: 284
CALL: acp_styles->store_templates()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_styles->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
[/code]

Procediendo con la modificacion con el archivo: prosilver.xml
me pide que encuntre estas lineas para remplzar:

Código: Seleccionar todo

			<dl class="icon" style="background-image: url({forumrow.FORUM_FOLDER_IMG_SRC}); background-repeat: no-repeat;">
				<dt>

En mi archivo aparece asi:

Spoiler

<dl class="icon" style="background-image: url({forumrow.FORUM_FOLDER_IMG_SRC}); background-repeat: no-repeat;">
<dt title="{forumrow.FORUM_FOLDER_IMG_ALT}">
<span class="forum-image">{forumrow.FORUM_IMAGE}</span>
<a href="{forumrow.U_VIEWFORUM}" class="forumtitle">{forumrow.FORUM_NAME}</a><br />
{forumrow.FORUM_DESC}

<br /><strong>{forumrow.L_MODERATOR_STR}:</strong> {forumrow.MODERATORS}

<br /><strong>{forumrow.L_SUBFORUM_STR}</strong> {forumrow.SUBFORUMS}
</dt>

El Link del MOD que intento instalar: (Global Announcements 1.0.0.b)
http://www.phpbb.com/mods/db/index.php? ... ib_id=2905" onclick="window.open(this.href);return false;

Y en este tema no encuentro por ningun lugar la version modifida que dice el post:
http://www.phpbb-es.com/foro/global-ann ... 14227.html" onclick="window.open(this.href);return false;
Espero que me halla explicado bien y cumplir los requisitos para el soporte,gracias de antemano