Board Crashed

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
dahubbpostal
Registered User
Posts: 4
Joined: Tue Oct 12, 2010 10:38 pm

Board Crashed

Post by dahubbpostal » Tue May 03, 2011 6:40 am

Support Request Template
What version of phpBB are you using? phpBB 3.0.8
What is your board's URL? http://www.stampboards.com
Who do you host your board with? unknown
How did you install your board? Someone else installed my board for me
Is your board a fresh install or a conversion? Update from a previous version of phpBB3
Do you have any MODs installed? No
Is registration required to reproduce this issue? No
What version of phpBB3 did you update from? phpBB 3.0.7
What styles do you currently have installed? subsilver2
What language(s) is your board currently using? english
Which database type/version are you using? I Don't Know
What is your level of experience? New to PHP and phpBB
When did your problem begin? 18 hours ago
Please describe your problem. first the board did not show & the error
./cache/ is NOT writable.
appeared.

Then board became visible but no avatars were visible.
The ACP log showed multiple activity
Refreshed ???en??? localisation of imageset
?? subsilver2
a search of the forum suggested to refresh the cache twice, which was done.

Now we are unable to get past the front page & the following error appears.
(Pasted at the End of this..

We can access the ACP and currently have the board turned to Maintenance mode

Error Message Follows.

Return to the index page
General Error
SQL ERROR [ mysql4 ]

Incorrect string value: '\x92s lea...' 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', '', 1304404687, '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//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-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=\"2000, 2002, 2005, 2007 phpBB Group\" />\n<meta name=\"keywords\" content=\"{Philatelic, Stamp Collector, Stamp Album, Philately, Perforation, Tete Beche, Revenue Stamps, Postal Fiscal, Penny Black, Harbour Bridge, Kangaroo, Roo, QV, KEVII, KGV, KGVI, QEII, Kangaroo Stamps, Kangaroo Monograms, KGV Heads, KGV stamps, KGV Varieties, Duty Stamps, Papua Lakatois, Engraved Stamps, perfin, precancel, postmark, PNC, FDC, FFC, selvedge , selvage, thematic, stamp collecting, stamp collector, stamp collection, philately, aerophilately, atelophilately, postal history, penny black, penny red, tuppeny blue, two penny blue, two pence blue, blue Mauritius, 4c British Guiana, 5 bob bridge}\" />\n<meta name=\"description\" content=\"{World???s leading stamp collecting discussion Bulletin Board. 100,000s of detailed philatelic posts. 10,000s of high-resolution postage stamp images. 1000s of members from over 100 countries. All totally FREE! }\" />\n{META}\n<title>{SITENAME} &bull; <!-- IF S_IN_MCP -->{L_MCP} &bull; <!-- ELSEIF S_IN_UCP -->{L_UCP} &bull; <!-- ENDIF -->{PAGE_TITLE}</title>\n\n<link rel=\"stylesheet\" href=\"{T_STYLESHEET_LINK}\" type=\"text/css\" />\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 perpage = \'{PER_PAGE}\';\n var base_url = \'{A_BASE_URL}\';\n\n if (page !== null && !isNaN(page) && page > 0)\n {\n document.location.href = base_url.replace(/&/g, \'&\') + \'&start=\' + ((page - 1) * perpage);\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<!-- 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</head>\n<body class=\"{S_CONTENT_DIRECTION}\">\n\n<a name=\"top\"></a>\n\n<div id=\"wrapheader\">\n\n <div id=\"logodesc\">\n <table width=\"100%\" cellspacing=\"0\">\n <tr>\n <td></font></td>\n <td width=\"25%\"></a>\n <a href=\"http://www.stampboards.com\">\n <img border=\"0\" src=\"http://www.stampboards.com/styles/subsi ... e_logo.gif\" width=\"365\" height=\"168\"></a></td>\n <td width=\"100%\" align=\"center\"><h1>{SITENAME}<br>\n&nbsp;</h1><span class=\"gen\">{SITE_DESCRIPTION}<br>\n &nbsp;</span><p style=\"text-align: center;\" class=\"ecxMsoPlainText\" align=\"center\">\n <b style><u><span style=\"color: rgb(192, 0, 0); font-size: 16pt;\">\n ZERO</span></u><span style=\"color: rgb(192, 0, 0); font-size: 16pt;\"> \n cost to <u>ANYONE</u>&nbsp; -&nbsp; <u>NO</u> annoying ads everywhere!</span></b></p>\n <p><span class=\"gen\"><span lang=\"en-au\"><font size=\"1\">A powerful \n Google Custom Search Engine for JUST This Site<br>\n </p>\n<div id=\"cse\" style=\"width: 100%;\">Loading</div>\n<script src=\"http://www.google.com/jsapi\" type=\"text/javascript\"></script>\n<script type=\"text/javascript\">\n google.load(\'search\', \'1\', {language : \'en\', style : google.loader.themes.SHINY});\n google.setOnLoadCallback(function() {\n var customSearchControl = new google.search.CustomSearchControl(\'006549082864398933475:1qgwuutrdgq\');\n customSearchControl.setResultSetSize(google.search.Search.FILTERED_CSE_RESULTSET);\n customSearchControl.draw(\'cse\');\n }, true);\n </script>\n\n<style type=\"text/css\">\n .gsc-control-cse {\n font-family: Verdana, sans-serif;\n border-color: #DAE0E5;\n background-color: #DAE0E5;\n }\n input.gsc-input {\n border-color: #8A99A6;\n }\n input.gsc-search-button {\n border-color: #8A99A6;\n background-color: #D0D1D4;\n }\n .gsc-tabHeader.gsc-tabhInactive {\n border-color: #B2BDC6;\n background-color: #B2BDC6;\n }\n .gsc-tabHeader.gsc-tabhActive {\n border-color: #8A99A6;\n background-color: #8A99A6;\n }\n .gsc-tabsArea {\n border-color: #8A99A6;\n }\n .gsc-webResult.gsc-result {\n border-color: #ccccff;\n background-color: #ccccff;\n }\n .gsc-webResult.gsc-result:hover {\n border-color: #D2D6DC;\n background-color: #EDEDED;\n }\n .gs-webResult.gs-result a.gs-title:link,\n .gs-webResult.gs-result a.gs-title:link b {\n color: #0568CD;\n }\n .gs-webResult.gs-result a.gs-title:visited,\n .gs-webResult.gs-result a.gs-title:visited b {\n color: #0568CD;\n }\n .gs-webResult.gs-result a.gs-title:hover,\n .gs-webResult.gs-result a.gs-title:hover b {\n color: #0568CD;\n }\n .gs-webResult.gs-result a.gs-title:active,\n .gs-webResult.gs-result a.gs-title:active b {\n color: #0568CD;\n }\n .gsc-cursor-page {\n color: #0568CD;\n }\n a.gsc-trailing-more-results:link {\n color: #0568CD;\n }\n .gs-webResult.gs-result .gs-snippet {\n color: #5F6A73;\n }\n .gs-webResult.gs-result .gs-visibleUrl {\n color: #5F6A73;\n }\n .gs-webResult.gs-result .gs-visibleUrl-short {\n color: #5F6A73;\n }\n \n .gs-webResult.gs-result .gs-visibleUrl-short {\n display: none;\n }\n .gs-webResult.gs-result .gs-visibleUrl-long {\n display: block;\n }\n .gsc-cursor-box {\n border-color: #ccccff;\n }\n .gsc-results .gsc-cursor-page {\n border-color: #B2BDC6;\n background-color: #ccccff;\n }\n .gsc-results .gsc-cursor-page.gsc-cursor-current-page {\n border-color: #8A99A6;\n background-color: #8A99A6;\n }\n .gs-promotion.gs-result {\n border-color: #D2D6DC;\n background-color: #D0D1D4;\n }\n .gs-promotion.gs-result a.gs-title:link {\n color: #0066CC;\n }\n .gs-promotion.gs-result a.gs-title:visited {\n color: #0066CC;\n }\n .gs-promotion.gs-result a.gs-title:hover {\n color: #0066CC;\n }\n .gs-promotion.gs-result a.gs-title:active {\n color: #0066CC;\n }\n .gs-promotion.gs-result .gs-snippet {\n color: #333333;\n }\n .gs-promotion.gs-result .gs-visibleUrl,\n .gs-promotion.gs-result .gs-visibleUrl-short {\n color: #5F6A73;\n }\n </style>\n</font></span></span></td>\n </tr>\n </table>\n </div>\n\n <div id=\"menubar\">\n <table width=\"1156\" cellspacing=\"0\">\n <tr>\n <td class=\"genmed\" width=\"554\">\n <!-- IF not S_IS_BOT --><a href=\"{U_LOGIN_LOGOUT}\"><img src=\"{T_THEME_PATH}/images/icon_mini_login.gif\" width=\"12\" height=\"13\" alt=\"*\" /> {L_LOGIN_LOGOUT}</a>&nbsp;<!-- ENDIF -->\n <!-- IF U_RESTORE_PERMISSIONS --> &nbsp;<a href=\"{U_RESTORE_PERMISSIONS}\"><img src=\"{T_THEME_PATH}/images/icon_mini_login.gif\" width=\"12\" height=\"13\" alt=\"*\" /> {L_RESTORE_PERMISSIONS}</a><!-- ENDIF -->\n <!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN --> &nbsp;<span style=\"color: red;\">{L_BOARD_DISABLED}</span><!-- ENDIF -->\n <!-- IF not S_IS_BOT -->\n <!-- IF S_USER_LOGGED_IN -->\n <!-- IF S_DISPLAY_PM --> &nbsp;<a href=\"{U_PRIVATEMSGS}\"><img src=\"{T_THEME_PATH}/images/icon_mini_message.gif\" width=\"12\" height=\"13\" alt=\"*\" /> {PRIVATE_MESSAGE_INFO}<!-- IF PRIVATE_MESSAGE_INFO_UNREAD -->, {PRIVATE_MESSAGE_INFO_UNREAD}<!-- ENDIF --></a><!-- ENDIF -->\n <!-- ELSEIF S_REGISTER_ENABLED --> &nbsp;<a href=\"{U_REGISTER}\"><img src=\"{T_THEME_PATH}/images/icon_mini_register.gif\" width=\"12\" height=\"13\" alt=\"*\" /> {L_REGISTER}</a>\n <!-- ENDIF -->\n <!-- ENDIF -->\n </td>\n <td class=\"genmed\" align=\"{S_CONTENT_FLOW_END}\" width=\"598\">\n <p align=\"left\">\n <span class=\"gen\"><span lang=\"en-au\">\n <a href=\"http://www.stampboards.com/viewtopic.ph ... =2556\">\n "The Rules"</a></span></span><b><span lang=\"en-au\"> </span>\n </b>\n <a href=\"{U_FAQ}\"><img src=\"{T_THEME_PATH}/images/icon_mini_faq.gif\" width=\"12\" height=\"13\" alt=\"*\" /> {L_FAQ}</a>\n <!-- IF S_DISPLAY_SEARCH -->&nbsp; &nbsp;<a href=\"{U_SEARCH}\"><img src=\"{T_THEME_PATH}/images/icon_mini_search.gif\" width=\"12\" height=\"13\" alt=\"*\" /> {L_SEARCH}</a><!-- ENDIF -->\n <!-- IF not S_IS_BOT -->\n <!-- IF S_DISPLAY_MEMBERLIST -->&nbsp; &nbsp;<a href=\"{U_MEMBERLIST}\"><img src=\"{T_THEME_PATH}/images/icon_mini_members.gif\" width=\"12\" height=\"13\" alt=\"*\" /> {L_MEMBERLIST}</a><!-- ENDIF -->\n <!-- IF S_USER_LOGGED_IN -->&nbsp; &nbsp;<a href=\"{U_PROFILE}\"><img src=\"{T_THEME_PATH}/images/icon_mini_profile.gif\" width=\"12\" height=\"13\" alt=\"*\" /> {L_PROFILE}</a><!-- ENDIF -->\n <!-- ENDIF -->\n </td>\n </tr>\n </table>\n </div>\n\n <div id=\"datebar\">\n <table width=\"100%\" cellspacing=\"0\">\n <tr>\n <td class=\"gensmall\"><!-- IF S_USER_LOGGED_IN -->{LAST_VISIT_DATE}<!-- ENDIF --></td>\n <td class=\"gensmall\" align=\"{S_CONTENT_FLOW_END}\">{CURRENT_TIME}<br /></td>\n </tr>\n </table>\n </div>\n\n</div>\n\n<div id=\"wrapcentre\">\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_NEW}\">{L_SEARCH_NEW}</a> | <a href=\"{U_SEARCH_SELF}\">{L_SEARCH_SELF}</a></span>\n <!-- ENDIF -->\n </p>\n <!-- ENDIF -->\n\n <br style=\"clear: both;\" />\n\n <!-- INCLUDE breadcrumbs.html -->\n\n <br />')

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: 4619
CALL: template->display()

FILE: viewforum.php
LINE: 704
CALL: page_footer()

Please notify the board administrator or webmaster: admin@stampboards.com
Powered by phpBB ?? 2000, 2002, 2005, 2007 phpBB Group
Generated by SRT Generator ($Rev: 4778 $)

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: Board Crashed

Post by karlsemple » Tue May 03, 2011 6:52 am

first the board did not show & the error
./cache/ is NOT writable.
This first error would have suggested that the folders permissions were not correctly configured, the cache folder needs to be writeable so on a linux based operating system that would mean setting the chmod value to 777. Check the filer and folder permissions are all set correctly on your board s have a read of this KB article we have on the site phpBB3 Chmod Permissions
Incorrect string value: '\x92s lea...' for column 'template_data' at row 1 [1366]
I would suggest you start by installing our Support Toolkit http://www.phpbb.com/support/stk/ and change the boards style back to the default prosilver and then test if that will allow the board to work for you
Image

Locked

Return to “[3.0.x] Support Forum”