1.5.7d to 1.5.8a dev site 500 error

[gothstone]

Trying to start work on a 1.5.8a dev site, it's not going well. I think I have something wrong with my prod database, or one of my plugins did something too weird to my DB. Any help would be appreciated. Sorry for info overload, but trying to get all the appropriate info out there so maybe someone can help figure this out.

Totally clean load of 1.5.8a – working fine. Verified both home page and admin load.
Dup clean (empty) DB in case I need it later
Re-upload zc_install directory
Replace dev DB with copy of prod DB
Edit DB to correct directories:
Log Destination
Session Directory
Visit zc_install, wonder for the hundredth time why it incorrectly thinks GZip isn’t enabled, hit upgrade
Confirm 1.5.7(d) to 1.5.8, user and pass, continue
Complete
Delete zc_install
Log into admin
Change template to responsive classic
Visit dev home page, http error 500
Check logs, find (plus duplicates):
myDEBUG-20230916-170628-123048-warning.log
[16-Sep-2023 17:06:28 UTC] PHP Warning: Undefined global variable $_SESSION in /home/pcs/dev/includes/extra_configures/enable_error_logging.php on line 84
[16-Sep-2023 17:06:28 UTC] PHP Warning: Trying to access array offset on value of type null in /home/pcs/dev/includes/extra_configures/enable_error_logging.php on line 84
[16-Sep-2023 17:06:28 UTC] Request URI: /, IP address: 73.67.37.4, Language id
#0 [internal function]: zen_debug_error_handler()
#1 /home/pcs/dev/laravel/app/Models/ProductTypeLayout.php(22): define()
#2 /home/pcs/dev/includes/init_includes/init_db_config_read.php(21): App\Models\ProductTypeLayout->loadConfigSettings()
#3 /home/pcs/dev/includes/autoload_func.php(40): require_once('/home/pcs/dev/i...')
#4 /home/pcs/dev/includes/application_top.php(237): require('/home/pcs/dev/i...')
#5 /home/pcs/dev/index.php(25): require('/home/pcs/dev/i...')
--> PHP Warning: Constant SHOW_PRODUCT_MUSIC_INFO_ARTIST already defined in /home/pcs/dev/laravel/app/Models/ProductTypeLayout.php on line 22.

[16-Sep-2023 17:06:28 UTC] PHP Fatal error: Uncaught Error: Undefined constant "SEARCH_ENGINE_FRIENDLY_URLS" in /home/pcs/dev/includes/init_includes/init_sefu.php:13
Stack trace:
#0 /home/pcs/dev/includes/autoload_func.php(40): require_once()
#1 /home/pcs/dev/includes/application_top.php(237): require('/home/pcs/dev/i...')
#2 /home/pcs/dev/index.php(25): require('/home/pcs/dev/i...')
#3 {main}
thrown in /home/pcs/dev/includes/init_includes/init_sefu.php on line 13

[16-Sep-2023 17:06:28 UTC] Request URI: /, IP address: 73.67.37.4
--> PHP Fatal error: Uncaught Error: Undefined constant "SEARCH_ENGINE_FRIENDLY_URLS" in /home/pcs/dev/includes/init_includes/init_sefu.php:13
Stack trace:
#0 /home/pcs/dev/includes/autoload_func.php(40): require_once()
#1 /home/pcs/dev/includes/application_top.php(237): require('/home/pcs/dev/i...')
#2 /home/pcs/dev/index.php(25): require('/home/pcs/dev/i...')
#3 {main}
thrown in /home/pcs/dev/includes/init_includes/init_sefu.php on line 13.

myDEBUG-adm-20230916-170548-225366-warning.log
[16-Sep-2023 17:05:48 UTC] PHP Warning: Undefined global variable $_SESSION in /home/pcs/dev/includes/extra_configures/enable_error_logging.php on line 84
[16-Sep-2023 17:05:48 UTC] PHP Warning: Trying to access array offset on value of type null in /home/pcs/dev/includes/extra_configures/enable_error_logging.php on line 84
[16-Sep-2023 17:05:48 UTC] Request URI: /nimda123/index.php?cmd=template_select&page=1&tID=1&action=save, IP address: 73.67.37.4, Language id
#0 [internal function]: zen_debug_error_handler()
#1 /home/pcs/dev/laravel/app/Models/ProductTypeLayout.php(22): define()
#2 /home/pcs/dev/nimda123/includes/init_includes/init_db_config_read.php(37): App\Models\ProductTypeLayout->loadConfigSettings()
#3 /home/pcs/dev/includes/autoload_func.php(40): require_once('/home/pcs/dev/n...')
#4 /home/pcs/dev/nimda123/includes/application_top.php(42): require('/home/pcs/dev/i...')
#5 /home/pcs/dev/nimda123/template_select.php(8): require('/home/pcs/dev/n...')
#6 /home/pcs/dev/nimda123/index.php(11): require('/home/pcs/dev/n...')
--> PHP Warning: Constant SHOW_PRODUCT_MUSIC_INFO_ARTIST already defined in /home/pcs/dev/laravel/app/Models/ProductTypeLayout.php on line 22.

myDEBUG-adm-20230916-170548-359873-warning.log
[16-Sep-2023 17:05:48 UTC] PHP Warning: Undefined global variable $_SESSION in /home/pcs/dev/includes/extra_configures/enable_error_logging.php on line 84
[16-Sep-2023 17:05:48 UTC] PHP Warning: Trying to access array offset on value of type null in /home/pcs/dev/includes/extra_configures/enable_error_logging.php on line 84
[16-Sep-2023 17:05:48 UTC] Request URI: /nimda123/index.php?cmd=template_select&page=1&tID=1, IP address: 73.67.37.4, Language id
#0 [internal function]: zen_debug_error_handler()
#1 /home/pcs/dev/laravel/app/Models/ProductTypeLayout.php(22): define()
#2 /home/pcs/dev/nimda123/includes/init_includes/init_db_config_read.php(37): App\Models\ProductTypeLayout->loadConfigSettings()
#3 /home/pcs/dev/includes/autoload_func.php(40): require_once('/home/pcs/dev/n...')
#4 /home/pcs/dev/nimda123/includes/application_top.php(42): require('/home/pcs/dev/i...')
#5 /home/pcs/dev/nimda123/template_select.php(8): require('/home/pcs/dev/n...')
#6 /home/pcs/dev/nimda123/index.php(11): require('/home/pcs/dev/n...')
--> PHP Warning: Constant SHOW_PRODUCT_MUSIC_INFO_ARTIST already defined in /home/pcs/dev/laravel/app/Models/ProductTypeLayout.php on line 22.

Only module in plugin manager is display logs. Uninstalling it causes a 500 error, upgrading from 3.0.0 to 3.0.2 works, but does not fix the home page.
Looking at Configuration Logging on prod site, several things are dupped:
Title Value Action
Log Page Parse Time false
Log Destination /home/pcs/public_html/logs/page_par... Info
Log Date Format %d/%m/%Y %H:%M:%S Info
Display The Page Parse Time false Info
Log Database Queries false Info
Report All Errors (Admin)? Yes Info
Report All Errors (Store)? Yes Info
Report All Errors: Backtrace on Notices? No Info
Display Logs: Display Maximum 20 Info
Display Logs: Display Maximum 20 Info
Display Logs: Maximum File Size 80000 Info
Display Logs: Maximum File Size 80000 Info
Display Logs: Included File Prefixes myDEBUG-|AIM_Debug_|SIM_Debug_|Firs... Info
Display Logs: Included File Prefixes myDEBUG-|AIM_Debug_|SIM_Debug_|Firs... Info
Display Logs: Excluded File Prefixes Info
Display Logs: Excluded File Prefixes Info
On Dev site it’s even worse:
Title Value Action
Log Page Parse Time false Info
Log Destination /home/pcs/dev/logs/page_parse_time.log Info
Log Date Format %d/%m/%Y %H:%M:%S Info
Display The Page Parse Time false Info
Log Database Queries false Info
Report All Errors (Admin)? Yes Info
Report All Errors (Admin)? Yes Info
Report All Errors (Store)? Yes
Report All Errors (Store)? Yes Info
Report All Errors: Backtrace on Notice Errors? No Info
Report All Errors: Backtrace on Notices? No Info
Display Logs: Display Maximum 20 Info
Display Logs: Display Maximum 20 Info
Display Logs: Maximum File Size 80000 Info
Display Logs: Maximum File Size 80000 Info
Display Logs: Included File Prefixes myDEBUG-|AIM_Debug_|SIM_Debug_|Firs... Info
Display Logs: Included File Prefixes myDEBUG-|AIM_Debug_|SIM_Debug_|Firs... Info
Display Logs: Excluded File Prefixes Info
Display Logs: Excluded File Prefixes Info

Database upgrade exceptions table shows 2 new entries of cannon create tables customer_groups and customers_to_groups because they already exist.
My exceptions table has 312 entries going back to version 124. Wish I could get file attachment to work, can post if helpful.

These are my prod mods, but remember, I ONLY brought over the database, NOT ANY files from prod
Mods To This Cart
New Admin Pages
Page Name Menu Key
Display
Link
Audit tools Y Audit
Category catalog N Category
Automatic Recover Cart Sales Configuration configuration Y Automatic Recover Cart Sales Configuration
(BOX_CONFIGURATION_DEFAULT) configuration N Link cannot be created
Edit Orders configuration Y Edit Orders
Endicia XML Exporter Configuration configuration Y Endicia XML Exporter Configuration
Endicia XML Exporter Configuration configuration Y Endicia XML Exporter Configuration
GA4 Analytics Settings configuration Y GA4 Analytics Settings
(BOX_CONFIGURATION_GOOGLE_PLUS) configuration Y Link cannot be created
Google Trusted Store Configuration configuration Y Google Trusted Store Configuration
Image Handler5 tools Y Image Handler5
Instant Search configuration Y Instant Search
One-Page Checkout Settings configuration Y One-Page Checkout Settings
Price-list Profile-1 configuration Y Price-list Profile-1
Price-list Profile-2 configuration Y Price-list Profile-2
Price-list Profile-3 configuration Y Price-list Profile-3
Printable Price-list configuration Y Printable Price-list
Specials Listing configuration Y Specials Listing
Structured Data configuration Y Structured Data
Super Orders configuration Y Super Orders
(BOX_CONFIGURATION_TPP) configuration Y Link cannot be created
Ultimate URLs configuration Y Ultimate URLs
Wish List Module configuration Y Wish List Module
Zen Colorbox Settings configuration Y Zen Colorbox Settings
Configure RCS configuration Y Configure RCS
Batch Form Print customers Y Batch Form Print
Super Orders Batch Pages customers N Super Orders Batch Pages
Batch Status Update customers Y Batch Status Update
Super Orders Data Sheet customers N Super Orders Data Sheet
Super Orders Edit Pop-Up customers N Super Orders Edit Pop-Up
Super Orders Shipping Label customers N Super Orders Shipping Label
Disabled Stock reports Y Disabled Stock
Edit Orders customers N Edit Orders
E-mail Archive Manager tools Y E-mail Archive Manager
Endicia XML Exporter tools Y Endicia XML Exporter
Manage Payment Types localization Y Manage Payment Types
Mobishop Template Set extras Y Mobishop Template Set
Mod List tools Y Mod List
Plugin Manager modules Y Plugin Manager
Quick Updates catalog Y Quick Updates
Quick Updates configuration Y Quick Updates
Recover Cart Sales customers Y Recover Cart Sales
Cash Report reports Y Cash Report
Orders Awaiting Payment reports Y Orders Awaiting Payment
Export Shipping/Order Information tools Y Export Shipping/Order Information
Sitemap XML tools Y Sitemap XML
Sitemap XML configuration Y Sitemap XML
Recovered Sales Results reports Y Recovered Sales Results
Sales Report reports Y Sales Report
Display Log Files tools Y Display Log Files
Image Handler5 Uninstall tools N Image Handler5 Uninstall
View Image Handler5 Configuration tools N View Image Handler5 Configuration
Uninstall Ultimate URLs extras Y Uninstall Ultimate URLs
New Database Tables
nochex_sessions
square_payments
so_refunds
un_products_to_wishlists
second_scart
so_payments
nochex_apc_transactions
so_purchase_orders
so_payment_types
scart
un_wishlists
New Modules
Payment: purchaseorder.php
Shipping: usps.php
Order Total: ot_insurance.php
Missing Admin Configuration Pages
This is caused by migrating pre 1.5.0 mods which have entries in Admin->Configuration, without creating admin_pages entries for them.

No missing admin pages found.

[gothstone]

Should have noted, prod php is 7.4, dev PHP is 8.1, and SQL for both is MariaDB 10.6

[gothstone]

In the spirit of a truly clean new site, I exported the following clean tables from the working blank install to my dev site. This should eliminate most issues from old plugins. I'm pretty sure I NEED everything else. And yay, it DID fix the HTTP 500 errors. I can work in admin and storefront on dev and haven't generated any logs yet. So I do have A solution. I'm not sure it's a good one, but its something.
All 7 admin tables
both configuration tables
languages
layout_boxes
all 4 media tables
music_genre
all 4 plugin tables
product_type_layout
query_builder
all 4 record tables
template_select
whos_online

[dbltoe]

Mixing databases is a bad idea. There is no magic wand for moving an older DB to a new upgrade without doing the full exchange.

That said, it looks as if your old site had either lat9 or ceon's URL rewriter.

[16-Sep-2023 17:06:28 UTC] Request URI: /, IP address: 73.67.37.4
--> PHP Fatal error: Uncaught Error: Undefined constant "SEARCH_ENGINE_FRIENDLY_URLS" in /home/pcs/dev/includes/init_includes/init_sefu.php:13
Stack trace:

If you still have the old site up, try turning that off prior to copying the old DB. Then the new site will not be looking for the constant that is not on the new site.

[lat9]

Mixing databases is a bad idea. There is no magic wand for moving an older DB to a new upgrade without doing the full exchange.

That said, it looks as if your old site had either lat9 or ceon's URL rewriter.

[16-Sep-2023 17:06:28 UTC] Request URI: /, IP address: 73.67.37.4
--> PHP Fatal error: Uncaught Error: Undefined constant "SEARCH_ENGINE_FRIENDLY_URLS" in /home/pcs/dev/includes/init_includes/init_sefu.php:13
Stack trace:

If you still have the old site up, try turning that off prior to copying the old DB. Then the new site will not be looking for the constant that is not on the new site.

Actually, the "SEARCH_ENGINE_FRIENDLY_URLS" is a base Zen Cart configuration setting, albeit hidden.

[dbltoe]

I guess I can slack off the rest of the day as I've already learned my "something new".