phpBB España Oficial

phpBB España Oficial, Soporte Internacional Oficial del sistema de foros phpBB en Español, extensiones, estilos, traducciones, guías, tutoriales, videos, redes sociales, webmaster.
https://www.phpbb-es.com/foro/

Problema al responder/crear nuevo mensaje

https://www.phpbb-es.com/foro/viewtopic.php?t=36786

Página 1 de 1

Problema al responder/crear nuevo mensaje

Publicado: 21 Sep 2012, 00:48
por berto1989
Buenas, de vez en cuando al crear/responder un mensaje me salta el siguiente error:

Código: Seleccionar todo

Error General
SQL ERROR [ mysqli ]

Incorrect string value: '\xF1o
SQL

INSERT INTO Ng_styles_template_data (template_id, template_filename, template_included, template_mtime, template_data) VALUES ('4', 'posting_buttons.html', '', 1348181193, '<!-- IF S_BBCODE_ALLOWED -->\r\n<div id=\"colour_palette\" style=\"display: none;\">\r\n\r\n	 <script type=\"text/javascript\">\r\n	 // <![CDATA[\r\n	 function change_palette()\r\n	 {\r\n	 dE(\'colour_palette\');\r\n	 e = document.getElementById(\'colour_palette\');\r\n	 \r\n	 if (e.style.display == \'block\')\r\n	 {\r\n	 document.getElementById(\'bbpalette\').value = \'{LA_FONT_COLOR_HIDE}\';\r\n	 }\r\n	 else\r\n	 {\r\n	 document.getElementById(\'bbpalette\').value = \'{LA_FONT_COLOR}\';\r\n	 }\r\n	 }\r\n\r\n colorPalette(\'h\', 15, 10);\r\n	 // ]]>\r\n	 </script>\r\n</div>\r\n\r\n<div id=\"format-buttons\">\r\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: [font=Arial]Texto[/font]\">\r\n	 <option value=\"\" style=\"font-family: Verdana;\" selected=\"selected\">Fuente</option>\r\n	 <option value=\"Arial\" style=\"font-family: Arial;\">Arial</option>\r\n	 <option value=\"Comic Sans MS\" style=\"font-family: \'Comic Sans MS\';\">Comic Sans MS</option>\r\n	 <option value=\"Courier New\" style=\"font-family: \'Courier New\';\">Courier New</option>\r\n\r\n	 <option value=\"Impact\" style=\"font-family: Impact;\">Impact</option>\r\n	 <option value=\"Lucida Console\" style=\"font-family: \'Lucida Console\';\">Lucida Console</option>\r\n	 <option value=\"Lucida Sans Unicode\" style=\"font-family: \'Lucida Sans Unicode\';\">Lucida Sans Unicode</option>\r\n	 <option value=\"Microsoft Sans Serif\" style=\"font-family: \'Microsoft Sans Serif\';\">Microsoft Sans Serif</option>\r\n	 <option value=\"Symbol\" style=\"font-family: Symbol;\">Symbol</option>\r\n	 <option value=\"Tahoma\" style=\"font-family: Tahoma;\">Tahoma</option>\r\n\r\n	 <option value=\"Times New Roman\" style=\"font-family: \'Times New Roman\';\">Times New Roman</option>\r\n	 <option value=\"Traditional Arabic\" style=\"font-family: \'Traditional Arabic\';\">Traditional Arabic</option>\r\n	 <option value=\"Trebuchet MS\" style=\"font-family: \'Trebuchet MS\';\">Trebuchet MS</option>\r\n	 <option value=\"Verdana\" style=\"font-family: Verdana;\">Verdana</option>\r\n	 <option value=\"Webdings\" style=\"font-family: Webdings;\">Webdings</option>\r\n	 <option value=\"Wingdings\" style=\"font-family: Wingdings;\">Wingdings</option>\r\n	 </select>\r\n\r\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}\">\r\n	 <option value=\"\" selected=\"selected\">Tama�o</option>\r\n	 <option value=\"50\">{L_FONT_TINY}</option>\r\n	 <option value=\"85\">{L_FONT_SMALL}</option>\r\n	 <option value=\"100\">{L_FONT_NORMAL}</option>\r\n	 <option value=\"150\">{L_FONT_LARGE}</option>\r\n	 </select>\r\n<br>\r\n\r\n<img src=\"./images/posting/left.gif\" border=\"0\" alt=\"align=left\" onclick=\"bbfontstyle(\'[align=left]\',\'[/align]\')\" title=\"Alinear a la Izquierda: [align=left]Texto[/align]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/center.gif\" border=\"0\" alt=\"align=center\" onclick=\"bbfontstyle(\'[align=center]\',\'[/align]\')\" title=\"Centrar: [align=center]Texto[/align]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/right.gif\" border=\"0\" alt=\"align=right\" onclick=\"bbfontstyle(\'[align=right]\',\'[/align]\')\" title=\"Alinear a la Derecha: [align=right]Texto[/align]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/justify.gif\" border=\"0\" alt=\"align=justify\" onclick=\"bbfontstyle(\'[align=justify]\',\'[/align]\')\" title=\"Justificar: [align=justify]Texto[/align]\" class=\"bbimages\"/>\r\n\r\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\r\n\r\n<img src=\"./images/posting/bold.gif\" border=\"0\" alt=\"b\" accesskey=\"b\" name=\"addbbcode0\" value=\" B \" onclick=\"bbstyle(0)\" title=\"{L_BBCODE_B_HELP}\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/italic.gif\" border=\"0\" alt=\"i\" accesskey=\"i\" name=\"addbbcode2\" value=\" i \" onclick=\"bbstyle(2)\" title=\"{L_BBCODE_I_HELP}\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/under.gif\" border=\"0\" alt=\"u\" accesskey=\"u\" name=\"addbbcode4\" value=\" u \" onclick=\"bbstyle(4)\" title=\"{L_BBCODE_U_HELP}\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/strike.gif\" border=\"0\" alt=\"strike\" onclick=\"bbfontstyle(\'[strike]\',\'[/strike]\')\" title=\"Texto Tachado: [strike]Texto[/strike]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/sup.gif\" border=\"0\" alt=\"sup\" onclick=\"bbfontstyle(\'[sup]\',\'[/sup]\')\" title=\"Super?ndice: [sup]Texto[/sup]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/sub.gif\" border=\"0\" alt=\"sub\" onclick=\"bbfontstyle(\'[sub]\',\'[/sub]\')\" title=\"Sub?ndice: [sub]Texto[/sub]\" class=\"bbimages\"/>\r\n\r\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\r\n\r\n<img src=\"./images/posting/listb.gif\" border=\"0\" alt=\"list\" accesskey=\"l\" name=\"addbbcode10\" value=\"List\" onclick=\"bbstyle(10)\" title=\"{L_BBCODE_L_HELP}\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/listo.gif\" border=\"0\" alt=\"list=\" accesskey=\"o\" name=\"addbbcode12\" value=\"List=\" onclick=\"bbstyle(12)\" title=\"{L_BBCODE_O_HELP}\" class=\"bbimages\"/>\r\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\"/>\r\n\r\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\r\n\r\n<img src=\"./images/posting/highlight=.gif\" border=\"0\" alt=\"highlight\" onclick=\"bbfontstyle(\'[highlight=#FFFFAA]\',\'[/highlight]\')\" title=\"Toque de luz (highlight): [highlight=#COLOR]Texto[/highlight]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/hr.gif\" border=\"0\" alt=\"hr\" onclick=\"bbfontstyle(\'[hr]\',\'[/hr]\')\" title=\"L?nea Horizontal: [hr][/hr]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/ot.gif\" border=\"0\" alt=\"ot\" onclick=\"bbfontstyle(\'[ot]\',\'[/ot]\')\" onmouseover=\"helpline(\'ot\')\" title=\"Offtopic: [ot]Texto[/ot]\" class=\"bbimages\"/>\r\n	 \r\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\r\n	 \r\n<img src=\"./images/posting/marqd.gif\" border=\"0\" alt=\"marquee=down\" onclick=\"bbfontstyle(\'[marquee=down]\',\'[/marquee]\')\" title=\"Desplazar texto hacia abajo: [marquee=down]Texto[/marquee]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/marqu.gif\" border=\"0\" alt=\"marquee=up\" onclick=\"bbfontstyle(\'[marquee=up]\',\'[/marquee]\')\" title=\"Desplazar texto hacia arriba: [marquee=up]Texto[/marquee]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/marql.gif\" border=\"0\" alt=\"marquee=left\" onclick=\"bbfontstyle(\'[marquee=left]\',\'[/marquee]\')\" title=\"Desplazar texto hacia la izquierda: [marquee=left]Texto[/marquee]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/marqr.gif\" border=\"0\" alt=\"marquee=right\" onclick=\"bbfontstyle(\'[marquee=right]\',\'[/marquee]\')\" title=\"Desplazar texto hacia la derecha: [marquee=right]Texto[/marquee]\" class=\"bbimages\"/>\r\n<br>\r\n	 <!-- IF S_BBCODE_QUOTE -->\r\n<img src=\"./images/posting/quote.gif\" border=\"0\" alt=\"quote\" accesskey=\"q\" name=\"addbbcode6\" value=\"Quote\" onclick=\"bbstyle(6)\" title=\"{L_BBCODE_Q_HELP}\" class=\"bbimages\"/>\r\n	 <!-- ENDIF -->\r\n<img src=\"./images/posting/code.gif\" border=\"0\" alt=\"code\" accesskey=\"c\" name=\"addbbcode8\" value=\"Code\" onclick=\"bbstyle(8)\" title=\"{L_BBCODE_C_HELP}\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/spoiler.gif\" border=\"0\" alt=\"spoiler\" onclick=\"bbfontstyle(\'[spoiler]\',\'[/spoiler]\')\" title=\"Spoiler: [spoiler]Texto[/spoiler]\" class=\"bbimages\"/>\r\n\r\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\r\n\r\n	 <!-- IF S_BBCODE_IMG -->\r\n<img src=\"./images/posting/img.gif\" border=\"0\" alt=\"img\" accesskey=\"p\" name=\"addbbcode14\" value=\"Img\" onclick=\"bbstyle(14)\" title=\"{L_BBCODE_P_HELP}\" class=\"bbimages\"/>\r\n	 <!-- ENDIF -->\r\n	 <!-- IF S_LINKS_ALLOWED -->\r\n<img src=\"./images/posting/url.gif\" border=\"0\" alt=\"url\" accesskey=\"w\" name=\"addbbcode16\" value=\"URL\" onclick=\"bbfontstyle(\'[url]\',\'[/url]\')\" title=\"{L_BBCODE_W_HELP}\" class=\"bbimages\"/>\r\n	 <!-- ENDIF -->\r\n<img src=\"./images/posting/email.gif\" alt=\"email\" border=\"0\" onclick=\"bbfontstyle(\'[email]\',\'[/email]\')\" title=\"Correo: [mail]Correo[/mail]\" class=\"bbimages\"/>\r\n\r\n<img src=\"./images/posting/dots.gif\" border=\"0\" style=\"padding-left: 5px; padding-right: 5px;\" />\r\n	 \r\n	 <!-- IF S_BBCODE_FLASH -->\r\n<img src=\"./images/posting/flash.gif\" border=\"0\" alt=\"flash\" accesskey=\"d\" name=\"addbbcode18\" value=\"Flash\" onclick=\"bbstyle(18)\" title=\"{L_BBCODE_D_HELP}\" class=\"bbimages\"/>\r\n	 <!-- ENDIF -->\r\n<img src=\"./images/posting/youtube.gif\" border=\"0\" alt=\"youtube\" onclick=\"bbfontstyle(\'[youtube]\',\'[/youtube]\')\" title=\"Video youtube:[youtube]url[/youtube]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/video.gif\" border=\"0\" alt=\"Video\" onclick=\"bbfontstyle(\'[video]\',\'[/video]\')\" title=\"Video:[video]url[/video]\" class=\"bbimages\"/>\r\n<img src=\"./images/posting/cortar.gif\" border=\"0\" alt=\"Cortar Noticia\" onclick=\"bbfontstyle(\'[blurb]\',\'[/blurb]\')\" title=\"Cortar Noticia:[blurb][/blurb]\" class=\"bbimages\"/>\r\n	<!-- IF S_BBCODE_ALLOWED and .custom_tags --> \r\n<br>	\r\n	<!-- BEGIN custom_tags -->\r\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\"/>\r\n	<!-- END custom_tags -->\r\n	<!-- ENDIF -->\r\n</div>\r\n	<!-- ENDIF -->')

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 754
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/functions_template.php
LINE: 85
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/template.php
LINE: 388
CALL: template_compile->_tpl_load_file()

FILE: [ROOT]/includes/template.php
LINE: 657
CALL: template->_tpl_load()

FILE: [ROOT]/includes/functions_template.php
LINE: 227
CALL: template->_tpl_include()

FILE: [ROOT]/includes/template.php
LINE: 412
CALL: template_compile->compile()

FILE: [ROOT]/includes/template.php
LINE: 657
CALL: template->_tpl_load()

FILE: [ROOT]/includes/functions_template.php
LINE: 227
CALL: template->_tpl_include()

FILE: [ROOT]/includes/functions_template.php
LINE: 66
CALL: template_compile->compile()

FILE: [ROOT]/includes/template.php
LINE: 394
CALL: template_compile->_tpl_load_file()

FILE: [ROOT]/includes/template.php
LINE: 224
CALL: template->_tpl_load()

FILE: [ROOT]/includes/functions.php
LINE: 4809
CALL: template->display()

FILE: [ROOT]/posting.php
LINE: 1527
CALL: page_footer()
Y tambien me sale al borrar la cache en el portal

Código: Seleccionar todo

Error General
template->_tpl_load_file(): File ./styles/prosilver/template/scripts_footer.html does not exist or is empty

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/functions_template.php
LINE: 63
CALL: trigger_error()

FILE: [ROOT]/includes/template.php
LINE: 430
CALL: template_compile->_tpl_load_file()

FILE: [ROOT]/includes/template.php
LINE: 657
CALL: template->_tpl_load()

FILE: [ROOT]/includes/functions_template.php
LINE: 227
CALL: template->_tpl_include()

FILE: [ROOT]/includes/template.php
LINE: 403
CALL: template_compile->compile()

FILE: [ROOT]/includes/template.php
LINE: 657
CALL: template->_tpl_load()

FILE: [ROOT]/includes/functions_template.php
LINE: 227
CALL: template->_tpl_include()

FILE: [ROOT]/includes/template.php
LINE: 403
CALL: template_compile->compile()

FILE: [ROOT]/includes/template.php
LINE: 224
CALL: template->_tpl_load()

FILE: [ROOT]/includes/functions.php
LINE: 4809
CALL: template->display()

FILE: [ROOT]/portal.php
LINE: 185
CALL: page_footer()
Decir que tengo dos temas activos, uno en un foro privado para ir modificandolo poco a poco y el otro por defecto

URL: http://www.neogammers.com/index.php
Versión phpBB: 3.0.11
MODs Instalados: thanks post,boar3 portal
Plantilla(s) usada(s): Prosilver,ART_helion
Servidor: Linux
Actualización desde otra versión: No
Conversión desde otro sistema de foros: No

Re: Problema al responder/crear nuevo mensaje

Publicado: 22 Oct 2012, 21:29
por Alorse
Son errores diferentes, el primero es por una mala codificación de en la base de datos, pero es complicado solucionarlo, si te fijas dice que que es al entrar un carácter '\xF1o, como nos dices, no siempre pasa...
Cuando pase, debes mirar parcialmente donde es que falla, hay algún carácter especial que no esta siendo reconocido por la base de datos.

El otro error lo que esta diciendo es que hace falta el archivo scripts_footer.html, o lo estas llamando desde otro archivo y al no existir, pues muestra el error.
Todos los horarios son UTC+02:00
Página 1 de 1

Desarrollado por phpBB® Forum Software © phpBB Limited

Traducción al español por phpBB España