Template modify error
Posted: Sun Oct 23, 2011 9:11 pm
I get this error when I try to modify my forum's template:
Is it possibile or I have to reinstall the theme and lose all the changes?
Thanks in advance.
How I can resolve without the re-installation of the theme?SQL ERROR [ mysqli ]
Incorrect string value: '\x94{foru...' for column 'template_data' at row 1 [1366]
SQL
INSERT INTO phpbb2_styles_template_data (template_id, template_filename, template_included, template_mtime, template_data) VALUES (7, 'forumlist_body.html', 'viewforum_body.html:index_body.html:', 1311778955, '<!-- BEGIN forumrow -->\n <!-- IF (forumrow.S_IS_CAT and not forumrow.S_FIRST_ROW) or forumrow.S_NO_CAT -->\n </tbody>\n </table>\n </div>\n <!-- ENDIF -->\n\n <!-- IF forumrow.S_IS_CAT or forumrow.S_FIRST_ROW or forumrow.S_NO_CAT -->\n <div class=\"forums-wrapper\">\n <table class=\"forums\">\n <thead>\n <tr>\n <th colspan=\"2\"><!-- IF forumrow.S_IS_CAT --><a href=\"{forumrow.U_VIEWFORUM}\">{forumrow.FORUM_NAME}</a><!-- ELSE -->{L_FORUM}<!-- ENDIF --></th>\n <th class=\"statistics\">{L_STATISTICS}</th>\n <th class=\"last-post\">{L_LAST_POST}</th>\n </tr>\n </thead>\n <tbody>\n <!-- ENDIF -->\n\n <!-- IF not forumrow.S_IS_CAT -->\n <tr class=\"<!-- IF forumrow.S_ROW_COUNT is odd -->bg1<!-- ELSE -->bg2<!-- ENDIF -->\">\n <td class=\"icon bg2\" style=\"background-image: url({forumrow.FORUM_FOLDER_IMG_SRC});\">\n <!-- IF forumrow.FORUM_IMAGE -->{forumrow.FORUM_IMAGE}<!-- ENDIF -->\n </td>\n <td class=\"forum\">\n <!-- IF S_ENABLE_FEEDS and forumrow.S_FEED_ENABLED --><!--<a class=\"feed-icon-forum\" title=\"{L_FEED} - {forumrow.FORUM_NAME}\" href=\"{U_FEED}?f={forumrow.FORUM_ID}\"><img src=\"{T_THEME_PATH}/images/feed.gif\" alt=\"{L_FEED} - {forumrow.FORUM_NAME}\" /></a>--><!-- ENDIF -->\n <h4><a href=\"{forumrow.U_VIEWFORUM}\" class=\"forumtitle\">{forumrow.FORUM_NAME}</a> <!-- IF forumrow.U_UNAPPROVED_TOPICS --><a href=\"{forumrow.U_UNAPPROVED_TOPICS}\">{UNAPPROVED_IMG}</a><!-- ENDIF --></h4>\n <p>{forumrow.FORUM_DESC}</p>\n <!-- IF forumrow.SUBFORUMS and forumrow.S_LIST_SUBFORUMS --><p><strong>{forumrow.L_SUBFORUM_STR}</strong> {forumrow.SUBFORUMS}</p><!-- ENDIF -->\n <!-- IF forumrow.MODERATORS --><p><strong>{forumrow.L_MODERATOR_STR}:</strong> {forumrow.MODERATORS}</p><!-- ENDIF -->\n </td>\n <!-- IF forumrow.S_IS_LINK and not forumrow.CLICKS --><td colspan=\"2\"> </td><!-- ENDIF -->\n <!-- IF forumrow.CLICKS -->\n <td colspan=\"2\"><p>{L_REDIRECTS}: <strong>{forumrow.CLICKS}</strong></p></td>\n <!-- ELSEIF not forumrow.S_IS_LINK -->\n <td class=\"bg2\">\n <p>{L_TOPICS}: <strong>{forumrow.TOPICS}</strong></p>\n <p>{L_POSTS}: <strong>{forumrow.POSTS}</strong></p>\n </td>\n <td>\n <!-- IF forumrow.LAST_POST_TIME -->\n <p>{forumrow.LAST_POST_TIME}</p>\n In: <a href=�{forumrow.U_LAST_POST}�>{forumrow.FORUM_NAME}</a>\n<a href=\"{forumrow.U_LAST_POST}\" title=\"{forumrow.LAST_POST_SUBJECT}\">{forumrow.LAST_TOPIC_ICON_IMG}{forumrow.LAST_POST_SUBJECT_SHORT}</a><br>\n <p>{L_POST_BY_AUTHOR} {forumrow.LAST_POSTER_FULL} <!-- IF not S_IS_BOT --><a href=\"{forumrow.U_LAST_POST}\">{LAST_POST_IMG}</a><!-- ENDIF --></p>\n <!-- ELSE -->\n <p>{L_NO_POSTS}</p>\n <!-- ENDIF -->\n </td>\n <!-- ENDIF -->\n </tr>\n <!-- ENDIF -->\n\n <!-- IF forumrow.S_LAST_ROW -->\n </tbody>\n </table>\n </div>\n <!-- ENDIF -->\n<!-- BEGINELSE -->\n <div class=\"panel\">\n <div class=\"inner\"><span class=\"corners-top\"><span></span></span>\n \n <strong>{L_NO_FORUMS}</strong>\n \n <span class=\"corners-bottom\"><span></span></span></div>\n </div>\n<!-- END forumrow -->')
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/acp/acp_styles.php
LINE: 2799
CALL: dbal_mysqli->sql_query()
FILE: includes/acp/acp_styles.php
LINE: 3836
CALL: acp_styles->store_templates()
FILE: includes/acp/acp_styles.php
LINE: 3803
CALL: acp_styles->_store_in_db()
FILE: includes/acp/acp_styles.php
LINE: 775
CALL: acp_styles->store_in_db()
FILE: includes/acp/acp_styles.php
LINE: 180
CALL: acp_styles->edit_template()
FILE: includes/functions_module.php
LINE: 507
CALL: acp_styles->main()
FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Is it possibile or I have to reinstall the theme and lose all the changes?
Thanks in advance.