You are here:  » Automation stuck

Active Forum Topics


Automation stuck

Submitted by babrees on Tue, 2021-09-14 14:39 in

Sorry David

Reading your instructions here (https://www.pricetapestry.org/node/466) to allow a search for 3 letter words, I had my host change my server from 4 to 3.
I did not have to make the advised change to pto_search.php as that was already 3.

I then went to automation toll and ran each feed.

Then went to Feed Management and clicked on Slow Import, but it got stuck on deleting. It did delete a number of products but then after about an hour I aborted. I tried a smaller feed and that just gets stuck too.

I haven't done anything else since yesterday, when it was working fine.

Any ideas? Would making that change on the server have done anything?

Submitted by support on Wed, 2021-09-15 09:39

Hello Jill,

It sounds from this and your other update the database may have got into something of an inconsistent state. I would suggesting purging the products table by running the following script saved as something like dbpurge.php from the top level of the Price Tapestry installation

<?php
  set_time_limit
(0);
  require(
"includes/common.php");
  
$sql "DELETE FROM `".$config_databaseTablePrefix."products`";
  
database_queryModify($sql,$result);
  print 
"Done.";
?>

After running that run a full import and if the problem persists let me know and I'll check it out further with you...

(don't forget to delete the purge script from your server after the process)

Cheers,
David.
--
PriceTapestry.com