ich habe folgendes Problem. Wenn man sich in meinem Forum registrieren möchte, bekommt man folgenden Fehlercode:
----------------------
Incorrect string value: '\xFCndin,...' for column 'template_data' at row 1 [1366]
-----------------------
Habe daraufhin in der SQL Datenbank gesucht und die Betreffende Tabelle geleert...Schön, danch funktionierte es wieder, nur waren meine ganzen manuell durchgeführten modifikationen am Template auch futsch. Also Backups wieder zurück gespielt und Problem wieder da.
Daraufhin habe ich versucht im Acp das Template zu aktualisieren (Acp->Styles->Templates->'Aktualisieren')
Da kam dann folgender Fehlercode:
-------------------------------
Allgemeiner Fehler
SQL ERROR [ mysql4 ]
Incorrect string value: '\xFCndin,...' for column 'template_data' at row 1 [1366]
SQL
Code: Alles auswählen
UPDATE phpbb_forumstyles_template_data SET template_id = 3, template_filename = 'overall_header.html', template_included = 'search_results.html:search_body.html:faq_body.html:ucp_agreement.html:viewforum_body.html:viewonline_body.html:ucp_header.html:message_body.html:mcp_header.html:ucp_resend.html:login_forum.html:login_forum.html:memberlist_view.html:report_body.html:login_body.html:ucp_register.html:mcp_move.html:memberlist_email.html:viewtopic_body.html:confirm_body.html:mcp_approve.html:posting_body.html:ucp_remind.html:memberlist_body.html:index_body.html:memberlist_leaders.html:ucp_agreement.html:portal_body.html:', template_mtime = 1250519462, template_data = '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\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-language\" content=\"{S_USER_LANG}\" />\n<meta http-equiv=\"content-style-type\" content=\"text/css\" />\n<meta http-equiv=\"imagetoolbar\" content=\"no\" />\n<meta name=\"resource-type\" content=\"document\" />\n<meta name=\"distribution\" content=\"global\" />\n<meta name=\"copyright\" content=\"2002-2006 phpBB Group\"/>\n<meta name=\"keywords\" content=\"Sunny, Tierliebe, Hunde, H�ndin, Tierschutz, Tierfreunde, Natur, Bilder, Gedichte, Elektrotechnik\" />\n<meta name=\"description\" content=\"Das Forum der Tiere bietet eine Plattform zum Austausch �ber Tiere. Themen von A-Z werden behandelt.\" />\n<meta http-equiv=\"X-UA-Compatible\" content=\"IE=EmulateIE7\" />\n{META}\n<title>{SITENAME} • <!-- IF S_IN_MCP -->{L_MCP} • <!-- ELSEIF S_IN_UCP -->{L_UCP} • <!-- ENDIF -->{PAGE_TITLE}</title>\n<!-- IF T_STYLESHEET_LINK -->\n<link rel=\"stylesheet\" href=\"{T_STYLESHEET_LINK}\" type=\"text/css\" />\n<!-- ELSE -->\n <style type=\"text/css\">\n {T_THEME_DATA}\n </style>\n <!-- ENDIF -->\n\n<script type=\"text/javascript\">\n// <![CDATA[\n<!-- IF S_USER_PM_POPUP -->\n if ({S_NEW_PM})\n {\n popup(\'{UA_POPUP_PM}\', 400, 225, \'_phpbbprivmsg\');\n }\n<!-- ENDIF -->\n\nfunction popup(url, width, height, name)\n{\n if (!name)\n {\n name = \'_popup\';\n }\n\n window.open(url.replace(/&/g, \'&\'), name, \'height=\' + height + \',resizable=yes,scrollbars=yes,width=\' + width);\n return false;\n}\n\nfunction jumpto()\n{\n var page = prompt(\'{LA_JUMP_PAGE}:\', \'{ON_PAGE}\');\n var per_page = \'{PER_PAGE}\';\n var base_url = \'{A_BASE_URL}\';\n\n if (page !== null && !isNaN(page) && page == Math.floor(page) && page > 0)\n {\n if (base_url.indexOf(\'?\') == -1)\n {\n document.location.href = base_url + \'?start=\' + ((page - 1) * per_page);\n }\n else\n {\n document.location.href = base_url.replace(/&/g, \'&\') + \'&start=\' + ((page - 1) * per_page);\n }\n }\n}\n\n/**\n* Find a member\n*/\nfunction find_username(url)\n{\n popup(url, 760, 570, \'_usersearch\');\n return false;\n}\n\n/**\n* Mark/unmark checklist\n* id = ID of parent container, name = name prefix, state = state [true/false]\n*/\nfunction marklist(id, name, state)\n{\n var parent = document.getElementById(id);\n if (!parent)\n {\n eval(\'parent = document.\' + id);\n }\n\n if (!parent)\n {\n return;\n }\n\n var rb = parent.getElementsByTagName(\'input\');\n \n for (var r = 0; r < rb.length; r++)\n {\n if (rb[r].name.substr(0, name.length) == name)\n {\n rb[r].checked = state;\n }\n }\n}\n\n/**\n* Updated Checked imagae Mark/unmark checklist\n* id = ID of parent container, name = name prefix, state = state [true/false]\n*/\nfunction updateCheckImage() {\n \n //get all the input fields on the page\n inputs = document.getElementsByTagName(\'input\');\n \n //cycle trough the input fields\n for(var i=0; i < inputs.length; i++) {\n \n //check if the input is a checkbox\n if(inputs[i].getAttribute(\'type\') == \'checkbox\') { \n \n //get image\n var img = document.getElementById(\'checkImage\'+i);\n \n //check if the checkbox is checked\n if(inputs[i].checked) {\n img.src = imgTrue;\n } else {\n img.src = imgFalse;\n }\n }\n }\n}\n<!-- IF ._file -->\n\n /**\n * Play quicktime file by determining it\'s width/height\n * from the displayed rectangle area\n *\n * Only defined if there is a file block present.\n */\n function play_qt_file(obj)\n {\n var rectangle = obj.GetRectangle();\n\n if (rectangle)\n {\n rectangle = rectangle.split(\',\')\n var x1 = parseInt(rectangle[0]);\n var x2 = parseInt(rectangle[2]);\n var y1 = parseInt(rectangle[1]);\n var y2 = parseInt(rectangle[3]);\n\n var width = (x1 < 0) ? (x1 * -1) + x2 : x2 - x1;\n var height = (y1 < 0) ? (y1 * -1) + y2 : y2 - y1;\n }\n else\n {\n var width = 200;\n var height = 0;\n }\n\n obj.width = width;\n obj.height = height + 16;\n\n obj.SetControllerVisible(true);\n\n obj.Play();\n }\n<!-- ENDIF -->\n\n// ]]>\n</script>\n\n<script type=\"text/javascript\">\n// <![CDATA[\n// copyright 1999 Idocs, Inc. http://www.idocs.com/tags/\n// Distribute this script freely, but please keep this\n// notice with the code.\n\nvar rollOverArr=new Array();\nfunction setrollover(OverImgSrc,pageImageName)\n{\nif (! document.images)return;\nif (pageImageName == null)\npageImageName = document.images[document.images.length-1].name;\nrollOverArr[pageImageName]=new Object;\nrollOverArr[pageImageName].overImg = new Image;\nrollOverArr[pageImageName].overImg.src=OverImgSrc;\n}\n\nfunction rollover(pageImageName)\n{\nif (! document.images)return;\nif (! rollOverArr[pageImageName])return;\nif (! rollOverArr[pageImageName].outImg)\n{\nrollOverArr[pageImageName].outImg = new Image;\nrollOverArr[pageImageName].outImg.src = document.images[pageImageName].src;\n}\ndocument.images[pageImageName].src=rollOverArr[pageImageName].overImg.src;\n}\n\nfunction rollout(pageImageName)\n{\nif (! document.images)return;\nif (! rollOverArr[pageImageName])return;\ndocument.images[pageImageName].src=rollOverArr[pageImageName].outImg.src;\n}\n// ]]>\n</script>\n\n <link href=\"{T_THEME_PATH}/images/subMerged.png\" rel=\"shortcut icon\" />\n <script src=\"{T_THEME_PATH}/images/menu/overlib.js\" type=\"text/javascript\"></script>\n <script src=\"{T_TEMPLATE_PATH}/checkbox.js\" type=\"text/javascript\"></script>\n </head>\n\n<body class=\"{S_CONTENT_DIRECTION}\">\n <div id=\"overDiv\" style=\"position:absolute; visibility:hidden; z-index:1000;\"></div>\n <a name=\"top\"></a>\n <!-- Start NavMenu -->\n <div style=\"position:absolute; top:0px; width:100%; left-margin:auto; right-margin:auto;\">\n <center> \n <table align=\"center\" width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n <tr>\n <td align=\"center\" valign=\"top\">\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n <tr>\n <td align=\"right\" valign=\"top\" width=\"106\" height=\"22\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_l.gif\" alt=\"\" height=\"22\" width=\"109\" /></td>\n <!-- IF S_BOARD_DISABLED -->\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_bbdown.gif></td><td valign=middle nowrap>{L_BOARD_DISABLED}\');\" onmouseout=\"return nd();\" href=\"#\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_bbdown.gif\" alt=\"{L_BOARD_DISABLED}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <!-- ENDIF -->\n<td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_portal.gif></td><td valign=middle nowrap>{L_PORTAL}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_PORTAL}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_portal.gif\" alt=\"{L_PORTAL}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_home.gif></td><td valign=middle nowrap>{L_INDEX}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_INDEX}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_home.gif\" alt=\"{L_INDEX}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <!-- IF U_RESTORE_PERMISSIONS -->\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_loginout.gif></td><td valign=middle nowrap>{L_RESTORE_PERMISSIONS}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_RESTORE_PERMISSIONS}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_loginout.gif\" alt=\"{L_RESTORE_PERMISSIONS}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <!-- ENDIF -->\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_faq.gif></td><td valign=middle nowrap>{L_FAQ}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_FAQ}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_faq.gif\" alt=\"{L_FAQ}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <!-- IF S_DISPLAY_SEARCH -->\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_search.gif></td><td valign=middle nowrap>{L_SEARCH}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_SEARCH}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_search.gif\" alt=\"{L_SEARCH}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_unanswered.gif></td><td valign=middle nowrap>{L_SEARCH_UNANSWERED}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_SEARCH_UNANSWERED}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_unanswered.gif\" alt=\"{L_SEARCH_UNANSWERED}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_active.gif></td><td valign=middle nowrap>{L_SEARCH_ACTIVE_TOPICS}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_SEARCH_ACTIVE_TOPICS}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_active.gif\" alt=\"{L_SEARCH_ACTIVE_TOPICS}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <!-- IF S_USER_LOGGED_IN -->\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_postsince.gif></td><td valign=middle nowrap>{L_SEARCH_NEW}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_SEARCH_NEW}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_postsince.gif\" alt=\"{L_SEARCH_NEW}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_userposts.gif></td><td valign=middle nowrap>{L_SEARCH_SELF}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_SEARCH_SELF}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_userposts.gif\" alt=\"{L_SEARCH_SELF}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <!-- ENDIF -->\n <!-- ENDIF -->\n <!-- IF S_DISPLAY_MEMBERLIST -->\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_members.gif></td><td valign=middle nowrap>{L_MEMBERLIST}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_MEMBERLIST}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_members.gif\" alt=\"{L_MEMBERLIST}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <!-- ENDIF -->\n <!-- IF not S_USER_LOGGED_IN -->\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_register.gif></td><td valign=middle nowrap>{L_REGISTER}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_REGISTER}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_register.gif\" alt=\"{L_REGISTER}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <!-- ENDIF -->\n <!-- IF S_USER_LOGGED_IN -->\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_profile.gif></td><td valign=middle nowrap>{L_PROFILE}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_PROFILE}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_profile.gif\" alt=\"{L_PROFILE}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <!-- ENDIF -->\n <!-- IF not S_IS_BOT -->\n <td class=\"header_menu\" height=\"22\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td><img src={T_THEME_PATH}/images/menu/subMenu_loginout.gif></td><td valign=middle nowrap>{L_LOGIN_LOGOUT}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_LOGIN_LOGOUT}\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_loginout.gif\" alt=\"{L_LOGIN_LOGOUT}\" height=\"20\" width=\"38\" border=\"0\" /></a></td>\n <!-- ENDIF -->\n <td align=\"left\" valign=\"top\" width=\"106\" height=\"22\"><img src=\"{T_THEME_PATH}/images/menu/subMenu_r.gif\" alt=\"\" height=\"22\" width=\"109\" /></td>\n </tr>\n </table>\n \n </td>\n </tr>\n </table>\n </center>\n </div>\n <!-- End NavMenu -->\n <table class=\"top\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n <tr>\n <td valign=\"top\" width=\"1%\"><a onmouseover=\"return overlib(\'<table class=overlib_info><tr><td>{L_INDEX}</td></tr></table>\');\" onmouseout=\"return nd();\" href=\"{U_INDEX}\">{SITE_LOGO_IMG}</a></td>\n <td align=\"left\" valign=\"bottom\" width=\"98%\">\n <!-- IF not $S_IN_INDEX -->\n<!-- IF not $S_IN_PORTAL or not S_DISPLAY_MAINMENU -->\n <!-- INCLUDE breadcrumbs.html -->\n<!-- ENDIF -->\n <!-- ENDIF -->\n <!-- Start Site Title -->\n <div style=\"position:absolute;right:90px;top:28px;z-index:1;\">\n <table width=\"300\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n <tr>\n <td align=\"right\" class=\"sitetitle\" nowrap=\"nowrap\">{SITENAME}</td>\n </tr>\n <tr>\n <td align=\"right\" class=\"sitedescription\">{SITE_DESCRIPTION}</td>\n </tr>\n </table>\n </div>\n <!-- End Site Title --></td>\n <td valign=\"top\" width=\"1%\"><img src=\"{T_THEME_PATH}/images/top_sub.gif\" alt=\"\" height=\"80\" width=\"96\" /></td>\n </tr>\n </table>\n<!-- IF not $S_IN_PORTAL or not S_DISPLAY_MAINMENU -->\n <table class=\"center\" width=\"99%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n <tr>\n <td class=\"left_spacing\" width=\"1%\"></td>\n <td align=\"center\" valign=\"top\" width=\"99%\">\n<!-- ENDIF -->' WHERE template_id = 3 AND template_filename = 'overall_header.html'FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/acp/acp_styles.php
LINE: 2581
CALL: dbal_mysql->sql_query()
FILE: includes/acp/acp_styles.php
LINE: 287
CALL: acp_styles->store_templates()
FILE: includes/functions_module.php
LINE: 507
CALL: acp_styles->main()
FILE: adm/index.php
LINE: 75
CALL: p_master->load_active()
---------------------------
Zu den Angaben zu meinem Board:
Adresse: http://forum.whitesun-portal.de
PHP Version (Server): 5.2.0-8+etch13
My SQL Version (Server): MySQL 5.0.32-Debian_7etch6
phpBB Version: 3.0.5
Verwendeter Style: Submerge
Installierte Mods: board3portal_1_0_3
Woran liegt das? Wie kann ich das wieder beheben? Welche Änderungen müssen vorgenommen werden? Bitte um eure Hilfe.
Solltet ihr noch weitere Angaben benötigen, sagt mir bitte bescheid.
Soweit erstmal und danke schonmal für eure Hilfe,
Gruß WhiteSun
........ 3870 Jahren (oder so ähnlich...) 
