upgrading from 1.5.1 to 2.1.x

[Randolph Hoppe]

Oh boy, I used Gemini to produce this:

CREATE TABLE paypal_testing (
paypal_ipn_id int(11) unsigned NOT NULL AUTO_INCREMENT,
order_id int(11) unsigned NOT NULL DEFAULT '0',
custom varchar(255) NOT NULL,
txn_type varchar(40) NOT NULL,
module_name varchar(40) NOT NULL,
module_mode varchar(40) NOT NULL,
reason_code varchar(40) DEFAULT NULL,
payment_type varchar(40) NOT NULL,
payment_status varchar(32) NOT NULL,
pending_reason varchar(32) DEFAULT NULL,
invoice varchar(128) DEFAULT NULL,
mc_currency char(3) NOT NULL,
first_name varchar(32) NOT NULL,
last_name varchar(32) NOT NULL,
payer_business_name varchar(128) DEFAULT NULL,
address_name varchar(64) DEFAULT NULL,
address_street varchar(254) DEFAULT NULL,
address_city varchar(120) DEFAULT NULL,
address_state varchar(120) DEFAULT NULL,
address_zip varchar(10) DEFAULT NULL,
address_country varchar(64) DEFAULT NULL,
address_status varchar(11) DEFAULT NULL,
payer_email varchar(128) NOT NULL,
payer_id varchar(32) NOT NULL,
payer_status varchar(10) NOT NULL,
payment_date datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
business varchar(128) NOT NULL,
receiver_email varchar(128) NOT NULL,
receiver_id varchar(32) NOT NULL,
txn_id varchar(20) NOT NULL,
parent_txn_id varchar(20) DEFAULT NULL,
num_cart_items tinyint(4) unsigned NOT NULL DEFAULT '1',
mc_gross decimal(7,2) NOT NULL DEFAULT '0.00',
mc_fee decimal(7,2) NOT NULL DEFAULT '0.00',
payment_gross decimal(7,2) DEFAULT NULL,
payment_fee decimal(7,2) DEFAULT NULL,
settle_amount decimal(7,2) DEFAULT NULL,
settle_currency char(3) DEFAULT NULL,
exchange_rate decimal(4,2) DEFAULT NULL,
notify_version decimal(2,1) NOT NULL DEFAULT '0.0',
verify_sign varchar(128) NOT NULL,
last_modified datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
date_added datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
memo text,
PRIMARY KEY (paypal_ipn_id, txn_id),
KEY idx_order_id_zen (order_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

fair enough?

[Shop Suey]

Maybe it is, maybe not.
I don't justice on that.
But IMHO you should know what you do before you. Especially at database work.
For experiments AI is great of course. I myself wouldn't do anything like that.
YES to AI to learn how to navigate and use SQL, if you don't have those skills yet. But NO to AI to "create ABC for me".
But just my 50 cents, of course.

[Randolph Hoppe]

I removed the key name 'idx_profile_name_zen' from admin_profiles, so the install was able to add the key. Now there is no DEBUG being produced

Still not moving into 1.5.7 or is it 8?

7 logs being produced.

Is

Dec 18 2025 16:02 -- checkPhpVersion
FAILED
(
[version] => 8.3.0
[versionTest] => ge
)

Enough to stop it?

[swguy]

Nope. This is not the problem.

[swguy]

At this point I would reload your original database and start the upgrade process again. If you didn't have the ability to do various operations on the database (and it looks like you didn't), who knows what worked and what failed.

[Randolph Hoppe]

OK. Great idea! Thanks, again!

[Randolph Hoppe]

It's been quite a ride so far! 2.1.0 is running with a bootstrap template clone. Database upgrade (eventually) went smoothly!

However, looking in my Debug warning log I see:

PHP Warning: Constant SHOW_PRODUCT_MUSIC_INFO_ARTIST already defined in /home/t.../public_html/laravel/app/Models/ProductTypeLayout.php on line 22.

Any idea what's causing that?

[dbltoe]

https://docs.zen-cart.com/user/troub...ready_defined/