[2026-10-07 21:56:57] cronjobsTimestamp.php InsertTimestamp(subCategoryCountSpider.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=19).
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.
subCategoryCountSpider.php starting
Database: opencart_fsreal_oc3
Target tables: oc_category, oc_product_to_category, oc_category_description, oc_category_path, oc_category_to_store, oc_category_to_layout, pd_subcategory_count
Connected to opencart_fsreal_oc3
Categories loaded: 4235 (enabled=3737, disabled=498)
Product-to-category assignments loaded: 43580
Category descriptions (language_id=1): 4235
Cleared `pd_subcategory_count` (3737 prior rows removed)
Enabled categories counted: 3737
pd_subcategory_count rows written: 3737
Empty enabled categories set status=0: 0
Disabled category still has products (status=1 write skipped, legacy): Shooting Gallery 304 count=4
Disabled category still has products (status=1 write skipped, legacy): Displays 322 count=3
Disabled category still has products (status=1 write skipped, legacy): Stock Finishing 364 count=3
Disabled category still has products (status=1 write skipped, legacy): Range Boxes 378 count=3
Disabled category still has products (status=1 write skipped, legacy): Lee Precision .45 ACP Quick Trim Die Parts 433 count=1
Disabled category still has products (status=1 write skipped, legacy): Upper/Lower 1 Die Box Parts 1206 count=1
Disabled category still has products (status=1 write skipped, legacy): Upper/Lower 1 Die Box Parts 1400 count=1
Disabled category still has products (status=1 write skipped, legacy): Lee Precision Large Series Shell Holder .50 BMG Parts 1409 count=2
Disabled category still has products (status=1 write skipped, legacy): Hooyman 1599 count=5
Disabled category still has products (status=1 write skipped, legacy): Paper 1617 count=3
Disabled category still has products (status=1 write skipped, legacy): Holsters 1618 count=31
Disabled category still has products (status=1 write skipped, legacy): Personal Defense 1620 count=3
Disabled category still has products (status=1 write skipped, legacy): Gun Locks and Mounts 1621 count=2
Disabled category still has products (status=1 write skipped, legacy): GoldenRod by Lockdown 1622 count=6
Disabled category still has products (status=1 write skipped, legacy): Expander MZ 1694 count=10
Disabled category still has products (status=1 write skipped, legacy): Aligner Tool 1696 count=5
Disabled category still has products (status=1 write skipped, legacy): Spit-Fire MZ 1697 count=2
Disabled category still has products (status=1 write skipped, legacy): Spit-Fire T-EZ 1698 count=6
Disabled category still has products (status=1 write skipped, legacy): Handgun Ammo 1998 count=1
Disabled category still has products (status=1 write skipped, legacy): 9mm 2036 count=1
Disabled category still has products (status=1 write skipped, legacy): Discontinued Products 3270 count=2
Disabled category still has products (status=1 write skipped, legacy): Lights, Lasers & Batteries 25384 count=2
Disabled category still has products (status=1 write skipped, legacy): Safety & Protection 25391 count=46
Disabled category still has products (status=1 write skipped, legacy): Lights, Lasers & Batteries 25456 count=1
Disabled category still has products (status=1 write skipped, legacy): Holsters & Pouches 25460 count=38
Disabled category still has products (status=1 write skipped, legacy): Clothing 25461 count=13
Disabled category still has products (status=1 write skipped, legacy): Magazines 25462 count=3
Disabled category still has products (status=1 write skipped, legacy): Survival & Camping Supplies 25468 count=1
Disabled category still has products (status=1 write skipped, legacy): Parts 25513 count=2
Disabled category still has products (status=1 write skipped, legacy): Lights, Lasers & Batteries 25515 count=1
Disabled category still has products (status=1 write skipped, legacy): Slings & Swivels 25516 count=2
Disabled category still has products (status=1 write skipped, legacy): Grips, Pads, Stocks, Bipods 25523 count=9
Disabled category still has products (status=1 write skipped, legacy): Cleaning Equipment 25619 count=10
Disabled category still has products (status=1 write skipped, legacy): Cleaning Equipment 25635 count=1
Disabled category still has products (status=1 write skipped, legacy): Knives & Tools 25636 count=1
Disabled category still has products (status=1 write skipped, legacy): Lights, Lasers & Batteries 25661 count=2
Disabled category still has products (status=1 write skipped, legacy): Sights 25675 count=2
Disabled category still has products (status=1 write skipped, legacy): Parts 25684 count=1
Disabled category still has products (status=1 write skipped, legacy): Barrels, Choke Tubes & Muzzle Devices 25720 count=1
Disabled category still has products (status=1 write skipped, legacy): SBR Barrels & Upper Receivers 25721 count=1
Disabled category still has products (status=1 write skipped, legacy): Parts 25727 count=1
Disabled category still has products (status=1 write skipped, legacy): Barrels, Choke Tubes & Muzzle Devices 25798 count=2
Disabled category still has products (status=1 write skipped, legacy): Lights, Lasers & Batteries 25813 count=2
Disabled category still has products (status=1 write skipped, legacy): Holsters & Pouches 25819 count=5
Disabled category still has products (status=1 write skipped, legacy): Slings & Swivels 25820 count=4
Disabled category still has products (status=1 write skipped, legacy): Soft Gun Cases, Packs, Bags 25821 count=8
Disabled category still has products (status=1 write skipped, legacy): Non-Lethal Defense 25863 count=2
Disabled category still has products (status=1 write skipped, legacy): SBR Barrels & Upper Receivers 25876 count=3
Disabled category still has products (status=1 write skipped, legacy): Holsters & Pouches 25903 count=1
Disabled category still has products (status=1 write skipped, legacy): Lights, Lasers & Batteries 25935 count=1
Disabled category still has products (status=1 write skipped, legacy): Misc. Accessories 25952 count=2
Disabled category still has products (status=1 write skipped, legacy): Optical Accessories 25962 count=1
Disabled category still has products (status=1 write skipped, legacy): Sights 25973 count=67
Disabled category still has products (status=1 write skipped, legacy): Optics 25974 count=14
Disabled category still has products (status=1 write skipped, legacy): Optical Accessories 25975 count=6
Disabled category still has products (status=1 write skipped, legacy): High Capacity Magazines 26005 count=3
Disabled category still has products (status=1 write skipped, legacy): Magazines 26031 count=1
Disabled category still has products (status=1 write skipped, legacy): High Capacity Magazines 26042 count=2
Disabled category still has products (status=1 write skipped, legacy): Magazines 26064 count=1
Disabled category still has products (status=1 write skipped, legacy): Magazines 26074 count=7
Disabled category still has products (status=1 write skipped, legacy): Magazines 26095 count=1
Disabled category still has products (status=1 write skipped, legacy): Magazines 26105 count=21
Disabled category still has products (status=1 write skipped, legacy): High Capacity Magazines 26106 count=2
Disabled category still has products (status=1 write skipped, legacy): High Capacity Magazines 26159 count=1
Disabled category still has products (status=1 write skipped, legacy): Barrels, Choke Tubes & Muzzle Devices 26207 count=1
Disabled category still has products (status=1 write skipped, legacy): Magazines 26279 count=3
Disabled category still has products (status=1 write skipped, legacy): Safety & Protection 26280 count=1
Disabled category still has products (status=1 write skipped, legacy): SBR Barrels & Upper Receivers 26330 count=3
Disabled category still has products (status=1 write skipped, legacy): Upper Receivers & Conversion Kits 26331 count=3
Disabled category still has products (status=1 write skipped, legacy): Soft Gun Cases, Packs, Bags 26341 count=1
Disabled category still has products (status=1 write skipped, legacy): Grips, Pads, Stocks, Bipods 26342 count=9
Disabled category still has products (status=1 write skipped, legacy): Optical Accessories 26343 count=2
Disabled category still has products (status=1 write skipped, legacy): Barrels, Choke Tubes & Muzzle Devices 26344 count=9
Disabled category still has products (status=1 write skipped, legacy): Parts 26345 count=4
Disabled category still has products (status=1 write skipped, legacy): Optics 26352 count=2
Disabled category still has products (status=1 write skipped, legacy): Safety & Protection 26373 count=1
Disabled category still has products (status=1 write skipped, legacy): Optical Accessories 26375 count=1
Disabled category still has products (status=1 write skipped, legacy): Clothing 26429 count=3
Disabled category still has products (status=1 write skipped, legacy): Holsters & Pouches 26430 count=207
Disabled category still has products (status=1 write skipped, legacy): Safety & Protection 26431 count=5
Disabled category still has products (status=1 write skipped, legacy): Soft Gun Cases, Packs, Bags 26432 count=2
Disabled category still has products (status=1 write skipped, legacy): Magazines 26435 count=8
Disabled category still has products (status=1 write skipped, legacy): Lights, Lasers & Batteries 26436 count=1
Disabled category still has products (status=1 write skipped, legacy): Hard Gun Cases 26448 count=1
Disabled category still has products (status=1 write skipped, legacy): Sights 26472 count=1
Disabled category still has products (status=1 write skipped, legacy): Lights, Lasers & Batteries 26506 count=4
Disabled category still has products (status=1 write skipped, legacy): Cleaning Equipment 26516 count=2
Disabled category still has products (status=1 write skipped, legacy): Barrels, Choke Tubes & Muzzle Devices 26577 count=1
Disabled category still has products (status=1 write skipped, legacy): Optics 26584 count=1
Disabled category still has products (status=1 write skipped, legacy): Sights 26753 count=1
Disabled category still has products (status=1 write skipped, legacy): Optics 26755 count=1
Disabled category still has products (status=1 write skipped, legacy): Soft Gun Cases, Packs, Bags 26759 count=1
Disabled category still has products (status=1 write skipped, legacy): Grips, Pads, Stocks, Bipods 26762 count=1
Disabled category still has products (status=1 write skipped, legacy): Magazines 26774 count=1
Disabled category still has products (status=1 write skipped, legacy): Parts 26784 count=1
Disabled category still has products (status=1 write skipped, legacy): Clothing 26793 count=1
Disabled category still has products (status=1 write skipped, legacy): Cleaning Equipment 26799 count=1
Disabled category still has products (status=1 write skipped, legacy): Clothing 26888 count=32
Disabled category still has products (status=1 write skipped, legacy): High Capacity Magazines 26924 count=1
Disabled category still has products (status=1 write skipped, legacy): Airguns 27009 count=1
Disabled category still has products (status=1 write skipped, legacy): Upper Receivers & Conversion Kits 27024 count=2
Disabled category still has products (status=1 write skipped, legacy): Optical Accessories 27054 count=1
Disabled category still has products (status=1 write skipped, legacy): T-shirts 27141 count=1
Disabled category still has products (status=1 write skipped, legacy): Barrels, Choke Tubes & Muzzle Devices 27143 count=2
Disabled categories with products reported: 104
Orphan category rows removed from tree maps: 0
Database connection closed
Categories evaluated: 4235
Rows successfully updated with fresh product counts: 3737
subCategoryCountSpider.php finished
[2026-10-07 21:56:57] cronjobsTimestamp.php InsertTimestamp(subCategoryCountSpider.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=19).
pd_cronjobs: updated 1 row (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.