So sorry David
Server ran a cron job to fetch and import. But I had forgotten to set the minute and it was left as an * So the script ran every minute! Consequiently the script failed.
I manually clicked run on the automation tool and that worked. Feeds all correct on the server.
However, it refuses to import. On clicking slow import I get page counting products importing, but none are actually imported.
I ran the purge script you gave for another time But it still won't import after that
<?php
set_time_limit(0);
require("includes/common.php");
$sql = "DELETE FROM `".$config_databaseTablePrefix."products`";
database_queryModify($sql,$result);
print "Done.";
?>
Unfortunately that doesn't seem to have helped. I suspended the account first to ensure nothing was running, clicked slow import but still no products
Hi Jill,
In /pt/ edit config.advanced.php and set database debug mode to level 2 (exit after first error) at line 6:
$config_databaseDebugMode = 2;
Then try import again; hopefully an informative error message will be displayed. If you're not sure from the error where the problem lies; or if no difference; let me know what (or not) is displayed and I'll check it out further with you.
If you can identify the issue from the debug output don't forget to change database debug mode back to FALSE once up and running...
Cheers,
David.
--
PriceTapestry.com
[{code saved}][Table 'gasbarbequesorg_data.pt1_products' doesn't exist]
WOW! How did that get removed!!!
Hi Jill,
That would actually make sense if cron was being run concurrently because of the zero-downtime method - products are imported to a temporary table and once completed the original products table is dropped and the temporary table becomes the new products table - so it looks like it has ended up in limbo multiple instances of as a result of cron.php running.
To fix this, you can run, from the /pt/ folder setup.php?installDB=1 and the products table will be recreated. You won't lose anything else as the setup script doesn't drop existing tables (but make sure database debug mode set back to FALSE in config.advanced.php first) and then you should be able to import again.
Cheers,
David.
--
PriceTapestry.com
YES!
Thank you so so much David - you are a genius! It's now importing!!
Hi Jill,
The simultaneous running may have crashed the products table. Firstly, make absolutely sure there is nothing still running (maybe a reboot if necessary) and then run the following dbrepair.php script:
<?php
set_time_limit(0);
require("includes/common.php");
$sql = "REPAIR TABLE `".$config_databaseTablePrefix."products`";
database_queryModify($sql,$result);
print "Done.";
?>
Hope this helps!
Cheers,
David.
--
PriceTapestry.com