Smarty error returned with Search Module

[howey]

Hi

I am getting an error message when the search module returns results. The reslts are the but preceeded by this error message

string(182) "Smarty error: [in module_db_tpl:Search;displayresult line 5]: syntax error: unrecognized tag: $entry-?phpMyAdmin=YnxhOzzcOpU16wQbizEUBDLh9e8>url (Smarty_Compiler.class.php, line 446)" string(133) "Smarty error: [in module_db_tpl:Search;displayresult line 5]: syntax error: unrecognized tag '' (Smarty_Compiler.class.php, line 590)"

Can any body help. I have tried clearing the cache.



Just going through some test moving things around. The search was in a global content block making up a large footer

Code: Select all

<!-- Start of the Search and login Panel -->
<div id="searchPanelWidth">
<div id="searchPanelWidth960">
    <div id="searchPanel">
        <div id="searchFormHolder">
            {search resultpage="search-results"}
        </div>
	<h2>{cms_selflink page='customer-login' text='Customer Login'}</h2>
        <div class="clearfix"> </div>
     </div>
</div>
</div>
<!-- End of the Search and login Panel -->
<!-- Start of Big Footer -->
<div id="breadcrumb"><h3>{breadcrumbs root="s-m-hackett" starttext="You are here"}</h3></div>
<div id="footerHolder">
    <div id="footerMenuHolder">
                <div class="footerMenuBox">
                    {menu template="b-menu" start_element="2" number_of_levels="2"}
		</div>
		<div class="footerMenuBox">
                    {menu template="b-menu" start_element="3" number_of_levels="2"}
		</div>
		<div class="footerMenuBox">
                    {menu template="b-menu" start_element="4" number_of_levels="2"}
		</div>
		<div class="footerMenuBox">
                    {menu template="b-menu" start_element="5" number_of_levels="3"}
		</div>
		<div class="footerMenuBox">
                    {menu template="b-menu" start_element="6" number_of_levels="2"}
		</div>
		<div class="footerMenuBox">
                    {menu template="b-menu" start_element="7" number_of_levels="2"}
		</div>
		<div class="clearfix"> </div>
    </div>
    <div class="clearfix"> </div>
    <div id="footerContact">
         <div id="contactUs"><h3>Contact us</h3></div>
        {cms_module module='FormBuilder' form='contact'}
    </div>
<div class="clearfix"> </div>
</div>
<!-- End of Big Footer -->

<!-- Start address detail and copyright etc -->

<div id="addressPanel">
<p>1 Kilwardby Mews, Kilwardby Street, Ashby-de-la-Zouch<br />
Leicestershire LE65 2FR</p>
{menu items="disclaimer,sitemap,terms,client-login"}
<p class="clearfix"> </p>
</div>

<!-- End address detail and copyright etc -->


{* Start relational links *}
<div id="relationalLinks">
<p>{cms_selflink dir="next" label="Next: "} | {cms_selflink dir="previous" label="Previous: "}</p>
</div>
{* End relational links *}

I separated out the top portion search panel and now I don't get an error returned. However, the links on the search results now default back to the home page.

Ooops, for some reason the errors back and the links on the search results show a blank href (href=" ")

string(182) "Smarty error: [in module_db_tpl:Search;displayresult line 5]: syntax error: unrecognized tag: $entry-?phpMyAdmin=YnxhOzzcOpU16wQbizEUBDLh9e8>url (Smarty_Compiler.class.php, line 446)" string(133) "Smarty error: [in module_db_tpl:Search;displayresult line 5]: syntax error: unrecognized tag '' (Smarty_Compiler.class.php, line 590)"

[Rolf]

Hi Howey

Code: Select all

?phpMyAdmin=YnxhOzzcOpU16wQbizEUBDLh9e8

I think I've seen this before once... 
Did you put back a back-up of your database at some moment?
This code is added somehow to the database and it causing problems here.

It hasn't to do with the Search module.

Regards, Rolf 

[howey]

Hi

The suggestion about the database did cross my mind. I tried going back to a back up database but the problem still occured. Is there anyway of searching the database to find the error/corruption.

I didn't notice the problem until the site was nearly complete - now there's an aweful lot of data to re input if I have to start from scratch.

Any suggestions

Cheers

[Rolf]

Hmm...

"Somebody" could write you a script which changes the code in the database automaticly, but I can't help you with that 

I have never done it myself, but you could try to export the database to Excel or similar and filter the text and delete it.
Import the cleaned database in a test website, and test it before you put it into your life website...

Hope this helps, Rolf 

[howey]

Hi

Thanks for the replies.

I have decided to approach the problem with a clean start. The version of CMSMS I was using needed updating anyway, so I am installing and rebuilding the content from scratch (testing, testing, testing along the way). Hopefully this should give me a nice clean site. I am not confident/knowledgeable enough to clean the existing database.

The only thought I had was that the bug could have been introduced by using phpmyadmin to delete some files that I couldn't get rid of otherwise. I also had to use phpmyadmin to change permissions on files as well.

Here goes a few late nights