2021-05-14, 10:22 PM
I'm running an upgrade from V 1.6.1. Yep, I procrastinated.
I'm at the stage where all the 'Upload' files have been overwritten, I'm at my (example.com/install/upgrade.php) Upgrade Process "Welcome" page, select my ooooold version 1.6.1 from the pulldown, click NEXT and get the following:
------------------------------------------------------
Repairing Database Sequences
Performing necessary upgrade queries...
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1060 - Duplicate column name 'custom_profile_fields'
Query:
ALTER TABLE mybb_adminviews ADD
------------------------------------------------------
Okay, so I go to my database in cPanel, I locate 'mybb_adminviews' and the 'custom_profile_field' column...but I see no duplicate of that column name.
And I haven't a clue how to alter the table by executing a "ADD
Could anyone please advise?
(obviously, I've never done all this before!)
I'm at the stage where all the 'Upload' files have been overwritten, I'm at my (example.com/install/upgrade.php) Upgrade Process "Welcome" page, select my ooooold version 1.6.1 from the pulldown, click NEXT and get the following:
------------------------------------------------------
Repairing Database Sequences
Performing necessary upgrade queries...
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1060 - Duplicate column name 'custom_profile_fields'
Query:
ALTER TABLE mybb_adminviews ADD
custom_profile_fields
text NOT NULL AFTER conditions ------------------------------------------------------
Okay, so I go to my database in cPanel, I locate 'mybb_adminviews' and the 'custom_profile_field' column...but I see no duplicate of that column name.
And I haven't a clue how to alter the table by executing a "ADD
custom_profile_fields
text NOT NULL AFTER conditions" Could anyone please advise?
(obviously, I've never done all this before!)