Template modify error

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
Santiago Munez 26
Registered User
Posts: 65
Joined: Tue Jul 26, 2011 11:59 pm

Template modify error

Post by Santiago Munez 26 »

I get this error when I try to modify my forum's template:
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\">&nbsp;</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()
How I can resolve without the re-installation of the theme?
Is it possibile or I have to reinstall the theme and lose all the changes?

Thanks in advance.
User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Template modify error

Post by Oyabun1 »

Please fill out the Support Request Template and post it back here to enable us to assist you better. Also, please explain how you modified the "forum's template" and which template(s) you modified.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests
Santiago Munez 26
Registered User
Posts: 65
Joined: Tue Jul 26, 2011 11:59 pm

Re: Template modify error

Post by Santiago Munez 26 »

Oyabun1 wrote:Please fill out the Support Request Template and post it back here to enable us to assist you better. Also, please explain how you modified the "forum's template" and which template(s) you modified.
My theme is my_clearblue.
I insert some mods and they work correctly, but I don't know what is the cause of this problem...this error appears when I try to modify something in my theme's template...for an example if I want insert something in overall_header...
User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Template modify error

Post by Oyabun1 »

Santiago Munez 26 wrote:... this error appears when I try to modify something .. .for an example if I want insert something in overall_header
Then you're doing "something" wrong.

Without giving the information asked for how do you expect us to help? "modify something" and "insert something" really tell us nothing. And again, please fill out the Support Request Template and post it back here to enable us to assist you better.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52143
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Template modify error

Post by Brf »

I can see it right here:

Code: Select all

 <a href=�{forumrow.U_LAST_POST}�>{
It looks like you are trying to put in some sort of quotes, rather than apostrophes.

Yes. x94 is when you should be using "
Santiago Munez 26
Registered User
Posts: 65
Joined: Tue Jul 26, 2011 11:59 pm

Re: Template modify error

Post by Santiago Munez 26 »

Oyabun1 wrote:
Santiago Munez 26 wrote:... this error appears when I try to modify something .. .for an example if I want insert something in overall_header
Then you're doing "something" wrong.

Without giving the information asked for how do you expect us to help? "modify something" and "insert something" really tell us nothing. And again, please fill out the Support Request Template and post it back here to enable us to assist you better.
Oh sorry. For "something" I mean a modify in the code, like the insert of a banner or similar...
Brf wrote:I can see it right here:

Code: Select all

 <a href=�{forumrow.U_LAST_POST}�>{
It looks like you are trying to put in some sort of quotes, rather than apostrophes.

Yes. x94 is when you should be using "
Mmm...how I can solve?
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52143
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Template modify error

Post by Brf »

Use a plain-text editor to edit phpBB files, not whatever word-processor program you are using now.
We recommend Notepad++
Santiago Munez 26
Registered User
Posts: 65
Joined: Tue Jul 26, 2011 11:59 pm

Re: Template modify error

Post by Santiago Munez 26 »

Brf wrote:Use a plain-text editor to edit phpBB files, not whatever word-processor program you are using now.
We recommend Notepad++
Yes...and with the Notepad, how I can correct this problem?
What I have to edit?
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52143
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Template modify error

Post by Brf »

You need to edit the line I indicated and replace the pretty-quotes with the quotes on your keyboard next to the Enter key.
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51600
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Template modify error

Post by stevemaury »

Santiago Munez 26 wrote:
Yes...and with the Notepad, how I can correct this problem?
What I have to edit?
NOT Notepad - Notepad ++ - they are different.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Santiago Munez 26
Registered User
Posts: 65
Joined: Tue Jul 26, 2011 11:59 pm

Re: Template modify error

Post by Santiago Munez 26 »

Brf wrote:You need to edit the line I indicated and replace the pretty-quotes with the quotes on your keyboard next to the Enter key.
Thanks, It's ok now.
This error was very very hard to correct because was almost invisible to note.
Thanks a lot, you can close this topic. :D
Locked

Return to “[3.0.x] Support Forum”