error when searching

[davebowker]

anytime i search for something this pops up;

Search results for

SQL/DB Error -- [Unknown column 'link_modified_date' in 'order clause']

SQL/DB Error -- [Unknown column 'link_modified_date' in 'order clause']



not sure whats going on and would appreciate some help


thanks in advance

dave

[kbeeveer46]

In your database under the links table, is there a field called link_modified_date?

[davebowker]

ok. after a chat with kb on the irc, the answer is dont change to much in the search form or it breaks.


from the original code, its safe to delete the following and still keep it working:

5 <form action="{$my_base_url}{$my_pligg_base}/search.php" method="get" name="thisform" id="thisform">
6 <label for="searchsite">{#PLIGG_Visual_Search_Header_Sear ch#}:</label>
7 {if $templatelite.get.search neq ""}
8 {assign var=searchboxtext value=$templatelite.get.search|sanitize:2}
9 {else}
10 {assign var=searchboxtext value=#PLIGG_Visual_Search_SearchDefaultText#}
11 {/if}
12 <input type="text" size="20" name="search" id="searchsite" value="{$searchboxtext}" onfocus="if(this.value == '{$searchboxtext}') {ldelim}this.value = '';{rdelim}" onblur="if (this.value == '') {ldelim}this.value = '{$searchboxtext}';{rdelim}"/>
13 <input type="submit" value="Go" class="submit" />
14 </form>

red are the bits that u can remove.

this bit is only needed if u want to pass the search value onto the search results screen so it saves what you type in the search box. if you are going to do this then you also need to add the following into libs/lang.conf :

//<SECTION>SEARCH</SECTION><ADDED>0.80</ADDED>
78 PLIGG_Visual_Search_SearchDefaultText = "click here...(or whatever you want this to say)"


hope that helps anyone.

thanks ash, kb

dave