Hi David. Hope you're ok.
So, I have new host and upgraded to php8. Out of 7 Price Tapestry installations only 3 are still working. All the others go to a 404 page.
All are set up the same way, although PT might be different versions, not sure. All have Wordpress in root directory and PT in a sub-directory.
Me being me, I deleted one site completely, both WP and PT. Downloaded the latest version of PT, configured it and uploaded to sub-directory. Went to setup.php and all I get is a blank page.
Any ideas?
Thanks David. So sorry it was my fault as there was a typo when I was configuring the config.phph!!
One thing I notice in the downloads you no longer have searchexternal.php. Will the older version I have work with the new PT?
---------
Jill
Hi,
The schema hasn't changed at all so legacy external scripts should work just fine...
Cheers,
David.
--
PriceTapestry.com
Thanks David
I previously had it able to search for 3 letter words, but seems I hadn't made a note of how to do that!
In index.php I had...
$sql = "SELECT name,1 AS sequence FROM `".$config_databaseTablePrefix."products` WHERE name LIKE '%bbq grill%' ORDER BY RAND() LIMIT 12";
I'm presuming that won't work as it can't search for 3 letter words.
---------
Jill
Hi Jill,
The above _should_ work as LIKE ... doesn't use the FULLTEXT index but if you are using the external scripts and setting keywords via $_GET["q"] you would need to disable FULLTEXT in the Price Tapestry installation which you can do in config.advanced.php at line 6 by changing to:
$config_useFullText = FALSE;
Cheers,
David.
--
PriceTapestry.com
Thanks David
Still not working.
How do I enable the search to search for 3 letter words?
---------
Jill
Hi Jill,
For the specific example above you could split the query into the individual words (which is what the core script does with FULLTEXT indexing disabled) so that would be for example:
$sql = "SELECT name,1 AS sequence FROM `".$config_databaseTablePrefix."products` WHERE (name LIKE '%bbq%') AND (name LIKE '%grill%') ORDER BY RAND() LIMIT 12";
Cheers,
David.
--
PriceTapestry.com
Thanks David, but I need it for all searches, not just that. For instance I need it for SearchExternal and also anybody who does a search on the site
---------
Jill
Hi Jill,
That is what setting $config_useFullText to FALSE in config.advanced.php (line 6) of the associated Price Tapestry installation should have achieved - used by search and SearchExternal - is that how currently set?
Cheers,
David.
--
PriceTapestry.com
Yes it was.
However, been having problems with our internet connection last couple of days (get a bit of rain here and it goes haywire!), so I thought I would just reupload the files again and blow me it's working!
Thanks David.
---------
Jill
Hi,
setup.php from 22/12A should be OK with PHP8 although there are some compatibility issues within the main scripts from PHP8.2 which I will be addressing with a minor update next month.
In the mean time, please could you add to config.php the following line:
ini_set('display_errors','on');error_reporting(E_ALL);
...and then try setup.php and let me know what is displayed and i'll check it out further for you (and don't forget to remove the above line once you've captured the error...)
Thanks,
David.
--
PriceTapestry.com