Remove old search terms from Actinic

[fgs]

I've created some custom variables on our website to search for a product using specific criteria from some drop down menus.

http://www.beds247.co.uk

I add, remove and change products and product info by uploading csv files.

I've removed some products from the spreadsheet, yet their search criteria is still referenced in Actinic. Even when I remove all the products from the website they're still in the drop down menus. I've tried compact and repair database and purging the content but they still appear.

Does anyone know where the info is stored for these variables or how I can clear them from Actinic?

Thanks

[I-CC]

If the products contain the values and you have been importing the products via a spreadsheet, then would suggest that you still have the values in products that still remain in your content tree.

However, have you tried Refreshing the website so that Actinic is forced to upload fresh/latest versions of the .fil files, as never know, it may just be missing updating these files with a standard update.

[fgs]

Even when there are no products in the website the values still appear in the drop down boxes and the lists are still populated. Even on my pc before I even upload to the web.

[I-CC]

Are you sure that they are populated by entries within the product assigned variables? The entry assigned to the product is used to match up for search abilities, but could they possibly be in a list assigned directly to the variable maybe?

[fgs]

Yes, they are product specific variables. I'm guessing the values must have been logged in a file somwhere or are even in the database for the site, but haven't a clue where.

[I-CC]

Really you need to know how your search drop-downs are created, whether they are populated by the search page functions and code or whether via lists in variables.

Before this can be identified and either solves the problem or is ruled out as the issue, then you might be clutching at straws.

Can you not speak with the person who built your design if you dont have the foggiest on it (no offence but means you did not build it - so getting it from the horses mouth as they say).

BTW - are you using a full version or client version (i.e. not a cut down version which gives no access to design elements and the like)?

[fgs]

The code which runs the search bit is taken from actinics own generated search page and is...

<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#f0f0f0">
  <tr>
    <th background="search_bkg.jpg" scope="col">
    <div align="center">
    <div id="quick_links_title2">
     <div align="center" class="white12">Product Finder</div>
   </div>
    </div>
    
    <form method="get" action="<actinic:variable name="OnlineScriptURL" value="Search Script URL" />">
      <input type="hidden" name="RANDOM" value="<actinic:variable name='Random'/>" />
      <actinic:block if="%3cactinic%3avariable%20name%3d%22IsHostMode%22%20%2f%3e">
        <!-- Hidden field when in trial mode -->
        <input type="hidden" name="SHOP" value="<Actinic:Variable Name="HiddenFields"/>" />
      </actinic:block>
      <input type="hidden" name="PAGE" value="SEARCH" />
	   
                  <input type="hidden" name="TB" checked="checked" value="A" />
                  <br/>

<table border="0" align="left" cellpadding="3" cellspacing="0" background="search_bkg.jpg" bgcolor="#f0f0f0">
        <tr>
          
          <td width="450" valign="top"><div align="left">
            <actinic:block if="%3cactinic%3avariable%20name%3d%22PriceSearchIsAllowed%22%20%2f%3e"></actinic:block>
          </div></td>
        </tr>
		
		
				  &nbsp; <b><Actinic:Variable Name="SearchString"/></b><br />
              &nbsp; <input type="text" name="SS" size="23" /> <br/></actinic:block>
                <div align="left"></div>
              
        <actinic:variable name="SearchablePropertyList" />
        <actinic:block if="%3cactinic%3avariable%20name%3d%22IsSearchablePropertiesCombinedWithAnd%22%20%2f%3e" />    
        <input type="hidden" name="GB" value="A" />
        <tr>
          <td></actinic:block>
            <div align="left"></div></td>
        </tr>
        <actinic:block if="%3cactinic%3avariable%20name%3d%22IsSearchablePropertiesCombinedWithOr%22%20%2f%3e" />    
        <input type="hidden" name="GB" value="O" />
        <tr>
          <td> </actinic:block>
            <div align="left"><b>
              &nbsp;   
              <Actinic:Variable Name="SearchPriceRangeLabel"/>
              </b> <br />
              &nbsp;   
              <actinic:variable name="SearchPriceBandList" />
            </div></td>
        </tr>
        <actinic:block if="%3cactinic%3avariable%20name%3d%22SearchBySectionsUsed%22%20%2f%3e" />    
        <tr>
          <td colspan="2" valign="bottom"><div align="left"><b>
            <Actinic:Variable Name="SearchControlLabel"/>
            </b><br />
            <select name="SX">
              <actinic:block if="%3cactinic%3avariable%20name%3d%22SetupSearchAllSections%22%20%2f%3e%20%3d%3d%20False">
                <option value="0"> </option>
              </actinic:block>
              <actinic:variable name="SearchSectionList" />
            </select>
          </div></td>
        </tr>
        <tr>
          <td></actinic:block>
            <div align="left"></div></td>
        </tr>
        <tr>
          <td colspan="2" valign="bottom"><div align="left">
            <input type="submit" name="ACTION" value="<Actinic:Variable Name="SearchLabel"/>" />          
          </div></td>
        </tr>
      </table>
      <!-- alert("<Actinic:Variable Name="UnregCustomersNotAllowedMessage"/>");
         return false; -->
    </form></th></td>
  </tr>
</table>

The version we use is the latest 9.04 business multisite.

[I-CC]

Well if its not in the design and a full refresh has been tried, then it has to exist on the variable as a list item or within a product as an entry.

Check in the design | library | and variables tab and look for the variable which is having the issue of stuff hanging over still and see how the variable is populated, i.e. is it free text or from a list of choices - but suggested that one earlier to check but thinking this has to be the cause, or if it is free text then a product is still using it...

What is it BTW which is still showing as a search option which should be gone?

[fgs]

Ok then thanks. I'll check that out in a mo.

I haven't uploaded this particular site again with the eliminated products yet. They're still showing on my pc though, so I was going to try and rectify this problem before I upload again.