=== productQtySpider.php START === Run timestamp: 2026-10-07 21:57:45 FS Admin path (GetFsadminPath()): /home/opencart/public_html/fsadmin Active database (GetDatabase()): opencart_fsreal_oc3 Target tables: oc_product, pd_product_log [2026-10-07 21:57:45] cronjobsTimestamp.php InsertTimestamp(productQtySpider.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=52). 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 Catalog SQL: SELECT `product_id`, `quantity` FROM `oc_product` oc_product rows loaded: 29256 Latest-log SQL: SELECT pl.`product_id`, pl.`quantity` FROM `pd_product_log` pl INNER JOIN ( SELECT `product_id`, MAX(`date_added`) AS max_date_added FROM `pd_product_log` GROUP BY `product_id` ) latest ON pl.`product_id` = latest.`product_id` AND pl.`date_added` = latest.max_date_added pd_product_log latest-quantity map rows: 29307 Spider-token SQL: SELECT DISTINCT `product_id` FROM `pd_product_log` WHERE LOCATE(?, `description`) > 0 pd_product_log spider-tagged product_ids: 29255 Ledger date_added stamp: 2026-10-07 21:57:45 Comparing catalog quantities against prefetched log maps... Progress: 500/29256 products (seed=0 change=0 unchanged=500) Progress: 1000/29256 products (seed=0 change=0 unchanged=1000) Progress: 1500/29256 products (seed=0 change=0 unchanged=1500) Progress: 2000/29256 products (seed=0 change=0 unchanged=2000) Progress: 2500/29256 products (seed=0 change=0 unchanged=2500) Progress: 3000/29256 products (seed=0 change=0 unchanged=3000) Progress: 3500/29256 products (seed=0 change=0 unchanged=3500) Progress: 4000/29256 products (seed=0 change=0 unchanged=4000) Progress: 4500/29256 products (seed=0 change=0 unchanged=4500) Progress: 5000/29256 products (seed=0 change=0 unchanged=5000) Progress: 5500/29256 products (seed=0 change=0 unchanged=5500) Progress: 6000/29256 products (seed=0 change=0 unchanged=6000) Progress: 6500/29256 products (seed=0 change=0 unchanged=6500) Progress: 7000/29256 products (seed=0 change=0 unchanged=7000) Progress: 7500/29256 products (seed=0 change=0 unchanged=7500) Progress: 8000/29256 products (seed=0 change=0 unchanged=8000) Progress: 8500/29256 products (seed=0 change=0 unchanged=8500) Progress: 9000/29256 products (seed=0 change=0 unchanged=9000) Progress: 9500/29256 products (seed=0 change=0 unchanged=9500) Progress: 10000/29256 products (seed=0 change=0 unchanged=10000) Progress: 10500/29256 products (seed=0 change=0 unchanged=10500) Progress: 11000/29256 products (seed=0 change=0 unchanged=11000) Progress: 11500/29256 products (seed=0 change=0 unchanged=11500) Progress: 12000/29256 products (seed=0 change=0 unchanged=12000) Progress: 12500/29256 products (seed=0 change=0 unchanged=12500) Progress: 13000/29256 products (seed=0 change=0 unchanged=13000) Progress: 13500/29256 products (seed=0 change=0 unchanged=13500) Progress: 14000/29256 products (seed=0 change=0 unchanged=14000) Progress: 14500/29256 products (seed=0 change=0 unchanged=14500) Progress: 15000/29256 products (seed=0 change=0 unchanged=15000) Progress: 15500/29256 products (seed=0 change=0 unchanged=15500) Progress: 16000/29256 products (seed=0 change=0 unchanged=16000) Progress: 16500/29256 products (seed=0 change=0 unchanged=16500) Progress: 17000/29256 products (seed=0 change=0 unchanged=17000) Progress: 17500/29256 products (seed=0 change=0 unchanged=17500) Progress: 18000/29256 products (seed=0 change=0 unchanged=18000) Progress: 18500/29256 products (seed=0 change=0 unchanged=18500) Progress: 19000/29256 products (seed=0 change=0 unchanged=19000) Progress: 19500/29256 products (seed=0 change=0 unchanged=19500) Progress: 20000/29256 products (seed=0 change=0 unchanged=20000) Progress: 20500/29256 products (seed=0 change=0 unchanged=20500) Progress: 21000/29256 products (seed=0 change=0 unchanged=21000) Progress: 21500/29256 products (seed=0 change=0 unchanged=21500) Progress: 22000/29256 products (seed=0 change=0 unchanged=22000) Progress: 22500/29256 products (seed=0 change=0 unchanged=22500) Progress: 23000/29256 products (seed=0 change=0 unchanged=23000) Progress: 23500/29256 products (seed=0 change=0 unchanged=23500) Progress: 24000/29256 products (seed=0 change=0 unchanged=24000) Progress: 24500/29256 products (seed=0 change=0 unchanged=24500) Progress: 25000/29256 products (seed=0 change=0 unchanged=25000) Progress: 25500/29256 products (seed=0 change=0 unchanged=25500) Progress: 26000/29256 products (seed=0 change=0 unchanged=26000) Progress: 26500/29256 products (seed=0 change=0 unchanged=26500) Progress: 27000/29256 products (seed=0 change=0 unchanged=27000) Progress: 27500/29256 products (seed=0 change=0 unchanged=27500) Progress: 28000/29256 products (seed=0 change=0 unchanged=28000) Progress: 28500/29256 products (seed=0 change=0 unchanged=28500) Progress: 29000/29256 products (seed=0 change=0 unchanged=29000) Catalog loop complete. Seed inserts: 1; change inserts: 0; unchanged skipped: 29255 Calling AddOrders() for recent-order ledger follow-up... AddOrders() returned --- productQtySpider.php summary --- Database: opencart_fsreal_oc3 Target tables: oc_product, pd_product_log oc_product rows matched: 29256 pd_product_log latest-quantity map rows: 29307 pd_product_log spider-tagged product_ids: 29255 Products processed: 29256 pd_product_log rows written: 1 (seed=1, change=0) Unchanged products skipped: 29255 Elapsed seconds: 0.40 productQtySpider.php completed [2026-10-07 21:57:45] cronjobsTimestamp.php InsertTimestamp(productQtySpider.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=52). pd_cronjobs: updated 1 row (end_time stamped). pd_cronjobs_log: inserted 1 diagnostic row (id=180). 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.