MySQL error 1060 encountered during zc_install - Duplicate column name 'logmessage'

[fravac]

Upgrading DB from 1.56 to 1.57 on a test/different domain.

2 errors in log:

MySQL error 1060 encountered during zc_install:
Duplicate column name 'logmessage'
ALTER TABLE zen_admin_activity_log ADD logmessage mediumtext NOT NULL;
---------------

MySQL error 1060 encountered during zc_install:
Duplicate column name 'severity'
ALTER TABLE zen_admin_activity_log ADD severity varchar(9) NOT NULL DEFAULT 'info';
---------------

Compared 3 versions of the admin_activity_log table (before upgrade version, 1.57 fresh install, and currently upgraded version).

My collation is not the same, but otherwise, the 'severity' and 'logmessage' fields both have the same structure in each of the 3 instances.


Am I concerned with this error?


Guessing I can use the Zen Cart Database Conversion Tool to address my latin1_swedish_ci issue after I've upgraded?

[fravac]

To be more concise, I upgraded from 1.5.6c to 1.5.7d

[dbltoe]

Any particular reason as to why you are upgrading to a version that is over three years old? Why not do a database only upgrade to 2.0.1?

[lat9]

To be more concise, I upgraded from 1.5.6c to 1.5.7d

Did you use the zc_install process to perform that upgrade?

[fravac]

Did you use the zc_install process to perform that upgrade?

Yes.

so far, I don't have any error-related issues I'm aware of . just a little concerned about the message.

Any particular reason as to why you are upgrading to a version that is over three years old? Why not do a database only upgrade to 2.0.1?

More than one reason. None of them very good.

My first problem is getting to at least php 7.4 so I can move from Centos 7 to Almalinux 8.

I know that 1.5.7 using php 7.4 supports the stamps.com and taxjar plugins that I use (have another cart on 1.5.7).

Will try to upgrade again once I'm on different server

[dbltoe]

CloudLinux will allow you to keep 5.6 thru 8.2

[DrByte]

2 errors in log:

MySQL error 1060 encountered during zc_install:
Duplicate column name 'logmessage'
ALTER TABLE zen_admin_activity_log ADD logmessage mediumtext NOT NULL;
---------------

MySQL error 1060 encountered during zc_install:
Duplicate column name 'severity'
ALTER TABLE zen_admin_activity_log ADD severity varchar(9) NOT NULL DEFAULT 'info';
---------------

If those errors were only in the Log, and didn't halt your upgrade with a blank white screen, then it was only logging the fact that those individual SQL statements were attempted but didn't complete because they were unnecessary.
zc_install runs all statements individually (with the exception of some specialized grouping overrides, but that's another topic) specifically so that things don't block each other when such situations occur, so it is likely that all subsequent upgrade queries ran correctly.
If you run zc_install again and it tells you no further db upgrade steps are needed, then it's probably fine.

[fravac]

I ran the zc_install again and got the following message:

An existing configure.php file was found. However, your database seems to be current. This suggests you are on a live site. Proceeding with Install will delete the current database contents! Are you sure you want to continue with Install?

Guessing that's telling me no further db upgrade steps are needed?

Thanks DrByte!