Upgrade from EE v5 to v6
How Do I?
I am updating a client website from v5 to v6 and run a snag when running the Update Wizard.
Almost immediatly after I started to run the update, I got the follwing error message. The catch is the column DOES exist in that table. Has anyone run into this situation.
“SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘display_avatars’; check that column/key exists:
ALTER TABLE exp_members DROP display_avatars”
I have attached a screenshot of the stack trace.
Same for me. Any solution here?
It looks like the avatars field isn’t there to drop, so it throws an error. There is a conditional check in v7, but it doesn’t look like it’s made it to 6 yet.
Can you try the fix here: system/ee/installer/updates/ud_6_00_00_b_1.php
So in system/ee/installer/updates/ud_6_00_00_b_1.php around line 209, you want to change it to look like
if (ee()->db->field_exists('display_avatars', 'members')) {
ee()->dbforge->drop_column('members', 'display_avatars');
}