Technote Details :: When creating a second search page, the first cache table is overwritten

When I apply the Site Search command for the second time in the same site, using only one set of cache and temporary tables, the first set of data is overwritten.

This happens because each Site Search command writes its own particular data in the cache and temporary tables, and as such, when multiple commands are applied, previous data is replaced.

In order to have multiple search pages in your site, you must use a different name for the cache and temporary tables, for each Site Search command applied.

For example: for the first search page you can name the tables: src_cache_cah and src_temp_tmp, while for the second page src_cache2_cah and src_temp2_tmp.

Using this approach, you will be able to create as many search pages you want, with different tables and filters, to adapt to your site needs.

Login to add a new note