Wie der Threadtitel schon beschreibt habe ich eine Error bei meinem Forum ...
Das ganze ist gekommen, nachdem ich an meinem Style irgendetwas bearbeitet habe ... An was genau das liegt, weiss ich auch nicht ...
Denn ich habe jetzt mehr als 3/4 der Template Dateien bearbeitet ...
Nun bekomme ich nach (erfolgreichen ändern) immer wieder eine PHPBB Error beim Cache leeren ...
Fehler:
Allgemeiner Fehler
SQL ERROR [ mysqli ]
Incorrect string value: '\xF6tigt ...' for column 'template_data' at row 1 [1366]
Code: Alles auswählen
INSERT INTO phpbb_styles_template_data (template_id, template_filename, template_included, template_mtime, template_data) VALUES ('5', 'overall_header.html', '', 1266673383, '<!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{SEO_BASE_HREF}\n<!-- INCLUDE ca_config.html -->\n<meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge,chrome=1\" />\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=\"google-site-verification\" content=\"RBfOj6alUIX8qFeQvm5wDseZcmJVvlqhv8BUeDCkqAU\" />\n{META}\n<title>{SITENAME} - <!-- IF S_IN_MCP -->{L_MCP} - <!-- ELSEIF S_IN_UCP -->{L_UCP} - <!-- ENDIF -->{PAGE_TITLE}</title>\n\n<!-- IF S_ENABLE_FEEDS -->\n <link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {SITENAME}\" href=\"{U_FEED}\" />\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_ALL_TOPICS}\" href=\"{U_FEED}?mode=topics\" /><!-- 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<link rel=\"stylesheet\" href=\"{T_STYLESHEET_LINK}\" type=\"text/css\" />\n\n<script type=\"text/javascript\">\n// <![CDATA[\n\n var onload_functions = new Array();\n var onunload_functions = new Array();\n var ca_main_width = \'{$CA_WIDTH}\';\n\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\n// www.phpBB-SEO.com SEO TOOLKIT BEGIN\nfunction jumpto() {\n var page = prompt(\'{LA_JUMP_PAGE}:\', \'{ON_PAGE}\');\n var perpage = \'{PER_PAGE}\';\n var base_url = \'{A_BASE_URL}\';\n var seo_delim_start = \'{SEO_START_DELIM}\';\n var seo_static_pagination = \'{SEO_SATIC_PAGE}\';\n var seo_ext_pagination = \'{SEO_EXT_PAGE}\';\n if (page !== null && !isNaN(page) && page == Math.floor(page) && page > 0) {\n var seo_page = (page - 1) * perpage;\n var anchor = \'\';\n var anchor_parts = base_url.split(\'#\');\n if ( anchor_parts[1] ) {\n base_url = anchor_parts[0];\n anchor = \'#\' + anchor_parts[1];\n }\n if ( base_url.indexOf(\'?\') >= 0 ) {\n document.location.href = base_url.replace(/&/g, \'&\') + \'&start=\' + seo_page + anchor;\n } else if ( seo_page > 0 ) {\n var seo_type1 = base_url.match(/\\.[a-z0-9]+$/i);\n if (seo_type1 !== null) {\n document.location.href = base_url.replace(/\\.[a-z0-9]+$/i, \'\') + seo_delim_start + seo_page + seo_type1 + anchor;\n }\n var seo_type2 = base_url.match(/\\/$/);\n if (seo_type2 !== null) {\n document.location.href = base_url + seo_static_pagination + seo_page + seo_ext_pagination + anchor;\n }\n } else {\n document.location.href = base_url + anchor;\n }\n }\n}\nvar seo_external = {SEO_EXTERNAL};\nvar seo_external_sub = {SEO_EXTERNAL_SUB};\nvar seo_ext_classes = {SEO_EXT_CLASSES};\nvar seo_hashfix = {SEO_HASHFIX};\n/**\n* phpbb_seo_href()\n* Fixes href=\"#something\" links with virtual directories\n* Optionally open external or marked with a css class links in a new window\n* in a XHTML 1.x compliant way.\n*/\nfunction phpbb_seo_href() {\n var current_domain = document.domain.toLowerCase();\n if (!current_domain || !document.getElementsByTagName) return;\n if (seo_external_sub && current_domain.indexOf(\'.\') >= 0) {\n current_domain = current_domain.replace(new RegExp(/^[a-z0-9_-]+\\.([a-z0-9_-]+\\.([a-z]{2,6}|[a-z]{2,3}\\.[a-z]{2,3}))$/i), \'$1\');\n }\n if (seo_ext_classes) {\n var extclass = new RegExp(\"(^|\\s)(\" + seo_ext_classes + \")(\\s|$)\");\n }\n if (seo_hashfix) {\n var basehref = document.getElementsByTagName(\'base\')[0];\n if (basehref) {\n basehref = basehref.href;\n var hashtest = new RegExp(\"^(\" + basehref + \"|)#[a-z0-9_-]+$\");\n var current_href = document.location.href.replace(/#[a-z0-9_-]+$/i, \"\");\n } else {\n seo_hashfix = false;\n }\n }\n var hrefels = document.getElementsByTagName(\"a\");\n var hrefelslen = hrefels.length;\n for (var i = 0; i < hrefelslen; i++) {\n var el = hrefels[i];\n var hrefinner = el.innerHTML.toLowerCase();\n if (el.onclick || (el.href == \'\') || (el.href.indexOf(\'javascript\') >=0 ) || (hrefinner.indexOf(\'<a\') >= 0) ) {\n continue;\n }\n if (seo_hashfix && el.hash && hashtest.test(el.href)) {\n el.href = current_href + el.hash;\n }\n if (seo_external) {\n if ((el.href.indexOf(current_domain) >= 0) && !(seo_ext_classes && extclass.test(el.className))) {\n continue;\n }\n el.onclick = function () { window.open(this.href); return false; };\n }\n }\n}\nwindow.onload = function() {\n if (seo_external || seo_hashfix) {\n phpbb_seo_href();\n }\n // here you can add other window.onload events\n}\n// www.phpBB-SEO.com SEO TOOLKIT END\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<!-- 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 * 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[i]);\n }\n }\n\n window.onunload = function()\n {\n for (var i = 0; i < onunload_functions.length; i++)\n {\n eval(onunload_functions[i]);\n }\n }\n\n\nif(navigator.userAgent && navigator.userAgent.indexOf(\'Mac OS X\') > 0)\n{\n document.write(\'<link rel=\"stylesheet\" href=\"{T_THEME_PATH}/mac.css\" type=\"text/css\" />\');\n}\n\n// ]]>\n</script>\n<script type=\"text/javascript\" src=\"{T_TEMPLATE_PATH}/ca_scripts.js\"></script>\n<script type=\"text/javascript\" src=\"{T_TEMPLATE_PATH}/grey_out.js\"></script>\n<script type=\"text/javascript\">\n// <![CDATA[\nfunction logout_confirmation()\n{\n grayOut(true);\n if (confirm(\'{L_LOGOUT_CONFIRMATION}\'))\n {\n grayOut(false);\n return true;\n }\n else\n {\n grayOut(false);\n return false;\n }\n}\n// ]]>\n</script>\n<script language=\"JavaScript\" type=\"text/javascript\">\n<!--\n function getCookieVal (offset) {\n var endstr = document.cookie.indexOf (\";\", offset);\n if (endstr == -1)\n endstr = document.cookie.length;\n return unescape(document.cookie.substring(offset, endstr));\n }\n function getCookie (name) {\n var arg = name + \"=\";\n var alen = arg.length;\n var clen = document.cookie.length;\n var i = 0;\n while (i < clen) {\n var j = i + alen;\n if (document.cookie.substring(i, j) == arg)\n return getCookieVal (j);\n i = document.cookie.indexOf(\" \", i) + 1;\n if (i == 0) break;\n }\n return null;\n }\nfunction einblenden(div) {\n with(document.getElementById(div).style){\n if(display==\"none\"){\n display=\"\";\n document.cookie=\"display_\"+div+\"=\";\n }\n else{\n display=\"none\";\n document.cookie=\"display_\"+div+\"=none\";\n }\n }\n}\nfunction cookieEinblenden(div){\ndocument.getElementById(div).style.display = getCookie(\"display_\"+div);\n}\n//-->\n</script>\n<script type=\"text/javascript\" src=\"{T_TEMPLATE_PATH}/jquery.js\"></script>\n<script type=\"text/javascript\" src=\"{T_TEMPLATE_PATH}/interface.js\"></script>\n<!--[if lt IE 7]>\n <style type=\"text/css\">\n .dock img { behavior: url({T_DOCK_IMAGES_PATH}iepngfix.htc) }\n </style>\n<![endif]-->\n<!-- IF BUMP_WARNING-->\n <link rel=\"stylesheet\" href=\"{T_THEME_PATH}/bump_warning.css\" type=\"text/css\" />\n<!-- ENDIF -->\n\n</head>\n<body class=\"{S_CONTENT_DIRECTION}\">\n<!-- IF BUMP_WARNING-->\n <div id=\"bump_warning\">{BUMP_WARNING}</div>\n<!-- ENDIF -->\n\n<a name=\"top\"></a>\n<!-- INCLUDE sidebar_body.html -->\n<div id=\"logo-row\">\n <div id=\"logo-left\">\n <div id=\"logo-right\">\n <!-- IF not S_IS_BOT -->\n <!-- IF S_USER_LOGGED_IN -->\n <div id=\"logo-registered\">\n <!-- IF S_DISPLAY_PM -->\n <a href=\"{U_PRIVATEMSGS}\">{PRIVATE_MESSAGE_INFO}<!-- IF PRIVATE_MESSAGE_INFO_UNREAD -->, {PRIVATE_MESSAGE_INFO_UNREAD}<!-- ENDIF --></a><br />\n <!-- ENDIF -->\n {LAST_VISIT_DATE}<br />\n {CURRENT_TIME}\n </div>\n <!-- ELSE -->\n <!-- IF S_LOGIN_ACTION -->\n <div id=\"logo-login\">\n <form method=\"post\" action=\"{S_LOGIN_ACTION}\">\n <input class=\"post\" type=\"text\" name=\"username\" size=\"7\" title=\"{LA_USERNAME}\" <!-- IF LOGIN_ERROR -->disabled=\"disabled\"<!-- ENDIF -->/> <input class=\"post\" type=\"password\" name=\"password\" size=\"7\" title=\"{LA_PASSWORD}\" <!-- IF LOGIN_ERROR -->disabled=\"disabled\"<!-- ENDIF -->/><br />\n <!-- IF S_AUTOLOGIN_ENABLED --><input type=\"checkbox\" class=\"radio\" name=\"autologin\" title=\"{LA_LOG_ME_IN}\" <!-- IF LOGIN_ERROR -->disabled=\"disabled\"<!-- ENDIF -->/> <!-- ENDIF --> <input type=\"submit\" class=\"btnmain\" name=\"login\" value=\"{L_LOGIN}\" <!-- IF LOGIN_ERROR -->disabled=\"disabled\"<!-- ENDIF -->/>\n {S_FORM_TOKEN}\n </form>\n </div>\n <!-- ENDIF -->\n <!-- ENDIF -->\n <!-- ENDIF -->\n <a href=\"{U_INDEX}\">{SITE_LOGO_IMG}</a>\n <div id=\"logo-clear\"></div>\n </div>\n </div>\n</div>\n<div class=\"navrow\">\n <a href=\"#\" onclick=\"window.open("http://bngames.net/Nico/lcut2.php?url="+encodeURIComponent(location.href)+"&title="+encodeURIComponent(document.title), "_blank");\" title=\"Aktuelle URL mit lcut.tk snippen (Ben�tigt Javascript!)\">Snip URL</a> • \n <!-- IF not S_IS_BOT -->\n <!-- IF S_USER_LOGGED_IN --><a href=\"{U_PROFILE}\">{L_PROFILE}</a> • <!-- ENDIF -->\n <!-- IF S_USER_LOGGED_IN -->\n <!-- IF S_DISPLAY_PM --><a href=\"{U_PRIVATEMSGS}\">{L_PRIVATE_MESSAGES}</a> • <!-- ENDIF -->\n <!-- ELSEIF S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><a href=\"{U_REGISTER}\">{L_REGISTER}</a> • <!-- ENDIF -->\n <!-- ENDIF -->\n <!-- IF U_RESTORE_PERMISSIONS --><a href=\"{U_RESTORE_PERMISSIONS}\">{L_RESTORE_PERMISSIONS}</a> • <!-- ENDIF -->\n <!-- Start Ultimate Points -->\n <!-- IF S_POINTS_ENABLE --> \n <a href=\"{U_POINTS}\">{POINTS_LINK}</a><!-- IF S_USER_LOGGED_IN and S_USE_POINTS -->[ {USER_POINTS} ]<!-- ENDIF --> • \n <!-- ENDIF --> \n <!-- End Ultimate Points -->\n <a href=\"{U_FAQ}\">{L_FAQ}</a>\n <!-- IF S_DISPLAY_SEARCH --> • <a href=\"{U_SEARCH}\">{L_SEARCH}</a><!-- ENDIF -->\n <!-- IF not S_IS_BOT -->\n <!-- IF S_DISPLAY_MEMBERLIST --> • <a href=\"{U_MEMBERLIST}\">{L_MEMBERLIST}</a><!-- ENDIF -->\n <!-- ENDIF -->\n <!-- IF not S_IS_BOT --> • <a href=\"{U_LOGIN_LOGOUT}\"<!-- IF S_USER_LOGGED_IN --> onclick=\"return logout_confirmation();\"<!-- ENDIF -->>{L_LOGIN_LOGOUT}</a><!-- ENDIF -->\n</div>\n<div id=\"content\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"{$CA_WIDTH}\" id=\"maintable\" align=\"center\">\n<tr>\n <td id=\"contentrow\">\n\n<!-- IF not S_IS_BOT && not $CA_SKIP_PM_NOTIFY && S_USER_LOGGED_IN && S_DISPLAY_PM -->\n <!-- IF S_USER_NEW_PRIVMSG -->\n <div class=\"pm-notify-new\"><div class=\"pm-notify-header\">{L_PRIVATE_MESSAGES}</div><a href=\"{U_PRIVATEMSGS}\">{PRIVATE_MESSAGE_INFO}<!-- IF PRIVATE_MESSAGE_INFO_UNREAD -->, {PRIVATE_MESSAGE_INFO_UNREAD}<!-- ENDIF --></a></div>\n <!-- ELSEIF S_USER_UNREAD_PRIVMSG -->\n <div class=\"pm-notify-unread\"><div class=\"pm-notify-header\">{L_PRIVATE_MESSAGES}</div><a href=\"{U_PRIVATEMSGS}\">{PRIVATE_MESSAGE_INFO}<!-- IF PRIVATE_MESSAGE_INFO_UNREAD -->, {PRIVATE_MESSAGE_INFO_UNREAD}<!-- ENDIF --></a></div>\n <!-- ENDIF -->\n<!-- ENDIF --> \n\n<!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN and (U_MCP or U_ACP) -->\n <div class=\"pm-notify-new\"><div class=\"pm-notify-header\">{L_INFORMATION}</div>{L_BOARD_DISABLED}</div>\n<!-- ENDIF -->\n\n <!-- IF S_DISPLAY_SEARCH -->\n <p class=\"searchbar\">\n <span style=\"float: {S_CONTENT_FLOW_BEGIN};\"><a href=\"{U_SEARCH_UNANSWERED}\">{L_SEARCH_UNANSWERED}</a> | <a href=\"{U_SEARCH_ACTIVE_TOPICS}\">{L_SEARCH_ACTIVE_TOPICS}</a></span>\n <!-- IF S_USER_LOGGED_IN -->\n <span style=\"float: {S_CONTENT_FLOW_END};\"><a href=\"{U_SEARCH_UNREAD}\">{L_SEARCH_UNREAD}</a> | <a href=\"{U_SEARCH_NEW}\">{L_SEARCH_NEW}</a> | <a href=\"{U_SEARCH_SELF}\">{L_SEARCH_SELF}</a></span>\n <!-- ELSE -->\n <span style=\"float: {S_CONTENT_FLOW_END};\">{CURRENT_TIME}</span>\n <!-- ENDIF -->\n </p>\n <!-- ENDIF -->\n <noscript style=\"font-size:1.1em;\">\n <br style=\"clear: both;\" />\n Um dieses Forum und die darin enthaltenen Funktonen nutzen zu können, benötigst du JavaScript welches du <a href=\"http://www.java.com/de/download/\" target=\"_blank\" title=\"JavaScript herunterladen\">Hier</a> herunterladen kannst!\n </noscript>\n <br style=\"clear: both;\" />\n <!-- INCLUDE breadcrumbs.html -->\n\n <br />\n <!-- IF S_CUSTOM_CENTER -->\n <!-- INCLUDE portal/block/custom_center.html -->\n <br />\n <!-- ENDIF -->\n<!-- INCLUDE portal/portal_header.html -->')FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/functions_template.php
LINE: 85
CALL: dbal_mysqli->sql_query()
FILE: includes/template.php
LINE: 370
CALL: template_compile->_tpl_load_file()
FILE: includes/template.php
LINE: 639
CALL: template->_tpl_load()
FILE: includes/functions_template.php
LINE: 227
CALL: template->_tpl_include()
FILE: includes/template.php
LINE: 385
CALL: template_compile->compile()
FILE: includes/template.php
LINE: 212
CALL: template->_tpl_load()
FILE: includes/functions.php
LINE: 4434
CALL: template->display()
FILE: portal.php
LINE: 270
CALL: page_footer()
Kann mir da _BITTE_ jemand helfen ?
Danke!
L.G. PCFreund
