=== analyzeInventorySpider.php START ===
Run timestamp: 2026-10-07 21:56:59
FS Admin path (GetFsadminPath()): /home/opencart/public_html/fsadmin
Active database (GetDatabase()): opencart_fsreal_oc3
Target tables: pd_inventory (write), oc_product (read-only)
Snapshot date (date_added): 2026-10-07
[2026-10-07 21:56:59] cronjobsTimestamp.php InsertTimestamp(analyzeInventorySpider.php, flag=1)
Connected database: opencart_fsreal_oc3
Target tables: pd_cronjobs, pd_cronjobs_log, oc_product, pd_cronjobs_errors
pd_cronjobs: found existing registry row (id=24).
pd_cronjobs: updated 1 row (begin_time and end_time stamped).
pd_cronjobs_log: 0 rows written (no message supplied).
Health check oc_product (product_id=4693): quantity=0.
pd_cronjobs_errors: 0 rows written (health check passed).
InsertTimestamp complete — rows inserted: 0, rows updated: 1.
Connected to opencart_fsreal_oc3
Supplier-map SQL: SELECT `supplier_id`, `manufacturer_id` FROM `pd_purchase_order_manufacturer`
Supplier-map rows: 536
Catalog SQL: SELECT `product_id`, `quantity`, `price`, `manufacturer_id`, `custom_field` FROM `oc_product`
Catalog prefetch progress: 500 rows
Catalog prefetch progress: 1000 rows
Catalog prefetch progress: 1500 rows
Catalog prefetch progress: 2000 rows
Catalog prefetch progress: 2500 rows
Catalog prefetch progress: 3000 rows
Catalog prefetch progress: 3500 rows
Catalog prefetch progress: 4000 rows
Catalog prefetch progress: 4500 rows
Catalog prefetch progress: 5000 rows
Catalog prefetch progress: 5500 rows
Catalog prefetch progress: 6000 rows
Catalog prefetch progress: 6500 rows
Catalog prefetch progress: 7000 rows
Catalog prefetch progress: 7500 rows
Catalog prefetch progress: 8000 rows
Catalog prefetch progress: 8500 rows
Catalog prefetch progress: 9000 rows
Catalog prefetch progress: 9500 rows
Catalog prefetch progress: 10000 rows
Catalog prefetch progress: 10500 rows
Catalog prefetch progress: 11000 rows
Catalog prefetch progress: 11500 rows
Catalog prefetch progress: 12000 rows
Catalog prefetch progress: 12500 rows
Catalog prefetch progress: 13000 rows
Catalog prefetch progress: 13500 rows
Catalog prefetch progress: 14000 rows
Catalog prefetch progress: 14500 rows
Catalog prefetch progress: 15000 rows
Catalog prefetch progress: 15500 rows
Catalog prefetch progress: 16000 rows
Catalog prefetch progress: 16500 rows
Catalog prefetch progress: 17000 rows
Catalog prefetch progress: 17500 rows
Catalog prefetch progress: 18000 rows
Catalog prefetch progress: 18500 rows
Catalog prefetch progress: 19000 rows
Catalog prefetch progress: 19500 rows
Catalog prefetch progress: 20000 rows
Catalog prefetch progress: 20500 rows
Catalog prefetch progress: 21000 rows
Catalog prefetch progress: 21500 rows
Catalog prefetch progress: 22000 rows
Catalog prefetch progress: 22500 rows
Catalog prefetch progress: 23000 rows
Catalog prefetch progress: 23500 rows
Catalog prefetch progress: 24000 rows
Catalog prefetch progress: 24500 rows
Catalog prefetch progress: 25000 rows
Catalog prefetch progress: 25500 rows
Catalog prefetch progress: 26000 rows
Catalog prefetch progress: 26500 rows
Catalog prefetch progress: 27000 rows
Catalog prefetch progress: 27500 rows
Catalog prefetch progress: 28000 rows
Catalog prefetch progress: 28500 rows
Catalog prefetch progress: 29000 rows
Catalog products loaded: 29256
Catalog products in memory: 29256
Latest-inventory SQL: SELECT i.`product_id`, i.`quantity`, i.`price`, i.`cost` FROM `pd_inventory` i INNER JOIN (   SELECT `product_id`, MAX(`date_added`) AS max_date_added   FROM `pd_inventory`   GROUP BY `product_id` ) latest ON i.`product_id` = latest.`product_id` AND i.`date_added` = latest.max_date_added
Latest-inventory snapshots: 28474
Latest snapshot map size: 28474
Snapshot progress: 500/29256 (writes: 5, skips: 494)
Snapshot progress: 1000/29256 (writes: 7, skips: 992)
Snapshot progress: 1500/29256 (writes: 13, skips: 1486)
Snapshot progress: 2000/29256 (writes: 22, skips: 1977)
Snapshot progress: 2500/29256 (writes: 34, skips: 2465)
Snapshot progress: 3000/29256 (writes: 40, skips: 2959)
Snapshot progress: 3500/29256 (writes: 54, skips: 3445)
Snapshot progress: 4000/29256 (writes: 54, skips: 3945)
Snapshot progress: 4500/29256 (writes: 61, skips: 4438)
Snapshot progress: 5000/29256 (writes: 105, skips: 4894)
Snapshot progress: 5500/29256 (writes: 107, skips: 5392)
Snapshot progress: 6000/29256 (writes: 111, skips: 5888)
Snapshot progress: 6500/29256 (writes: 137, skips: 6362)
Snapshot progress: 7000/29256 (writes: 145, skips: 6854)
Snapshot progress: 7500/29256 (writes: 145, skips: 7354)
Snapshot progress: 8000/29256 (writes: 146, skips: 7853)
Snapshot progress: 8500/29256 (writes: 150, skips: 8349)
Snapshot progress: 9000/29256 (writes: 150, skips: 8849)
Snapshot progress: 9500/29256 (writes: 150, skips: 9349)
Snapshot progress: 10000/29256 (writes: 150, skips: 9849)
Snapshot progress: 10500/29256 (writes: 150, skips: 10349)
Snapshot progress: 11000/29256 (writes: 150, skips: 10849)
Snapshot progress: 11500/29256 (writes: 150, skips: 11349)
Snapshot progress: 12000/29256 (writes: 150, skips: 11849)
Snapshot progress: 12500/29256 (writes: 150, skips: 12349)
Snapshot progress: 13000/29256 (writes: 150, skips: 12849)
Snapshot progress: 13500/29256 (writes: 150, skips: 13349)
Snapshot progress: 14000/29256 (writes: 150, skips: 13849)
Snapshot progress: 14500/29256 (writes: 151, skips: 14348)
Snapshot progress: 15000/29256 (writes: 151, skips: 14848)
Snapshot progress: 15500/29256 (writes: 151, skips: 15348)
Snapshot progress: 16000/29256 (writes: 151, skips: 15848)
Snapshot progress: 16500/29256 (writes: 151, skips: 16348)
Snapshot progress: 17000/29256 (writes: 151, skips: 16848)
Snapshot progress: 17500/29256 (writes: 151, skips: 17348)
Snapshot progress: 18000/29256 (writes: 151, skips: 17848)
Snapshot progress: 18500/29256 (writes: 151, skips: 18348)
Snapshot progress: 19000/29256 (writes: 152, skips: 18847)
Snapshot progress: 19500/29256 (writes: 152, skips: 19347)
Snapshot progress: 20000/29256 (writes: 152, skips: 19847)
Snapshot progress: 20500/29256 (writes: 152, skips: 20347)
Snapshot progress: 21000/29256 (writes: 152, skips: 20847)
Snapshot progress: 21500/29256 (writes: 152, skips: 21347)
Snapshot progress: 22000/29256 (writes: 152, skips: 21847)
Snapshot progress: 22500/29256 (writes: 152, skips: 22347)
Snapshot progress: 23000/29256 (writes: 152, skips: 22847)
Snapshot progress: 23500/29256 (writes: 152, skips: 23347)
Snapshot progress: 24000/29256 (writes: 152, skips: 23847)
Snapshot progress: 24500/29256 (writes: 152, skips: 24347)
Snapshot progress: 25000/29256 (writes: 163, skips: 24836)
Snapshot progress: 25500/29256 (writes: 164, skips: 25335)
Snapshot progress: 26000/29256 (writes: 164, skips: 25835)
Snapshot progress: 26500/29256 (writes: 165, skips: 26334)
Snapshot progress: 27000/29256 (writes: 166, skips: 26833)
Snapshot progress: 27500/29256 (writes: 168, skips: 27331)
Snapshot progress: 28000/29256 (writes: 168, skips: 27831)
Snapshot progress: 28500/29256 (writes: 168, skips: 28331)
Snapshot progress: 29000/29256 (writes: 174, skips: 28825)
Stale-purge SQL: DELETE FROM `pd_inventory` WHERE `date_added` < ? [date_added < 2026-10-07]
Stale pd_inventory rows purged: 0
Transaction committed. Writes: 179, purged: 0
--- analyzeInventorySpider.php summary ---
Database: opencart_fsreal_oc3
Target tables: oc_product (read), pd_inventory (write)
Catalog products: 29256
Snapshot rows written: 179
Unchanged products skipped: 29077
Stale pd_inventory rows purged: 0
Elapsed seconds: 1.13
analyzeInventorySpider.php completed
DEBUG: The dynamic end message variable actually contained: Inventory pass complete. Purged: 0 (Length: 34)
[2026-10-07 21:57:00] cronjobsTimestamp.php InsertTimestamp(analyzeInventorySpider.php, flag=0)
Connected database: opencart_fsreal_oc3
Target tables: pd_cronjobs, pd_cronjobs_log, oc_product, pd_cronjobs_errors
pd_cronjobs: found existing registry row (id=24).
pd_cronjobs: updated 1 row (end_time stamped).
pd_cronjobs_log: inserted 1 diagnostic row (id=179).
Health check oc_product (product_id=4693): quantity=0.
pd_cronjobs_errors: 0 rows written (health check passed).
InsertTimestamp complete — rows inserted: 1, rows updated: 1.