Error: Could not open prosilver/template/colour_swatch.html

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
j4cKiE
Registered User
Posts: 38
Joined: Tue May 22, 2007 2:14 pm
Location: Germany
Contact:

Error: Could not open prosilver/template/colour_swatch.html

Post by j4cKiE »

Error wrote:Allgemeiner Fehler
Could not open ./../styles/prosilver/template/colour_swatch.html

Bitte informiere die Board-Administration oder den Webmaster: forum@escape-to-space.de
This is the error I get, when I try to refresh the prosilver template. (I'm here: http://www.your_domain.com/phpbb3/adm/index.php?&i=styles&mode=template]

- A 1:1 copy of the board works on my local machine.
- The "colour_swatch.html" exists in phpbb3/adm/style/colour_swatch.html (but NOT in the template folder of prosilver!)
- When I copy this file to the template folder, it works online, too

The cache is deleted. :)

Anyone an idea?

I found this in another thread:
Raimon wrote:DELETE FROM `phpbb_styles_template_data` WHERE template_filename='colour_swatch.html'
Is this the one for me? What exactly happens if I delete this one in my database?

_______________________________________

=> Okay, the sql query fixed it. :)

[20:37:30] [@karlsemple] The problem is related to your board trying to refresh a file into the database which it expects to find because it is in the database cache already but it is not present on the system in the template folder
Image
purusam
Registered User
Posts: 440
Joined: Sat Feb 02, 2008 10:31 pm

Re: Error: Could not open prosilver/template/colour_swatch.html

Post by purusam »

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} &bull; <!-- IF S_IN_MCP -->{L_MCP} &bull; <!-- ELSEIF S_IN_UCP -->{L_UCP} &bull; <!-- 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> &#187;<a href=\"{U_INDEX}\" accesskey=\"h\">{L_INDEX}</a> <!-- BEGIN navlinks --> <strong>&#8249;</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 --> &bull; \n <a href=\"{U_SEARCH_SELF}\">{L_SEARCH_SELF}</a>\n <!-- IF U_RESTORE_PERMISSIONS --> &bull;\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()
Plsss help me out
User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29295
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: Error: Could not open prosilver/template/colour_swatch.html

Post by Marshalrusty »

See if the following query fixes the error:

Code: Select all

ALTER TABLE `phpbb3_styles_template_data` CHANGE `template_data` `template_data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs
purusam
Registered User
Posts: 440
Joined: Sat Feb 02, 2008 10:31 pm

Re: Error: Could not open prosilver/template/colour_swatch.html

Post by purusam »

thanks for the tip but it didnt work out

i get thesame fault when im trying to update

SQL ERROR [ mysql4 ]

Data too long for column 'template_data' at row 1 [1406]

SQL
envirolink
Registered User
Posts: 50
Joined: Mon Jun 09, 2003 3:07 am
Contact:

Re: Error: Could not open prosilver/template/colour_swatch.html

Post by envirolink »

bump... anyone have an answer? I'm getting this too:

Code: Select all

General Error
Could not open ./../styles/subsilver2/template/colour_swatch.html
when I try to refresh the template data.
xdefconx
Registered User
Posts: 23
Joined: Tue Mar 21, 2006 4:56 am
Location: 127.0.0.1
Contact:

Re: Error: Could not open prosilver/template/colour_swatch.html

Post by xdefconx »

j4cKiE wrote:
Error wrote:Allgemeiner Fehler
Could not open ./../styles/prosilver/template/colour_swatch.html

Bitte informiere die Board-Administration oder den Webmaster: forum@escape-to-space.de
This is the error I get, when I try to refresh the prosilver template. (I'm here: http://www.your_domain.com/phpbb3/adm/index.php?&i=styles&mode=template]

- A 1:1 copy of the board works on my local machine.
- The "colour_swatch.html" exists in phpbb3/adm/style/colour_swatch.html (but NOT in the template folder of prosilver!)
- When I copy this file to the template folder, it works online, too
You just save my day, thanxs!
.::[x]:
Locked

Return to “[3.0.x] Support Forum”