Fehlermeldung

lifestyle2010 · Beitrag von **lifestyle2010** » 17.08.2011 18:30

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} • {L_MCP} • {L_UCP} • {PAGE_TITLE}</title>\n\n\n <link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {SITENAME}\" href=\"{U_FEED}\" />\n <link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_FEED_NEWS}\" href=\"{U_FEED}?mode=news\" />\n <link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_ALL_FORUMS}\" href=\"{U_FEED}?mode=forums\" />\n <link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_FEED_TOPICS_NEW}\" href=\"{U_FEED}?mode=topics\" />\n <link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_FEED_TOPICS_ACTIVE}\" href=\"{U_FEED}?mode=topics_active\" />\n <link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {L_FORUM} - {FORUM_NAME}\" href=\"{U_FEED}?f={S_FORUM_ID}\" />\n <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}\" />\n\n\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 \n var url = \'{UA_POPUP_PM}\';\n window.open(url.replace(/&/g, \'&\'), \'_phpbbprivmsg\', \'height=225,resizable=yes,scrollbars=yes, width=400\');\n \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\n <link href=\"{T_THEME_PATH}/bidi.css\" rel=\"stylesheet\" type=\"text/css\" media=\"screen, projection\" />\n\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 \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=\"{SEARCH_WORDS}{L_SEARCH_MINI}\" 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 \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>  <strong>‹</strong> <a href=\"{navlinks.U_VIEW_FORUM}\">{navlinks.FORUM_NAME}</a></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 <li class=\"rightside\"><a href=\"{U_EMAIL_TOPIC}\" title=\"{L_EMAIL_TOPIC}\" class=\"sendemail\">{L_EMAIL_TOPIC}</a></li>\n <li class=\"rightside\"><a href=\"{U_EMAIL_PM}\" title=\"{L_EMAIL_PM}\" class=\"sendemail\">{L_EMAIL_PM}</a></li>\n <li class=\"rightside\"><a href=\"{U_PRINT_TOPIC}\" title=\"{L_PRINT_TOPIC}\" accesskey=\"p\" class=\"print\">{L_PRINT_TOPIC}</a></li>\n <li class=\"rightside\"><a href=\"{U_PRINT_PM}\" title=\"{L_PRINT_PM}\" accesskey=\"p\" class=\"print\">{L_PRINT_PM}</a></li>\n </ul>\n\n \n <ul class=\"linklist leftside\">\n <li class=\"icon-ucp\">\n <a href=\"{U_PROFILE}\" title=\"{L_PROFILE}\" accesskey=\"e\">{L_PROFILE}</a>\n  (<a href=\"{U_PRIVATEMSGS}\">{PRIVATE_MESSAGE_INFO}</a>)\n  •\n <a href=\"{U_SEARCH_SELF}\">{L_SEARCH_SELF}</a>\n \n  •\n <a href=\"{U_RESTORE_PERMISSIONS}\">{L_RESTORE_PERMISSIONS}</a>\n \n </li>\n </ul>\n \n\n <ul class=\"linklist rightside\">\n <li class=\"icon-faq\"><a href=\"{U_FAQ}\" title=\"{L_FAQ_EXPLAIN}\">{L_FAQ}</a></li>\n \n <li class=\"icon-members\"><a href=\"{U_MEMBERLIST}\" title=\"{L_MEMBERLIST_EXPLAIN}\">{L_MEMBERLIST}</a></li>\n <li class=\"icon-register\"><a href=\"{U_REGISTER}\">{L_REGISTER}</a></li>\n <li class=\"icon-logout\"><a href=\"{U_LOGIN_LOGOUT}\" title=\"{L_LOGIN_LOGOUT}\" accesskey=\"x\">{L_LOGIN_LOGOUT}</a></li>\n \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 \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 ')

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

Beitrag von **Mahony** » 17.08.2011 19:45

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

lifestyle2010 · Beitrag von **lifestyle2010** » 18.08.2011 11:41

ja danke hast recht gehabt. habe die html. datei in utf - 8 bom abgespeichert und es funktioniert. danke für deine hilfe.

phpBB.de

Fehlermeldung

Fehlermeldung

Re: Fehlermeldung

Re: Fehlermeldung