I've recently installed the latest version of Price Tapestry but I'm having problems getting CRON to work.
After running cron, I get no products showing in admin (Imported date updated, products 0). I've tried both cron options in Support Info, but neither seem to work. I've carried out a debug on cron.php and this is the result I'm getting (last few lines of the report):
`name`='NiQuitin Minis 1.5mg Orange - 60 pack',`description`='',`image_url`='',`buy_url`='http://www.awin1.com/pclick.php?p=3047788919&a=77425&m=2453',`price`='8.33',`postage`='2.95',`category`='',`brand`='',`original_name`='NiQuitin Minis 1.5mg Orange - 60 pack',`merchant`='Lloydspharmacy',
normalised_name='NiQuitin Minis 15mg Orange 60 pack',
][Table 'youcompa_pt005.pt_products_import' doesn't exist][SELECT COUNT(*) AS productCount FROM `pt_products_import` WHERE filename='lloydspharmacy.xml'][Table 'youcompa_pt005.pt_products_import' doesn't exist]
[ALTER TABLE `pt_products_import` ENABLE KEYS][Table 'youcompa_pt005.pt_products_import' doesn't exist][DROP TABLE `pt_products`][Unknown table 'pt_products'][RENAME TABLE `pt_products_import` TO `pt_products`][Can't find file: './youcompa_pt005/pt_products_import.frm' (errno: 2)]
backfilling reviews... [UPDATE `pt_products` SET rating='0',reviews='0'][Table 'youcompa_pt005.pt_products' doesn't exist]
Also, products would import fine manually before I set the cron job and let it run - though I now find they no longer import properly even through manual operation (again, date updated products 0). The database looks fine, though pt_product is empty.
Thanks in advance for your help,