Hi David,
Hope all is going well.
I have just gone to load some products on a site I have been working on and when I select “slow import” the page refreshes but then just sits with nothing but the header displayed. If I select “import” the message below is displayed:
“[UPDATE `pt_feeds` SET products_last = products WHERE filename='house_of_fraser'][Unknown column 'products_last' in 'field list']”
I haven’t changed anything around the loading process for this site and I wondered if you might be able to suggest what the cause might be?
Thanks in advance.
Best regards
Chris
Hi David,
Thanks for your quick response and solution above. I added the field although I'm not sure why it was being asked for all of a sudden. Adding the field only partially fixed the problem. The "import" button then caused a 500 error and the "slow import" still froze. I then noticed a couple of filter names were missing in the filters list. I deleted them and and all is working fine now. I think the missing filter names may have been caused by a filter I added.
Anyway, it's all fixed now!...thanks again for your help.
Best regards
Chris
Hi Chris,
That would indicate that you have a modification in place that requires a custom `products_last` field on the pt_feeds table but is not currently in this installation so that can be added easily - the following dbmod.php script (run from top level of Price Tapestry installation) will add the field...
<?phprequire("includes/common.php");
$sql = "ALTER TABLE `".$config_databaseTablePrefix."feeds`
ADD `products_last` INT(11) NOT NULL";
database_queryModify($sql,$result);
print "Done.";
?>
Cheers,
David.
--
PriceTapestry.com