Seite 1 von 1

Fehlermeldung

Verfasst: 17.08.2011 18:30
von lifestyle2010
Hallo,

habe vor kurzem ein Forum eingerichtet und bekomme beim erstellen eines Beitrages folgende Fehlermeldung, wenn ich den Entwurf abspeichern möchte bzw. ich dieses im Forenbereich aufrufe.

Allgemeiner Fehler
SQL ERROR [ mysql4 ]

Incorrect string value: '\xFCr Ede...' for column 'template_data' at row 1 [1366]

SQL

INSERT INTO phpbb_styles_template_data (template_id, template_filename, template_included, template_mtime, template_data) VALUES ('1', 'overall_header.html', '', 1313597967, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1- ... \">\n<html xmlns=\"http://www.w3.org/1999/xhtml\" dir=\"{S_CONTENT_DIRECTION}\" lang=\"{S_USER_LANG}\" xml:lang=\"{S_USER_LANG}\">\n<head>\n\n<meta http-equiv=\"content-type\" content=\"text/html; charset={S_CONTENT_ENCODING}\" />\n<meta http-equiv=\"content-style-type\" content=\"text/css\" />\n<meta http-equiv=\"content-language\" content=\"{S_USER_LANG}\" />\n<meta http-equiv=\"imagetoolbar\" content=\"no\" />\n<meta name=\"resource-type\" content=\"document\" />\n<meta name=\"distribution\" content=\"global\" />\n<meta name=\"keywords\" content=\"Forum, Edelsteine, Heilsteine, Chakra, Chakren, Chakras, Heilstein, Edelstein, Esotherik, Mineralien\" />\n<meta name=\"description\" content=\"Forum f�r Edelsteine und Mineralien - Heilsteine und Chakras. Und f�r Freunde der Esotherik.\" />\n{META}\n<title>{SITENAME} &bull; <!-- IF S_IN_MCP -->{L_MCP} &bull; <!-- ELSEIF S_IN_UCP -->{L_UCP} &bull; <!-- ENDIF -->{PAGE_TITLE}</title>\n\n<!-- IF S_ENABLE_FEEDS -->\n <!-- IF S_ENABLE_FEEDS_OVERALL --><link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {SITENAME}\" href=\"{U_FEED}\" /><!-- ENDIF -->\n <!-- IF S_ENABLE_FEEDS_NEWS --><link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_FEED_NEWS}\" href=\"{U_FEED}?mode=news\" /><!-- ENDIF -->\n <!-- IF S_ENABLE_FEEDS_FORUMS --><link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_ALL_FORUMS}\" href=\"{U_FEED}?mode=forums\" /><!-- ENDIF -->\n <!-- IF S_ENABLE_FEEDS_TOPICS --><link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_FEED_TOPICS_NEW}\" href=\"{U_FEED}?mode=topics\" /><!-- ENDIF -->\n <!-- IF S_ENABLE_FEEDS_TOPICS_ACTIVE --><link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_FEED_TOPICS_ACTIVE}\" href=\"{U_FEED}?mode=topics_active\" /><!-- ENDIF -->\n <!-- IF S_ENABLE_FEEDS_FORUM and S_FORUM_ID --><link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_FORUM} - {FORUM_NAME}\" href=\"{U_FEED}?f={S_FORUM_ID}\" /><!-- ENDIF -->\n <!-- IF S_ENABLE_FEEDS_TOPIC and S_TOPIC_ID --><link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_TOPIC} - {TOPIC_TITLE}\" href=\"{U_FEED}?f={S_FORUM_ID}&t={S_TOPIC_ID}\" /><!-- ENDIF -->\n<!-- ENDIF -->\n\n<!--\n phpBB style name: prosilver\n Based on style: prosilver (this is the default phpBB3 style)\n Original author: Tom Beddard ( http://www.subBlue.com/ )\n Modified by:\n\n NOTE: This page was generated by phpBB, the free open-source bulletin board package.\n The phpBB Group is not responsible for the content of this page and forum. For more information\n about phpBB please visit http://www.phpbb.com\n-->\n\n<script type=\"text/javascript\">\n// <![CDATA[\n var jump_page = \'{LA_JUMP_PAGE}:\';\n var on_page = \'{ON_PAGE}\';\n var per_page = \'{PER_PAGE}\';\n var base_url = \'{A_BASE_URL}\';\n var style_cookie = \'phpBBstyle\';\n var style_cookie_settings = \'{A_COOKIE_SETTINGS}\';\n var onload_functions = new Array();\n var onunload_functions = new Array();\n\n <!-- IF S_USER_PM_POPUP and S_NEW_PM -->\n var url = \'{UA_POPUP_PM}\';\n window.open(url.replace(/&/g, \'&\'), \'_phpbbprivmsg\', \'height=225,resizable=yes,scrollbars=yes, width=400\');\n <!-- ENDIF -->\n\n /**\n * Find a member\n */\n function find_username(url)\n {\n popup(url, 760, 570, \'_usersearch\');\n return false;\n }\n\n /**\n * New function for handling multiple calls to window.onload and window.unload by pentapenguin\n */\n window.onload = function()\n {\n for (var i = 0; i < onload_functions.length; i++)\n {\n eval(onload_functions);\n }\n }\n\n window.onunload = function()\n {\n for (var i = 0; i < onunload_functions.length; i++)\n {\n eval(onunload_functions);\n }\n }\n\n// ]]>\n</script>\n<script type=\"text/javascript\" src=\"{T_SUPER_TEMPLATE_PATH}/styleswitcher.js\"></script>\n<script type=\"text/javascript\" src=\"{T_SUPER_TEMPLATE_PATH}/forum_fn.js\"></script>\n\n<link href=\"{T_THEME_PATH}/print.css\" rel=\"stylesheet\" type=\"text/css\" media=\"print\" title=\"printonly\" />\n<link href=\"{T_STYLESHEET_LINK}\" rel=\"stylesheet\" type=\"text/css\" media=\"screen, projection\" />\n\n<link href=\"{T_THEME_PATH}/normal.css\" rel=\"stylesheet\" type=\"text/css\" title=\"A\" />\n<link href=\"{T_THEME_PATH}/medium.css\" rel=\"alternate stylesheet\" type=\"text/css\" title=\"A+\" />\n<link href=\"{T_THEME_PATH}/large.css\" rel=\"alternate stylesheet\" type=\"text/css\" title=\"A++\" />\n\n<!-- IF S_CONTENT_DIRECTION eq \'rtl\' -->\n <link href=\"{T_THEME_PATH}/bidi.css\" rel=\"stylesheet\" type=\"text/css\" media=\"screen, projection\" />\n<!-- ENDIF -->\n\n</head>\n\n<body id=\"phpbb\" class=\"section-{SCRIPT_NAME} {S_CONTENT_DIRECTION}\">\n\n<div id=\"wrap\">\n <a id=\"top\" name=\"top\" accesskey=\"t\"></a>\n <div id=\"page-header\">\n <div class=\"headerbar\">\n <div class=\"inner\"><span class=\"corners-top\"><span></span></span>\n\n <div id=\"site-description\">\n <a href=\"{U_INDEX}\" title=\"{L_INDEX}\" id=\"logo\">{SITE_LOGO_IMG}</a>\n <h1>{SITENAME}</h1>\n <p>{SITE_DESCRIPTION}</p>\n <p class=\"skiplink\"><a href=\"#start_here\">{L_SKIP}</a></p>\n </div>\n\n <!-- IF S_DISPLAY_SEARCH and not S_IN_SEARCH -->\n <div id=\"search-box\">\n <form action=\"{U_SEARCH}\" method=\"get\" id=\"search\">\n <fieldset>\n <input name=\"keywords\" id=\"keywords\" type=\"text\" maxlength=\"128\" title=\"{L_SEARCH_KEYWORDS}\" class=\"inputbox search\" value=\"<!-- IF SEARCH_WORDS-->{SEARCH_WORDS}<!-- ELSE -->{L_SEARCH_MINI}<!-- ENDIF -->\" onclick=\"if(this.value==\'{LA_SEARCH_MINI}\')this.value=\'\';\" onblur=\"if(this.value==\'\')this.value=\'{LA_SEARCH_MINI}\';\" />\n <input class=\"button2\" value=\"{L_SEARCH}\" type=\"submit\" /><br />\n <a href=\"{U_SEARCH}\" title=\"{L_SEARCH_ADV_EXPLAIN}\">{L_SEARCH_ADV}</a> {S_SEARCH_HIDDEN_FIELDS}\n </fieldset>\n </form>\n </div>\n <!-- ENDIF -->\n\n <span class=\"corners-bottom\"><span></span></span></div>\n </div>\n\n <div class=\"navbar\">\n <div class=\"inner\"><span class=\"corners-top\"><span></span></span>\n\n <ul class=\"linklist navlinks\">\n <li class=\"icon-home\"><a href=\"{U_INDEX}\" accesskey=\"h\">{L_INDEX}</a> <!-- BEGIN navlinks --> <strong>&#8249;</strong> <a href=\"{navlinks.U_VIEW_FORUM}\">{navlinks.FORUM_NAME}</a><!-- END navlinks --></li>\n\n <li class=\"rightside\"><a href=\"#\" onclick=\"fontsizeup(); return false;\" onkeypress=\"return fontsizeup(event);\" class=\"fontsize\" title=\"{L_CHANGE_FONT_SIZE}\">{L_CHANGE_FONT_SIZE}</a></li>\n\n <!-- IF U_EMAIL_TOPIC --><li class=\"rightside\"><a href=\"{U_EMAIL_TOPIC}\" title=\"{L_EMAIL_TOPIC}\" class=\"sendemail\">{L_EMAIL_TOPIC}</a></li><!-- ENDIF -->\n <!-- IF U_EMAIL_PM --><li class=\"rightside\"><a href=\"{U_EMAIL_PM}\" title=\"{L_EMAIL_PM}\" class=\"sendemail\">{L_EMAIL_PM}</a></li><!-- ENDIF -->\n <!-- IF U_PRINT_TOPIC --><li class=\"rightside\"><a href=\"{U_PRINT_TOPIC}\" title=\"{L_PRINT_TOPIC}\" accesskey=\"p\" class=\"print\">{L_PRINT_TOPIC}</a></li><!-- ENDIF -->\n <!-- IF U_PRINT_PM --><li class=\"rightside\"><a href=\"{U_PRINT_PM}\" title=\"{L_PRINT_PM}\" accesskey=\"p\" class=\"print\">{L_PRINT_PM}</a></li><!-- ENDIF -->\n </ul>\n\n <!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->\n <ul class=\"linklist leftside\">\n <li class=\"icon-ucp\">\n <a href=\"{U_PROFILE}\" title=\"{L_PROFILE}\" accesskey=\"e\">{L_PROFILE}</a>\n <!-- IF S_DISPLAY_PM --> (<a href=\"{U_PRIVATEMSGS}\">{PRIVATE_MESSAGE_INFO}</a>)<!-- ENDIF -->\n <!-- IF S_DISPLAY_SEARCH --> &bull;\n <a href=\"{U_SEARCH_SELF}\">{L_SEARCH_SELF}</a>\n <!-- ENDIF -->\n <!-- IF U_RESTORE_PERMISSIONS --> &bull;\n <a href=\"{U_RESTORE_PERMISSIONS}\">{L_RESTORE_PERMISSIONS}</a>\n <!-- ENDIF -->\n </li>\n </ul>\n <!-- ENDIF -->\n\n <ul class=\"linklist rightside\">\n <li class=\"icon-faq\"><a href=\"{U_FAQ}\" title=\"{L_FAQ_EXPLAIN}\">{L_FAQ}</a></li>\n <!-- IF not S_IS_BOT -->\n <!-- IF S_DISPLAY_MEMBERLIST --><li class=\"icon-members\"><a href=\"{U_MEMBERLIST}\" title=\"{L_MEMBERLIST_EXPLAIN}\">{L_MEMBERLIST}</a></li><!-- ENDIF -->\n <!-- IF not S_USER_LOGGED_IN and S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><li class=\"icon-register\"><a href=\"{U_REGISTER}\">{L_REGISTER}</a></li><!-- ENDIF -->\n <li class=\"icon-logout\"><a href=\"{U_LOGIN_LOGOUT}\" title=\"{L_LOGIN_LOGOUT}\" accesskey=\"x\">{L_LOGIN_LOGOUT}</a></li>\n <!-- ENDIF -->\n </ul>\n\n <span class=\"corners-bottom\"><span></span></span></div>\n </div>\n\n </div>\n\n <a name=\"start_here\"></a>\n <div id=\"page-body\">\n <!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN and (U_MCP or U_ACP) -->\n <div id=\"information\" class=\"rules\">\n <div class=\"inner\"><span class=\"corners-top\"><span></span></span>\n <strong>{L_INFORMATION}:</strong> {L_BOARD_DISABLED}\n <span class=\"corners-bottom\"><span></span></span></div>\n </div>\n <!-- ENDIF -->')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/functions_template.php
LINE: 85
CALL: dbal_mysql->sql_query()

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

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

FILE: includes/functions.php
LINE: 4700
CALL: template->display()

FILE: viewtopic.php
LINE: 1765
CALL: page_footer()

Kann mir jemand dabei helfen den fehler zu beheben? danke schon mal im vorraus.

Gruß Kay

Re: Fehlermeldung

Verfasst: 17.08.2011 19:45
von Mahony
Hallo
Das sieht nach einem Problem mit dem Zeichensatz aus. Der "Fehler" liegt darin, dass du Umlaute in der overall_header.html hast, die Datei aber nicht in UTF8 ohne BOM gespeichert hast.
Siehe dazu auch KB:utf8bom


Grüße: Mahony

Re: Fehlermeldung

Verfasst: 18.08.2011 11:41
von lifestyle2010
ja danke hast recht gehabt. habe die html. datei in utf - 8 bom abgespeichert und es funktioniert. danke für deine hilfe.