trac user Brett Profitt wrote on 41484102-01-31

Fixes #3554. Pulled 1.7->1.8 upgrade bootstrapping into a separate function. Made the plugin upgrade that forwards (2011010101) set itself in the processed upgrades.
Changeset: 6e8662a

brettp wrote on 41484109-02-12

I think I have this one working, but anyone having this problem please reopen if errors pop up.

I know we wanted to keep the specific bootstrapping out of core but I couldn't come up with a cleaner way to do it. If someone has a better idea or suggestions please let me know.

trac user bambam wrote on 42645669-11-26

I still have the same error.
I was using version 1.7.10, tried to update to 1.8.8 this didn't work.

Then first updated to version 1.7.15 this goes good.
When i upgrade to version 1.8.01 again this error:

Duplicate column name 'admin'

QUERY: ALTER TABLE elgg_users_entity ADD admin ENUM('yes', 'no') NOT NULL DEFAULT 'no' AFTER banned

Help me out please.

cash wrote on 42649556-02-01

Brett fixed this particular issue - see the commit that was linked above.

This feels more like a support request so I suggest using the forms at http://community.elgg.org/ - join the technical support group. You should link to this ticket here so people can this text. If we determine this is a problem with Elgg, we can open a new ticket.

Here's a little information that will be helpful in tracking this down:

2010040201 is the upgrade for adding the admin column and was pre-Elgg 1.8. If the upgrade to 1.8 is trying to run this, it means that you already have a value for "processed_upgrades" in your datalist table. This should only be possible from a previous failed upgrade to 1.8. Since we don't have any information about the previous failed upgrade, it is impossible to figure out the cause. It appears that you did not restore the database after the failed upgrade the first time and now are stuck with your db being in a bad state. I believe deleting the "processed_upgrades" row in the datalist table should reset you to a valid state. We always recommend backing up a database when running an upgrade. Good luck and please use the community site for further help.