i did that sql query
DELETE FROM `phpbb_styles_template_data` WHERE template_filename='colour_swatch.html'
and guess what the, its all *beep* upp
i get this now ehrn i try do update prosilver template
Code: Select all
General Error
SQL ERROR [ mysql4 ]
Data too long for column 'template_data' at row 1 [1406]
SQL
UPDATE phpbb3_styles_template_data SET template_id = 1, template_filename = 'overall_header.html', template_included = 'confirm_body.html:faq_body.html:index_body.html:login_body.html:login_forum.html:mcp_approve.html:mcp_header.html:mcp_move.html:memberlist_body.html:memberlist_body.html:memberlist_email.html:memberlist_leaders.html:memberlist_view.html:message_body.html:posting_layout.html:report_body.html:search_body.html:search_results.html:ucp_agreement.html:ucp_header.html:ucp_register.html:ucp_remind.html:ucp_resend.html:viewforum_body.html:viewonline_body.html:viewtopic_body.html:portal_body.html:portal_body.html:', template_mtime = 1226098487, template_data = '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\" dir=\"{S_CONTENT_DIRECTION}\" lang=\"{S_USER_LANG}\" xml:lang=\"{S_USER_LANG}\">\n<!-- INCLUDE ads/ads.js -->\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=\"copyright\" content=\"2000, 2002, 2005, 2007 phpBB Group\" />\n<meta name=\"keywords\" content=\"\" />\n<meta name=\"description\" content=\"\" />\n{META}\n<title>{SITENAME} • <!-- IF S_IN_MCP -->{L_MCP} • <!-- ELSEIF S_IN_UCP -->{L_UCP} • <!-- ENDIF -->{PAGE_TITLE}</title>\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 onload_functions = new Array();\n var onunload_functions = new Array();\n\n <!-- IF S_USER_PM_POPUP -->\n if ({S_NEW_PM})\n {\n var url = \'{UA_POPUP_PM}\';\n window.open(url.replace(/&/g, \'&\'), \'_phpbbprivmsg\', \'height=225,resizable=yes,scrollbars=yes, width=400\');\n }\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[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// ]]>\n</script>\n<script type=\"text/javascript\" src=\"{T_TEMPLATE_PATH}/styleswitcher.js\"></script>\n<script type=\"text/javascript\" src=\"{T_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 {ADS_1}\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 style=\"display: none;\"><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=\"post\" 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 <!-- IF not $S_IN_PORTAL or not S_DISPLAY_MAINMENU -->\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_PORTAL}\">{L_PORTAL}</a> »<a href=\"{U_INDEX}\" accesskey=\"h\">{L_INDEX}</a> <!-- BEGIN navlinks --> <strong>‹</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=\"fontsizeup(); return false;\" 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=\"u\">{L_PROFILE}</a>\n <!-- IF S_DISPLAY_PM --> (<a href=\"{U_PRIVATEMSGS}\">{PRIVATE_MESSAGE_INFO}</a>)<!-- ENDIF --> • \n <a href=\"{U_SEARCH_SELF}\">{L_SEARCH_SELF}</a>\n <!-- IF U_RESTORE_PERMISSIONS --> •\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=\"\"><a href=\"http://www.luftvapen.info/Download.php\" target=\"_blank\" class=\"mainmenu\"><img src=\"http://www.luftvapen.info/downloadlogo.gif\" width=\"13\" height=\"14\" border=\"0\" alt=\"{Chatt}\" hspace=\"3\"\n onClick=\"window.open(\'http://www.luftvapen.info/Download.php\', \n \'R�knare\',\'width=900,height=700,status=no,scrollbars=yes,menubar=no,resizable=yes\'); \n return false\">Ladda Hem</a>\n <li class=\"\"><a href=\"http://client11.addonchat.com/sc.php?id=315893\" target=\"_blank\" class=\"mainmenu\"><img src=\"http://www.luftvapen.info/chatt.gif\" width=\"13\" height=\"14\" border=\"0\" alt=\"{Chatt}\" hspace=\"3\"\n onClick=\"window.open(\'http://client11.addonchat.com/sc.php?id=315893\', \n \'R�knare\',\'width=900,height=700,status=no,scrollbars=yes,menubar=no,resizable=yes\'); \n return false\">Chatt</a>\n <li class=\"\"><a href=\"http://luftvapen.shirtcity.com\" target=\"_blank\" class=\"mainmenu\"><img src=\"http://www.luftvapen.info/shoppingCartIcon.gif\" width=\"13\" height=\"14\" border=\"0\" alt=\"{L_FEED}\" hspace=\"3\"\n onClick=\"window.open(\'http://luftvapen.shirtcity.com\', \n \'R�knare\',\'width=900,height=700,status=no,scrollbars=yes,menubar=no,resizable=yes\'); \n return false\">Webbutik</a>\n <li class=\"\"><a href=\"http://www.luftvapen.info/calc.php\" target=\"_blank\" class=\"mainmenu\"><img src=\"http://www.luftvapen.info/calc.gif\" width=\"12\" height=\"13\" border=\"0\" alt=\"{L_FEED}\" hspace=\"3\"\n onClick=\"window.open(\'http://www.luftvapen.info/calc.php\', \n \'R�knare\',\'width=900,height=700,status=no,scrollbars=yes,menubar=no,resizable=yes\'); \n return false\">Omvandlare</a></li>\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 --><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=\"l\">{L_LOGIN_LOGOUT}</a></li>\n <!-- ENDIF -->\n </ul>\n\n <span class=\"corners-bottom\"><span></span></span></div>\n </div>\n<!-- ENDIF -->\n\n </div>\n <!-- IF ADS_2 -->\n <br />\n <div class=\"forabg\">\n <div class=\"inner\"><span class=\"corners-top\"><span></span></span>\n <ul class=\"topiclist\">\n <li class=\"header\">\n <dl class=\"icon\">\n <dt>{L_ADVERTISEMENT}</dt>\n </dl>\n </li>\n </ul>\n <div style=\"padding: 5px 5px 2px 5px; font-size: 1.1em; background-color: #ECF1F3; margin: 0px auto; text-align: center;\">\n {ADS_2}\n </div>\n <span class=\"corners-bottom\"><span></span></span></div>\n </div>\n <!-- ENDIF -->\n <a name=\"start_here\"></a>\n <div id=\"page-body\">\n \n <!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN and (U_MCP or U_ACP) --> \n <div id=\"message\" 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 -->' WHERE template_id = 1 AND template_filename = 'overall_header.html'
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()
FILE: includes/acp/acp_styles.php
LINE: 2474
CALL: dbal_mysql->sql_query()
FILE: includes/acp/acp_styles.php
LINE: 275
CALL: acp_styles->store_templates()
FILE: includes/functions_module.php
LINE: 471
CALL: acp_styles->main()
FILE: adm/index.php
LINE: 75
CALL: p_master->load_active()
Made in Ukraine, exported to the USA 