You are here:  » HELP! All products gone and won't import


HELP! All products gone and won't import

Submitted by babrees on Mon, 2021-09-20 09:50 in

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.";
?>

Submitted by support on Mon, 2021-09-20 11:08

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

Submitted by babrees on Mon, 2021-09-20 11:33

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

Submitted by support on Mon, 2021-09-20 12:01

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

Submitted by babrees on Mon, 2021-09-20 12:11

[{code saved}][Table 'gasbarbequesorg_data.pt1_products' doesn't exist]

WOW! How did that get removed!!!

Submitted by support on Mon, 2021-09-20 12:17

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

Submitted by babrees on Mon, 2021-09-20 12:21

YES!

Thank you so so much David - you are a genius! It's now importing!!