Audit support thread

[swguy]

This is the Support thread for Audit. It's available here:
https://www.zen-cart.com/downloads.php?do=file&id=2261

Audit reports anomalies and unexpected conditions in your database, and allows you to fix them easily.

[lat9]

I'm seeing these PHP notices when I run the tool on a zc156c site (upgraded from zc154):

[05-Oct-2019 15:03:08 America/Chicago] Request URI: /siteadmin/audit.php, IP address: 127.0.0.1
--> PHP Notice: Use of undefined constant FIX_OPTION_SET_TYPE -  assumed 'FIX_OPTION_SET_TYPE' in  C:\xampp\htdocs\site\siteadmin\audit.php on line 180.

[05-Oct-2019 15:03:08 America/Chicago] Request URI: /siteadmin/audit.php, IP address: 127.0.0.1
--> PHP Notice: Use of undefined constant FIX_OPTION_SET_TYPE -  assumed 'FIX_OPTION_SET_TYPE' in  C:\xampp\htdocs\site\siteadmin\audit.php on line 197.

[swguy]

Thanks. I very cleverly forgot to check in some changes which I apparently have lost! Will fix shortly.

[swguy]

Version 1.1 now checks for the products.master_categories_id being set to a non-existent category, a situation which causes a ton of grief.

[swguy]

Version 1.2 now checks for categories containing both sub-categories and products. This is a misconfiguration which can cause problems and should be fixed.

[nicksab]

Is "Audit" compatible with ZC 2.0 and PHP 8.3?

Currently bringing my existing cart up to date.

Thank you

[gothstone]

Seems to for me. It's not finding anything, but it shouldn't be currently.