Allgemeiner Fehler SQL ERROR [ mysqli ]

Fragen zur Bedienung von phpBB 3.0.x, Probleme bei der Benutzung und alle weiteren Fragen inkl. Update auf die neuste phpBB 3.0.14 Version
Forumsregeln
phpBB 3.0 hat das Ende seiner Lebenszeit überschritten
phpBB 3.0 wird nicht mehr aktiv unterstützt. Insbesondere werden - auch bei Sicherheitslücken - keine Patches mehr bereitgestellt. Der Einsatz von phpBB 3.0 erfolgt daher auf eigene Gefahr. Wir empfehlen einen Umstieg auf die neuste phpBB-Version, welches aktiv weiterentwickelt wird und für welches regelmäßig Updates zur Verfügung gestellt werden.
Antworten
electrohunter
Mitglied
Beiträge: 83
Registriert: 31.08.2011 00:48

Allgemeiner Fehler SQL ERROR [ mysqli ]

Beitrag von electrohunter »

Hallo,

nachdem ich eben die Datei "imageset.cfg" bearbeitet und neu hochgeladen hatte und danach auf Cache leeren gegangen bin, kommt seit dem diese Meldung. Ich kenne mich damit überhaupt nicht aus. Ich benutze phpBB 3.0.9 und als Style Absolution. Wer kann mir helfen, ist sehr dringend, Danke.


Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Incorrect string value: '\xE4ngige...' 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 ('2', 'overall_header.html', '', 1314787457, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">\n\n<html xmlns=\"http://www.w3.org/1999/xhtml\" dir=\"{S_CONTENT_DIRECTION}\" lang=\"{S_USER_LANG}\" xml:lang=\"{S_USER_LANG}\">\n\n<head>\n<meta http-equiv=\"content-type\" content=\"text/html; charset=ISO-8859-1\"/>\n<meta http-equiv=\"language\" content=\"de\"/>\n<meta http-equiv=\"content-style-type\" content=\"text/css\"/>\n<meta name=\"robots\" content=\"index, follow\">\n<meta name=\"resource-type\" content=\"document\"/>\n<meta name=\"copyright\" content=\"Copyright 2011 by Waldhof-Board\"/>\n<meta name=\"description\" content=\"Das unabh�ngige SV Waldhof Forum mit aktuellen Nachrichten und Informationen sowie interessanten Diskussionen rund um den SV Waldhof Mannheim 07 e.V.\"/>\n<meta name=\"keywords\" content=\"SV Waldhof, Waldhof Mannheim, SV Waldhof Mannheim, Waldhof, Mannheim, SVW, SV Waldhof Mannheim 07, Pro Waldhof, Waldhof Forum, Fan Forum, Ultras Mannheim, City Boys\"/>\n\n{META} \n\n<title>{SITENAME}</title>\n\n<!-- IF S_ENABLE_FEEDS -->\n\n <link rel=\"alternate\" type=\"application/atom+xml\" title=\"{L_FEED} - {SITENAME}\" href=\"{U_FEED}\" />\n\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\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\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\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\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\n<!-- ENDIF -->\n\n\n\n<!--\n\n phpBB style name: Absolution\n\n Based on style: prosilver (this is the default phpBB3 style)\n\n Original author: Tom Beddard ( http://www.subBlue.com/ )\n\n Modified by: Christian Bullock ( http://www.ChristianBullock.com/ )\n\n\n\n NOTE: This page was generated by phpBB, the free open-source bulletin board package.\n\n The phpBB Group is not responsible for the content of this page and forum. For more information\n\n about phpBB please visit http://www.phpbb.com\n\n \n\n IMPORTANT: Free Forum Hosts and phpBB3 Style Directories are not permitted under ANY circumstances to use this style on their network\n\n without first obtaining permission from the style author.\n\n \n\n This style is only authorised for download from the following sites:\n\n \n\n * http://www.phpBB.com\n\n * http://www.phpbb3styles.net\n\n * http://www.christianbullock.com\n\n * http://www.awesomestyles.com\n\n \n\n If found on any other site, please email: contact@christianbullock.com\n\n-->\n\n\n\n<script type=\"text/javascript\">\n\n// <![CDATA[\n\n var jump_page = \'{LA_JUMP_PAGE}:\';\n\n var on_page = \'{ON_PAGE}\';\n\n var per_page = \'{PER_PAGE}\';\n\n var base_url = \'{A_BASE_URL}\';\n\n var style_cookie = \'phpBBstyle\';\n\n var style_cookie_settings = \'{A_COOKIE_SETTINGS}\';\n\n var onload_functions = new Array();\n\n var onunload_functions = new Array();\n\n\n\n <!-- IF S_USER_PM_POPUP -->\n\n if ({S_NEW_PM})\n\n {\n\n var url = \'{UA_POPUP_PM}\';\n\n window.open(url.replace(/&/g, \'&\'), \'_phpbbprivmsg\', \'height=225,resizable=yes,scrollbars=yes, width=400\');\n\n }\n\n <!-- ENDIF -->\n\n\n\n /**\n\n * Find a member\n\n */\n\n function find_username(url)\n\n {\n\n popup(url, 760, 570, \'_usersearch\');\n\n return false;\n\n }\n\n\n\n /**\n\n * New function for handling multiple calls to window.onload and window.unload by pentapenguin\n\n */\n\n window.onload = function()\n\n {\n\n for (var i = 0; i < onload_functions.length; i++)\n\n {\n\n eval(onload_functions[i]);\n\n }\n\n }\n\n\n\n window.onunload = function()\n\n {\n\n for (var i = 0; i < onunload_functions.length; i++)\n\n {\n\n eval(onunload_functions[i]);\n\n }\n\n }\n\n\n\n// ]]>\n\n</script>\n\n<script type=\"text/javascript\" src=\"{T_TEMPLATE_PATH}/jquery-1.3.2.js\"></script>\n\n<script type=\"text/javascript\" src=\"{T_TEMPLATE_PATH}/collapse.js\"></script>\n\n<script type=\"text/javascript\" src=\"{T_TEMPLATE_PATH}/styleswitcher.js\"></script>\n\n<script type=\"text/javascript\" src=\"{T_TEMPLATE_PATH}/forum_fn.js\"></script>\n\n\n\n<link href=\"{T_THEME_PATH}/print.css\" rel=\"stylesheet\" type=\"text/css\" media=\"print\" title=\"printonly\" />\n\n<link href=\"{T_STYLESHEET_LINK}\" rel=\"stylesheet\" type=\"text/css\" media=\"screen, projection\" />\n\n\n\n<link href=\"{T_THEME_PATH}/normal.css\" rel=\"stylesheet\" type=\"text/css\" title=\"A\" />\n\n<link href=\"{T_THEME_PATH}/medium.css\" rel=\"alternate stylesheet\" type=\"text/css\" title=\"A+\" />\n\n<link href=\"{T_THEME_PATH}/large.css\" rel=\"alternate stylesheet\" type=\"text/css\" title=\"A++\" />\n\n\n\n<!-- IF S_CONTENT_DIRECTION eq \'rtl\' -->\n\n <link href=\"{T_THEME_PATH}/bidi.css\" rel=\"stylesheet\" type=\"text/css\" media=\"screen, projection\" />\n\n<!-- ENDIF -->\n\n<script type=\"text/javascript\" language=\"javascript\" src=\"lytebox/lytebox.js\"></script>\n<link rel=\"stylesheet\" href=\"lytebox/lytebox.css\" type=\"text/css\" media=\"screen\" />\n</head>\n\n\n\n<body id=\"phpbb\" class=\"section-{SCRIPT_NAME} {S_CONTENT_DIRECTION}\">\n\n<p class=\"skiplink\"><a href=\"#start_here\">{L_SKIP}</a></p>\n\n<a id=\"top\" name=\"top\" accesskey=\"t\"></a>\n\n\n\n<div id=\"wrap\">\n\n<div id=\"header\">\n\n\n<div id=\"header-right\">\n\n<div id=\"<!-- IF not S_USER_LOGGED_IN -->formbox<!-- ELSE -->header-search-box<!-- ENDIF -->\">\n\n<!-- IF not S_USER_LOGGED_IN -->\n\n<!-- ENDIF -->\n\n<!-- IF S_USER_LOGGED_IN -->\n\n<!-- IF S_DISPLAY_SEARCH and not S_IN_SEARCH -->\n\n<!-- ENDIF -->\n\n<!-- ENDIF -->\n\n</div><!--/formbox / search-box-->\n\n</div><!--/header-right-->\n\n</div><!-- /header-->\n\n<div class=\"float-left breadcrumbs\"></div><!-- /float-left / breadcrumbs -->\n\n\n\n<div class=\"float-right\">\n\n<!-- IF U_RESTORE_PERMISSIONS --><span class=\"alert\"><img src=\"{T_THEME_PATH}/images/error.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_RESTORE_PERMISSIONS}\">{L_RESTORE_PERMISSIONS}</a></span><!-- IF U_RESTORE_PERMISSIONS and S_BOARD_DISABLED --> &bull; <!-- ENDIF --><!-- ENDIF --> <!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN and (U_MCP or U_ACP) --><span class=\"alert\"><img src=\"{T_THEME_PATH}/images/error.png\" width=\"16\" height=\"16\" alt=\"\" /> {L_INFORMATION}: {L_BOARD_DISABLED}</span><!-- ENDIF --> <span class=\"breadcrumbs\"><img src=\"{T_THEME_PATH}/images/font_add.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"#\" onclick=\"fontsizeup(); return false;\" onkeypress=\"return fontsizeup(event);\" title=\"{L_CHANGE_FONT_SIZE}\">{L_CHANGE_FONT_SIZE}</a> &nbsp;<!-- IF U_EMAIL_TOPIC --><img src=\"{T_THEME_PATH}/images/email_add.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_EMAIL_TOPIC}\" title=\"{L_EMAIL_TOPIC}\">{L_EMAIL_TOPIC}</a> &nbsp;<!-- ENDIF --><!-- IF U_EMAIL_PM --><a href=\"{U_EMAIL_PM}\" title=\"{L_EMAIL_PM}\">{L_EMAIL_PM}</a><!-- ENDIF -->\n\n <!-- IF U_PRINT_TOPIC --><img src=\"{T_THEME_PATH}/images/printer_add.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_PRINT_TOPIC}\" title=\"{L_PRINT_TOPIC}\" accesskey=\"p\">{L_PRINT_TOPIC}</a><!-- ENDIF -->\n\n <!-- IF U_PRINT_PM --><img src=\"{T_THEME_PATH}/images/printer_add.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_PRINT_PM}\" title=\"{L_PRINT_PM}\" accesskey=\"p\">{L_PRINT_PM}</a><!-- ENDIF --></span></div>\n\n \n\n <div class=\"clear-both\" style=\"margin-bottom: 6px;\"></div>\n\n\n\n<div class=\"toolbar\">\n\n\n<div class=\"navigation\">\n<img src=\"{T_THEME_PATH}/images/house.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_INDEX}\" accesskey=\"h\">{L_INDEX}</a><!-- BEGIN navlinks --> <strong>&raquo;</strong> <a href=\"{navlinks.U_VIEW_FORUM}\">{navlinks.FORUM_NAME}</a><!-- END navlinks -->\n</div>\n\n\n<div class=\"float-left\">\n\n</div><!-- /float-left -->\n\n\n\n<div class=\"float-right\">\n\n <img src=\"{T_THEME_PATH}/images/help.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_FAQ}\" title=\"{L_FAQ_EXPLAIN}\">{L_FAQ}</a>\n\n <!-- IF S_DISPLAY_MEMBERLIST --><img src=\"{T_THEME_PATH}/images/group.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_MEMBERLIST}\" title=\"{L_MEMBERLIST_EXPLAIN}\">{L_MEMBERLIST}</a><!-- ENDIF -->\n\n <!-- IF S_DISPLAY_SEARCH and not S_USER_LOGGED_IN --><img src=\"{T_THEME_PATH}/images/magnifier.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_SEARCH}\" title=\"{L_SEARCH}\">{L_SEARCH}</a><!-- ENDIF --> \n\n <!-- IF not S_USER_LOGGED_IN and S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><img src=\"{T_THEME_PATH}/images/add.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_REGISTER}\">{L_REGISTER}</a><!-- ENDIF -->\n\n <!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->\n\n <img src=\"{T_THEME_PATH}/images/user_edit.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_PROFILE}\" title=\"{L_PROFILE}\" accesskey=\"e\">{L_PROFILE}</a>\n\n <!-- IF S_DISPLAY_PM --><img src=\"{T_THEME_PATH}/images/<!-- IF S_USER_NEW_PRIVMSG -->email_open<!-- ELSE -->email<!-- ENDIF -->.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_PRIVATEMSGS}\"><span id=\"msgcount\">{PRIVATE_MESSAGE_INFO}</span></a><!-- ENDIF -->\n\n <!-- IF S_DISPLAY_SEARCH -->&bull; <a href=\"{U_SEARCH_SELF}\">{L_SEARCH_SELF}</a><!-- ENDIF -->\n\n <!-- ENDIF -->\n\n <img src=\"{T_THEME_PATH}/images/<!-- IF not S_USER_LOGGED_IN -->key<!-- ELSE -->disconnect<!-- ENDIF -->.png\" width=\"16\" height=\"16\" alt=\"\" /> <a href=\"{U_LOGIN_LOGOUT}\" title=\"{L_LOGIN_LOGOUT}\" accesskey=\"x\">{L_LOGIN_LOGOUT}</a>\n\n</div><!-- /float-right -->\n\n</div><!-- /toolbar -->\n\n<script type=\"text/javascript\">\n\n var messageCountSpan = document.getElementById(\"msgcount\");\n\n if(messageCountSpan) {\n\n var messageCount = messageCountSpan.innerHTML.substring(8,9);\n\n messageCountSpan.style.color = (messageCount > 0) ? \"#FF0000\" : \"#FFFFFF\";\n\n }\n\n</script>\n\n\n\n\n\n<div class=\"clear-both\"></div>\n\n\n\n <a name=\"start_here\"></a>\n\n <div id=\"page-body\">')

BACKTRACE

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: 376
CALL: template_compile->_tpl_load_file()

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

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

FILE: index.php
LINE: 137
CALL: page_footer()
Kommt dieser Fehler von Hoster oder von phpBB?
Benutzeravatar
Balint
Mitglied
Beiträge: 1815
Registriert: 25.01.2003 21:43
Wohnort: Stuttgart
Kontaktdaten:

Re: Allgemeiner Fehler SQL ERROR [ mysqli ]

Beitrag von Balint »

Hallo,

bitte überprüfe, ob du die Dateien, die du unterhalb des style-Verzeichnisses bearbeitet hast, das richtige Encoding besitzen. Hier im speziellen sieht es nach einer fehlerhaften overall_header.html im templates-Verzeichnis aus.


Viele Grüße,
Bálint
Meine MODs für phpBB 2.x und phpBB 3.x!
Benutzeravatar
Dr.Death
Moderator
Moderator
Beiträge: 17473
Registriert: 23.04.2003 08:22
Wohnort: Xanten
Kontaktdaten:

Re: Allgemeiner Fehler SQL ERROR [ mysqli ]

Beitrag von Dr.Death »

Hi,

wie Balint schon erwähnt: Du hast Umlaute / Sonderzeichen im overall_header.html eingebaut und dann die Datei nicht im UTF8 ohne BOM Format abgespeichert.
Das unabh�ngige SV Waldhof Forum mit aktuellen Nachrichten und Informationen sowie interessanten Diskussionen rund um den SV Waldhof Mannheim 07 e.V
Siehe auch: KB:166
Antworten

Zurück zu „[3.0.x] Administration, Benutzung und Betrieb“