hi
my pages only shows one page of results but then there is no navigation. i can still see the call for navigation.php but it is not working.
any ideas
{link saved}
thanks
Hi
i have the same issue where the ordering links are not showing
thanks
Hi kiddyalley,
Is that on a site page or external page using one of the external scripts? If the latter, could you let me know what "calling code" (the PHP added to your external page) you are using and I'll take a look...
Cheers,
David.
--
PriceTapestry.com
Hi
i am not using the external code. I build the wordpress temlate around the pricetapestr software
thanks
Hi kiddyally,
The sort order links etc. are displayed by html/banner.php which is called in by this code at line 356 in search.php
require("html/banner.php");The $banner variable is set-up if there is a positive $resultCount so it should have started showing again once navigation was restored.
If you could double check that html/banner.php uploaded correctly (e.g. it's not a zero byte file because of a transient FTP problem) and if all looks OK if you could email me your
search.php
html/banner.php
includes/database.php
...together with a link to a page on your site showing the problem, i'll check it out for you...
Cheers,
David.
--
PriceTapestry.com
Hi Kiddyally,
There has been a fix documented regarding use of the external scripts (which you may be using as I see that you have have a higher level "blog" site) that involves modifying Price Tapestry to make sure that it uses a new database connection for each query, thus making sure that it does not overwrite the database connection of your external site.
This would have involved making a change to your includes/database.php at line 14 as follows:
$link = @mysql_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword,TRUE);With this in place, navigation from the normal installation search won't actually work as the SELECT SQL_CALC_FOUND_ROWS query has to be made on the same SQL link as the actual search query.
To work around this, in your includes/database.php look for the following code at line 2:
function database_querySelect($sql,&$rows)...and REPLACE with:
function database_querySelect($sql,&$rows,$new=TRUE)Then, assuming the modification for external compatibility, the following code at line 14:
$link = @mysql_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword,TRUE);...and REPLACE with:
$link = @mysql_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword,$new);Finally, in your search.php, look for the following code around line 273:
database_querySelect($sqlResultCount,$rowsResultCount);...and REPLACE with:
database_querySelect($sqlResultCount,$rowsResultCount,FALSE);If the above is not the case, let me know and I'll investigate further...
Hope this helps!
Cheers,
David.
--
PriceTapestry.com