Audit support thread

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.

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

Code:

---

[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.

---

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

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. :(

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.

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

Currently bringing my existing cart up to date.

Thank you

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

Getting some deprecate.log

Code:

---

07-Dec-2024 22:28:47 America/Los_Angeles] Request URI: /sweety/index.php?cmd=audit, IP address: 24.4.88.128, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /sweety/includes/header.php(71): trigger_error()
#2 /sweety/audit.php(81): require('/home/zch1akhw6...')
#3 /sweety/index.php(16): require('/home/zch1akhw6...')
--> PHP Deprecated: This page requires updates for the next Zen Cart version. Please refer your site developer or plugin author to <a href="https://docs.zen-cart.com/dev/plugins/admin_head_content/" rel="noopener noreferrer" target="_blank">this</a> documentation. in /sweety/includes/header.php on line 71.

---

thanks - will fix on the next update.